From d7869d00dc28025c7c18fdcc3de25b5e7b64fa1a 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 --- 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.20.1 (Apple Git-117)