From: Ivan Kohler <ivan@freeside.biz>
Date: Tue, 4 Jun 2013 08:07:02 +0000 (-0700)
Subject: apply the RT 3.8.17/4.0.13 database fix automatically, RT#13852, RT#17928
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=39754a8b5468d95124ee2c0bbcd1c104904d1fe5

apply the RT 3.8.17/4.0.13 database fix automatically, RT#13852, RT#17928
---

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;
 }