https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35830
--- Comment #24 from Andrii Nugged <[email protected]> --- Indeed. We have: ``` q{INSERT INTO user_permissions (borrowernumber, module_bit, code) SELECT borrowernumber, module_bit, 'merge_borrowers' FROM user_permissions where module_bit = 4 and code = 'edit_borrowers';} ``` what is somewhat-non-idempotent, BUT it will luckily succeed if someone missed 25.05.06 update and went to 25.11.00, but if someone have 25.05.06 then 25.11.00 probably will fail: ``` $> git checkout community/25.05.x && fgrep "Added new permission 'merge_borrowers'" installer/data/mysql/db_revs/*.pl Previous HEAD position was 3f2987eb19f Koha 25.11.00 is here! HEAD is now at aa6597d23ec Update release notes for 25.05.06 release installer/data/mysql/db_revs/250505004.pl: say $out "Added new permission 'merge_borrowers'"; $> git checkout community/25.11.x && fgrep "Added new permission 'merge_borrowers'" installer/data/mysql/db_revs/*.pl Previous HEAD position was aa6597d23ec Update release notes for 25.05.06 release HEAD is now at 3f2987eb19f Koha 25.11.00 is here! installer/data/mysql/db_revs/250600028.pl: say $out "Added new permission 'merge_borrowers'"; ``` because it will try to non-ignore insert for already existing values, thus PRIMARY key fails. -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] https://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/
