[Koha-bugs] [Bug 18242] Move of checkouts to old_issues is not handled correctly
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Thu Aug 24 16:06:49 CEST 2017
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18242
Sophie MEYNIEUX <sophie.meynieux at biblibre.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |sophie.meynieux at biblibre.co
| |m
--- Comment #32 from Sophie MEYNIEUX <sophie.meynieux at biblibre.com> ---
This patch does not always work for 16.11
When you change issue_id with max(issue_id)+1 from old_issues but try to insert
it into issues, you may have a primary key conflict.
my $new_issue_id = $dbh->selectrow_array(q|SELECT MAX(issue_id)+1 FROM
old_issues|);
$dbh->do(
q|UPDATE issues SET issue_id = ? WHERE issue_id = ?|,
undef, $new_issue_id, $issue_id
);
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list