https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36993 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED Resolution|WORKSFORME |--- --- Comment #2 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- (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.