Den 04.01.2023 16:41, skrev Galen Charlton:
Hi,

On Wed, Jan 4, 2023 at 4:28 AM Magnus Enger <mag...@libriotech.no <mailto:mag...@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
_______________________________________________
Koha-devel mailing list
Koha-devel@lists.koha-community.org
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : https://www.koha-community.org/
git : https://git.koha-community.org/
bugs : https://bugs.koha-community.org/

Reply via email to