Bug 14570: (follow-up) fix table name in j2a.pl

Signed-off-by: Agustin Moyano <agustinmoyano@theke.io>
Signed-off-by: Liz Rea <wizzyrea@gmail.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>

diff --git a/misc/cronjobs/j2a.pl b/misc/cronjobs/j2a.pl
index a63666b..73cd963 100755 (executable)
--- a/misc/cronjobs/j2a.pl
+++ b/misc/cronjobs/j2a.pl
@@ -187,8 +187,8 @@ if ( not $noaction ) {
         $schema->storage->txn_begin;
 
         my $query = qq|
-            DELETE relationships FROM relationships
-            LEFT JOIN borrowers ON ( borrowers.borrowernumber = relationships.guarantee_id )
+            DELETE borrower_relationships FROM borrower_relationships
+            LEFT JOIN borrowers ON ( borrowers.borrowernumber = borrower_relationships.guarantee_id )
             $where
         |;
         my $sth = $dbh->prepare($query);
@@ -232,8 +232,8 @@ if ( not $noaction ) {
         |;
 
         my $query = qq|
-            DELETE relationships FROM relationships
-            LEFT JOIN borrowers ON ( borrowers.borrowernumber = relationships.guarantee_id )
+            DELETE borrower_relationships FROM borrower_relationships
+            LEFT JOIN borrowers ON ( borrowers.borrowernumber = borrower_relationships.guarantee_id )
             $where
         |;
         my $sth = $dbh->prepare($query);