https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32556
David Cook <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #1 from David Cook <[email protected]> --- > Two questions: > > 1. How do we fix this for sites that reach the limit? > > 2. How do we make sure this never happens? > > To extend the period before this happens, it might be a quick fix to change > the borrower_message_preference_id column from SIGNED (the default) to > UNSIGNED. As far as I can tell, this would double the number of IDs the > column can hold. It might make more sense to switch from SIGNED INT to SIGNED BIGINT as the maximum value for SIGNED BIGINT is 9,223,372,036,854,775,807 That would make it much less likely to hit the max value limit. > A better solution might be to make the borrower_message_preferences update > in place, and not generate new borrower_message_preference_id's every time > they are updated? That's probably a better solution although it would involve more elaborate coding. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
