diff options
author | Jonathan Prykop <jonathan@freeside.biz> | 2015-10-27 01:15:29 -0500 |
---|---|---|
committer | Jonathan Prykop <jonathan@freeside.biz> | 2015-10-28 23:54:49 -0500 |
commit | c12e66e585bf0a8d7f5fc019cff7c3eb61fe574f (patch) | |
tree | 78ec65bc394cbe9775a8649a57781bb99913b7e8 /FS/FS/queue.pm | |
parent | 31c2a903d66c3a3856ff0075a899fa74f6667eb3 (diff) |
RT#38765: Foreign key error during selfservice signup
Diffstat (limited to 'FS/FS/queue.pm')
-rw-r--r-- | FS/FS/queue.pm | 20 |
1 files changed, 19 insertions, 1 deletions
diff --git a/FS/FS/queue.pm b/FS/FS/queue.pm index 67d124d02..a0654a13c 100644 --- a/FS/FS/queue.pm +++ b/FS/FS/queue.pm @@ -206,9 +206,27 @@ sub delete { } } + my $oldAutoCommit = $FS::UID::AutoCommit; + local $FS::UID::AutoCommit = 0; + my $dbh = dbh; + + foreach my $cust_pay_pending (qsearch('cust_pay_pending',{ jobnum => $self->jobnum })) { + $cust_pay_pending->set('jobnum',''); + my $error = $cust_pay_pending->replace(); + if ( $error ) { + $dbh->rollback if $oldAutoCommit; + return $error; + } + } + my $error = $self->SUPER::delete; - return $error if $error; + if ( $error ) { + $dbh->rollback if $oldAutoCommit; + return $error; + } + $dbh->commit or die $dbh->errstr if $oldAutoCommit; + unlink $reportname if $reportname; ''; |