From 39754a8b5468d95124ee2c0bbcd1c104904d1fe5 Mon Sep 17 00:00:00 2001
From: Ivan Kohler <ivan@freeside.biz>
Date: Tue, 4 Jun 2013 01:07:02 -0700
Subject: [PATCH] apply the RT 3.8.17/4.0.13 database fix automatically,
 RT#13852, RT#17928

---
 FS/FS/TicketSystem.pm | 11 +++++++++++
 1 file changed, 11 insertions(+)

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