diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2013-06-04 01:07:08 -0700 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2013-06-04 01:07:08 -0700 |
| commit | d6d7984aac204cfb374ac571b3b2871bf6aeabd5 (patch) | |
| tree | fb7da6cbb99d83ab214f3c3da40b3985c8c49543 | |
| parent | 07cf4759def9bfb9da5b94075257ea03f664877c (diff) | |
apply the RT 3.8.17/4.0.13 database fix automatically, RT#13852, RT#17928
| -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; } |