[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 #2 from Magnus Enger <magnus at libriotech.no> ---
After reading
https://stackoverflow.com/questions/10833530/how-to-change-mysql-primary-key-from-signed-to-unsigned
I tried to: 

- Dump the database
- Edit the CREATE TABLE statements for
borrower_message_preferences.borrower_message_preference_id and
borrower_message_transport_preferences.borrower_message_preference_id to make
them BIGINT
- Load the database back in

But alas, this also gave a foreign key error: 

ERROR 1005 (HY000) at line 2442: Can't create table
`koha_hkr`.`borrower_message_preferences` (errno: 150 "Foreign key constraint
is incorrectly formed")

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