[Koha-devel] borrower_message_preference_id reaches limit - quickfix?
Magnus Enger
magnus at libriotech.no
Thu Jan 5 10:35:05 CET 2023
Den 04.01.2023 16:41, skrev Galen Charlton:
> Hi,
>
> On Wed, Jan 4, 2023 at 4:28 AM Magnus Enger <magnus at libriotech.no
> <mailto:magnus at 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
More information about the Koha-devel
mailing list