From 845a41b2bab1b9d85221143cf59c9b58ff5a810b Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Tue, 20 Jun 2017 15:03:35 +0200 Subject: [PATCH] Bug 18651: [QA Follow-up] Fix the MAX(issue_id) calculation Found this by inserting the same issue_id in old_issues before checkin: The call to ->search( )->get_column is in scalar context and will return the number of results, i.e. always 1. If you have an issue_id 2 in old_issues, it will crash: DBIx::Class::Storage::DBI::_dbh_execute(): Duplicate entry '2' for key 'PRIMARY' The fix is fairly simple: Put get_column in list context and pick the first array entry. NOTE: Using DBIx's get_column()->max here might look simpler here. Signed-off-by: Marcel de Rooy (cherry picked from commit ee7969d3461e6ce08b4fbfd982c90f263f19f693) Signed-off-by: Fridolin Somers --- C4/Circulation.pm | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/C4/Circulation.pm b/C4/Circulation.pm index 07f1887ca2..e25167d5c5 100644 --- a/C4/Circulation.pm +++ b/C4/Circulation.pm @@ -2186,10 +2186,11 @@ sub MarkIssueReturned { my $old_checkout_data = $issue->unblessed; if ( Koha::Old::Checkouts->find( $issue_id ) ) { - my $new_issue_id = Koha::Old::Checkouts->search( + my $new_issue_id = ( Koha::Old::Checkouts->search( {}, { columns => [ { max_issue_id => { max => 'issue_id' } } ] } - )->get_column('max_issue_id') + 1; + )->get_column('max_issue_id') )[0]; + $new_issue_id++; $issue_id = $new_issue_id; } $old_checkout_data->{issue_id} = $issue_id; -- 2.39.5