[Koha-devel] borrower_message_preference_id reaches limit - quickfix?

[Galen Charlton]

Hi,

On Wed, Jan 4, 2023 at 4:28 AM Magnus Enger <magnus at 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 at equinoxOLI.org
https://www.equinoxOLI.org
phone: 877-OPEN-ILS (673-6457)
direct: 770-709-5581
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20230104/b132ec44/attachment.htm>