INSERT INTO systempreferences VALUES ('OAI-PMH:AutoUpdateSetEmbedItemData',0,'','','YesNo'); UPDATE systempreferences SET variable = 'IllCheckAvailability' WHERE variable = "ILLCheckAvailability"; INSERT INTO systempreferences VALUES ('IllCheckAvailability',0,'','','YesNo'); => FAIL: The last command fails because the good and wrong values cannot coexist
UPDATE systempreferences SET value="23.1200004" WHERE variable like 'version';
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36232 Biblibre Sandboxes <sandboxes@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #163063|0 |1 is obsolete| | --- Comment #6 from Biblibre Sandboxes <sandboxes@biblibre.com> --- Created attachment 163094 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=163094&action=edit Bug 36232: Fix error in DBRev dealing with OAI-PMH:AutoUpdateSetsEmbedItemData typo This patch fixes the case of the wrong syspref variable co-existing with the good one. OAI-PMH:AutoUpdateSetsEmbedItemData is the only case, as the rest of the mispelled ones are just case fixes, which would not trigger the same situation as the `systempreferences` table collation is case-insentitive. To test: 1. Run: $ ktd --shell k$ koha-mysql kohadev 2. Set the version to a prior one: 3. Run: k$ updatedatabase => FAIL: You get this error: ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate entry 'OAI-PMH:AutoUpdateSetsEmbedItemData' for key 'systempreferences.PRIMARY' at ... 4. Apply this patch 5. Repeat 3 => SUCCESS: It works! 6. Sign off :-D Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io> Signed-off-by: Victor Grousset/tuxayo <victor@tuxayo.net> Signed-off-by: David Nind <david@davidnind.com> Signed-off-by: Mohd Hafiz Yusoff <mhby87@gmail.com> -- You are receiving this mail because: You are watching all bug changes.