[Koha-bugs] [Bug 32556] borrower_message_preference_id reaches limit

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32556

--- Comment #7 from Magnus Enger <magnus at libriotech.no> ---
Thanks for your input, Galen! 

I found a way to make my quickfix work: 

- Dump the database
- Edit the dumped database and fix CREATE TABLE statements for
borrower_message_preferences.borrower_message_preference_id and
borrower_message_transport_preferences.borrower_message_preference_id to make
them BIGINT
- Drop the Koha database
- Create the Koha database
- Load the database-dump back in

The problem was that I was trying to run the dumped database against a
non-empty database. 

Next question then is: Should we change the schema and run Galen's solution as
part of an upgrade, or should we just document the quickfix for those that run
into the problem? And/or change how these message preferences are handled?

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.