borrower_message_preference_id reaches limit - quickfix?
Kia ora and happy new year, Koha! Yesterday I reported this bug: Bug 32556 - borrower_message_preference_id reaches limit https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32556 Has anyone else run into this, and found a quickfix that works? I tried dumping the database, changing the id columns from INT to BIGINT, but got a foreign key error when loading the database back in. I have tried to Google this problem, and several solutions suggest turning off foreign key checks temporarily. How risky would that be? Best regaqrds, Magnus Enger Libriotech AS
Hi, On Wed, Jan 4, 2023 at 4:28 AM Magnus Enger <magnus@libriotech.no> wrote:
Bug 32556 - borrower_message_preference_id reaches limit https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32556
Has anyone else run into this, and found a quickfix that works?
I tried dumping the database, changing the id columns from INT to BIGINT, but got a foreign key error when loading the database back in.
I responded in the bug, but it is possible to remove and recreate the specific foreign key constraint that references borrower_message_preference_id when changing the type of that column and its referrer. Regards, Galen -- Galen Charlton Implementation and IT Manager Equinox Open Library Initiative gmc@equinoxOLI.org https://www.equinoxOLI.org phone: 877-OPEN-ILS (673-6457) direct: 770-709-5581
Den 04.01.2023 16:41, skrev Galen Charlton:
Hi,
On Wed, Jan 4, 2023 at 4:28 AM Magnus Enger <magnus@libriotech.no <mailto:magnus@libriotech.no>> wrote:
Bug 32556 - borrower_message_preference_id reaches limit https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32556 <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32556>
Has anyone else run into this, and found a quickfix that works?
I tried dumping the database, changing the id columns from INT to BIGINT, but got a foreign key error when loading the database back in.
I responded in the bug, but it is possible to remove and recreate the specific foreign key constraint that references borrower_message_preference_id when changing the type of that column and its referrer.
Thanks, Galen! I was able to modify my dump/edit/load approach to fix the problem. I also documented this in Bugzilla. Best regards, Magnus
participants (2)
-
Galen Charlton -
Magnus Enger