https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37820
Marcel de Rooy <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #171051|0 |1 is obsolete| | --- Comment #3 from Marcel de Rooy <[email protected]> --- 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 <[email protected]> Signed-off-by: Marcel de Rooy <[email protected]> -- 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/
