summaryrefslogtreecommitdiff
path: root/FS/FS/TicketSystem.pm
diff options
context:
space:
mode:
authorIvan Kohler <ivan@freeside.biz>2013-06-04 01:07:02 -0700
committerIvan Kohler <ivan@freeside.biz>2013-06-04 01:07:02 -0700
commit39754a8b5468d95124ee2c0bbcd1c104904d1fe5 (patch)
treef461fe9d4f193a9fbfcaa035727a68dafaf11652 /FS/FS/TicketSystem.pm
parent7588a4ac90a9b07c08a3107cd1107d773be1c991 (diff)
apply the RT 3.8.17/4.0.13 database fix automatically, RT#13852, RT#17928
Diffstat (limited to 'FS/FS/TicketSystem.pm')
-rw-r--r--FS/FS/TicketSystem.pm11
1 files changed, 11 insertions, 0 deletions
diff --git a/FS/FS/TicketSystem.pm b/FS/FS/TicketSystem.pm
index 165856e..7b18575 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;
}