Bug 3008

Summary: Increase 64k text limit for overdue notice file
Product: Koha Reporter: Chris Cormack <chris>
Component: NoticesAssignee: Bugs List <koha-bugs>
Status: RESOLVED FIXED QA Contact:
Severity: normal    
Priority: P3 CC: katrin.fischer, magnus
Version: Main   
Hardware: PC   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:

Description Chris Cormack 2010-05-21 01:05:19 UTC


---- Reported by bchurch@ptfs.com 2009-03-05 13:56:23 ----

The overdue notice file containing letters for patrons without email addresses, which is emailed to libraries, is limited to 64k. As a result a library may not be receiving all the overdue letters that need to be mailed. This limit needs to be increased.

I'm reporting this on behalf of a client whose file was cut off at 44 overdue letters.



--- Bug imported by chris@bigballofwax.co.nz 2010-05-21 01:05 UTC  ---

This bug was previously known as _bug_ 3008 at http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3008

Actual time not defined. Setting to 0.0
The original reporter of this bug does not have
   an account here. Reassigning to the person who moved
   it here: chris@bigballofwax.co.nz.
   Previous reporter was bchurch@ptfs.com.

Comment 1 Magnus Enger 2013-08-31 12:42:09 UTC
Is this still a problem? Sounds like a major problem for large libraries...
Comment 2 Katrin Fischer 2019-05-04 19:17:07 UTC
I am not sure where the limit stems from, does someone have an idea?
Comment 3 Katrin Fischer 2023-10-07 19:45:48 UTC
I believe this might not be true anymore - or at least I don't see where it would come from.

message_queue.content and message_queue.metadata are mediumtext.

https://mariadb.com/kb/en/mediumtext/
A TEXT column with a maximum length of 16,777,215 (224 - 1) characters.