View | Details | Raw Unified | Return to bug 14570
Collapse All | Expand All

(-)a/misc/cronjobs/j2a.pl (-5 / +4 lines)
Lines 187-194 if ( not $noaction ) { Link Here
187
        $schema->storage->txn_begin;
187
        $schema->storage->txn_begin;
188
188
189
        my $query = qq|
189
        my $query = qq|
190
            DELETE relationships FROM relationships
190
            DELETE borrower_relationships FROM borrower_relationships
191
            LEFT JOIN borrowers ON ( borrowers.borrowernumber = relationships.guarantee_id )
191
            LEFT JOIN borrowers ON ( borrowers.borrowernumber = borrower_relationships.guarantee_id )
192
            $where
192
            $where
193
        |;
193
        |;
194
        my $sth = $dbh->prepare($query);
194
        my $sth = $dbh->prepare($query);
Lines 232-239 if ( not $noaction ) { Link Here
232
        |;
232
        |;
233
233
234
        my $query = qq|
234
        my $query = qq|
235
            DELETE relationships FROM relationships
235
            DELETE borrower_relationships FROM borrower_relationships
236
            LEFT JOIN borrowers ON ( borrowers.borrowernumber = relationships.guarantee_id )
236
            LEFT JOIN borrowers ON ( borrowers.borrowernumber = borrower_relationships.guarantee_id )
237
            $where
237
            $where
238
        |;
238
        |;
239
        my $sth = $dbh->prepare($query);
239
        my $sth = $dbh->prepare($query);
240
- 

Return to bug 14570