https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36993
Katrin Fischer <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED Resolution|WORKSFORME |--- --- Comment #2 from Katrin Fischer <[email protected]> --- (In reply to Matthew Charlesworth from comment #1) > I was able to solve it by going into the Database and running the following > commands. > > -- Disable foreign key checks > SET FOREIGN_KEY_CHECKS=0; > > -- Drop the existing foreign key constraint > ALTER TABLE aqbudgets DROP FOREIGN KEY aqbudgetperiods_ibfk_1; > > -- Modify the column to set it as NOT NULL > ALTER TABLE aqbudgets MODIFY COLUMN budget_period_id INT NOT NULL; > > -- Add the foreign key constraint back > ALTER TABLE aqbudgets ADD CONSTRAINT aqbudgetperiods_ibfk_1 FOREIGN KEY > (budget_period_id) REFERENCES aqbudgetperiods(budget_period_id); > > -- Enable foreign key checks > SET FOREIGN_KEY_CHECKS=1; > It's great that you were able to solve it, but I will re-open this bug as it's been reported a few times now and I think we need to make sure that we solve it in Koha properly. -- You are receiving this mail because: You are the assignee for the bug. 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/
