Attachment #92280 for bug #14570

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




        $schema->storage->txn_begin;

        my $query = qq|
            DELETE borrower_relationships FROM borrower_relationships
            LEFT JOIN borrowers ON ( borrowers.borrowernumber = borrower_relationships.guarantee_id )
            $where
        |;
        my $sth = $dbh->prepare($query);

        |;

        my $query = qq|
            DELETE borrower_relationships FROM borrower_relationships
            LEFT JOIN borrowers ON ( borrowers.borrowernumber = borrower_relationships.guarantee_id )
            $where
        |;
        my $sth = $dbh->prepare($query);
- 

Return to bug 14570

Lines 187-194 if ( not $noaction ) { Link Here

(-)a/misc/cronjobs/j2a.pl (-5 / +4 lines)
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	-