diff options
author | Ivan Kohler <ivan@freeside.biz> | 2013-06-04 01:07:02 -0700 |
---|---|---|
committer | Ivan Kohler <ivan@freeside.biz> | 2013-06-04 01:07:02 -0700 |
commit | 39754a8b5468d95124ee2c0bbcd1c104904d1fe5 (patch) | |
tree | f461fe9d4f193a9fbfcaa035727a68dafaf11652 /FS | |
parent | 7588a4ac90a9b07c08a3107cd1107d773be1c991 (diff) |
apply the RT 3.8.17/4.0.13 database fix automatically, RT#13852, RT#17928
Diffstat (limited to 'FS')
-rw-r--r-- | FS/FS/TicketSystem.pm | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/FS/FS/TicketSystem.pm b/FS/FS/TicketSystem.pm index 165856e5f..7b1857527 100644 --- a/FS/FS/TicketSystem.pm +++ b/FS/FS/TicketSystem.pm @@ -319,6 +319,17 @@ sub _upgrade_data { } } + #Pg-specific + my $cve_2013_3373_sql = q( + UPDATE Tickets SET Subject = REPLACE(Subject,E'\n','') + ); + #need this for mysql + #UPDATE Tickets SET Subject = REPLACE(Subject,'\n',''); + + my $cve_2013_3373_sth = $dbh->prepare( $cve_2013_3373_sql) + or die $dbh->errstr; + $cve_2013_3373_sth->execute or die $cve_2013_3373_sth->errstr; + return; } |