https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18651
--- Comment #66 from Katrin Fischer <[email protected]> --- I've tested the patches for 16.11.x, but I think this is still pretty problematic: 1) Unable to check-in more than one problematic issue at once - Check out some items - Check them in again - Restart MySql - Check out some items again - Check them in all at once using the checkboxes in circulation => Only the first item will be returned, the others report: Unable to check in 2) Once out of sync, PKs stay out of sync - Check out some items - Check them in again - Restart MySQL - Check item out => issue_id will be in old_issues already, say it's 8 - Check the item in => issue_id in old_issues is changed, say 9 - Check out next item => issues.issue_id is 9 - Check in item => old_issues.issue_id is changed to 10 ... So I think we will keep changing numbers once the bug manifested, as the PK is never fixed. Not sure if I might have a thinking error there? Could we use something like this to fix the PK when we notice that the issue_id has to be changed in order to be able to move it? ALTER TABLE issues AUTO_INCREMENT = (bigger max(issue_id) from old_issues and issues) +1 -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
