From 581799e1ea9b428127507bf23a69802f4dde7128 Mon Sep 17 00:00:00 2001 From: Agustin Moyano Date: Fri, 17 May 2019 21:10:02 -0300 Subject: [PATCH] Bug 14570: (follow-up) fix table name in j2a.pl Signed-off-by: Agustin Moyano Signed-off-by: Liz Rea Signed-off-by: Tomas Cohen Arazi --- misc/cronjobs/j2a.pl | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/misc/cronjobs/j2a.pl b/misc/cronjobs/j2a.pl index a63666be39..73cd9635d3 100755 --- 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); -- 2.22.1