[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

David Cook <dcook at prosentient.com.au> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |dcook at prosentient.com.au

--- Comment #1 from David Cook <dcook at prosentient.com.au> ---

> 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.