https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37820 Jonathan Druart <jonathan.druart@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jonathan.druart@gmail.com -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37820 --- Comment #1 from Emmi Takkinen <emmi.takkinen@koha-suomi.fi> --- Created attachment 171010 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=171010&action=edit Bug 37820: Upgrade fails at 23.12.00.023 [Bug 36993] If table aqbudgets is miissing foreign key 'aqbudgetperiods_ibfk_1' database update fails on "Can't DROP FOREIGN KEY" error. To test: 1. Remove changes made in bug 32132, drop foreign key aqbudgetperiods_ibfk_1 and downgrade your database: - ALTER TABLE aqbudgets MODIFY COLUMN `budget_period_id` INT(11) NULL; - UPDATE aqbudgets SET budget_period_id = NULL WHERE budget_period_id IN(SELECT budget_period_id FROM aqbudgetperiods WHERE budget_period_description = "Budget for funds without budget"); - DELETE FROM aqbudgetperiods WHERE budget_period_description = "Budget for funds without budget"; - ALTER TABLE aqbudgets DROP FOREIGN KEY aqbudgetperiods_ibfk_1; - UPDATE systempreferences SET value="23.1200022" WHERE variable = "Version; 2. Upgrade your database (e.g. running installer/data/mysql/updatedatabase.pl) => Update fails on error "Can't DROP FOREIGN KEY `aqbudgetperiods_ibfk_1`;...". 4. Apply this patch. 5. Try to update your database again. => Database should now be upgraded succesfully. => Confirm table aqbudgets now contains 'aqbudgetperiods_ibfk_1'. -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37820 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Keywords| |RM_priority -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37820 Jonathan Druart <jonathan.druart@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #171010|0 |1 is obsolete| | --- Comment #2 from Jonathan Druart <jonathan.druart@gmail.com> --- Created attachment 171051 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=171051&action=edit Bug 37820: Upgrade fails at 23.12.00.023 [Bug 36993] If table aqbudgets is miissing foreign key 'aqbudgetperiods_ibfk_1' database update fails on "Can't DROP FOREIGN KEY" error. To test: 1. Remove changes made in bug 32132, drop foreign key aqbudgetperiods_ibfk_1 and downgrade your database: - ALTER TABLE aqbudgets MODIFY COLUMN `budget_period_id` INT(11) NULL; - UPDATE aqbudgets SET budget_period_id = NULL WHERE budget_period_id IN(SELECT budget_period_id FROM aqbudgetperiods WHERE budget_period_description = "Budget for funds without budget"); - DELETE FROM aqbudgetperiods WHERE budget_period_description = "Budget for funds without budget"; - ALTER TABLE aqbudgets DROP FOREIGN KEY aqbudgetperiods_ibfk_1; - UPDATE systempreferences SET value="23.1200022" WHERE variable = "Version; 2. Upgrade your database (e.g. running installer/data/mysql/updatedatabase.pl) => Update fails on error "Can't DROP FOREIGN KEY `aqbudgetperiods_ibfk_1`;...". 4. Apply this patch. 5. Try to update your database again. => Database should now be upgraded succesfully. => Confirm table aqbudgets now contains 'aqbudgetperiods_ibfk_1'. Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org> -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37820 Marcel de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #171051|0 |1 is obsolete| | --- Comment #3 from Marcel de Rooy <m.de.rooy@rijksmuseum.nl> --- Created attachment 171127 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=171127&action=edit Bug 37820: Upgrade fails at 23.12.00.023 [Bug 36993] If table aqbudgets is miissing foreign key 'aqbudgetperiods_ibfk_1' database update fails on "Can't DROP FOREIGN KEY" error. To test: 1. Remove changes made in bug 32132, drop foreign key aqbudgetperiods_ibfk_1 and downgrade your database: - ALTER TABLE aqbudgets MODIFY COLUMN `budget_period_id` INT(11) NULL; - UPDATE aqbudgets SET budget_period_id = NULL WHERE budget_period_id IN(SELECT budget_period_id FROM aqbudgetperiods WHERE budget_period_description = "Budget for funds without budget"); - DELETE FROM aqbudgetperiods WHERE budget_period_description = "Budget for funds without budget"; - ALTER TABLE aqbudgets DROP FOREIGN KEY aqbudgetperiods_ibfk_1; - UPDATE systempreferences SET value="23.1200022" WHERE variable = "Version; 2. Upgrade your database (e.g. running installer/data/mysql/updatedatabase.pl) => Update fails on error "Can't DROP FOREIGN KEY `aqbudgetperiods_ibfk_1`;...". 4. Apply this patch. 5. Try to update your database again. => Database should now be upgraded succesfully. => Confirm table aqbudgets now contains 'aqbudgetperiods_ibfk_1'. Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org> Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37820 --- Comment #4 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Thanks Emmi for staying on the case here! -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37820 --- Comment #5 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Pushed for 24.11! Well done everyone, thank you! -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37820 Wainui Witika-Park <wainuiwitikapark@catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |wainuiwitikapark@catalyst.n | |et.nz Status|Pushed to oldoldstable |Needs documenting Version(s)|24.11.00 |24.11.00,24.05.11 released in| | --- Comment #7 from Wainui Witika-Park <wainuiwitikapark@catalyst.net.nz> --- Not backporting to 22.11 -- You are receiving this mail because: You are watching all bug changes.