Bug 3008 - Increase 64k text limit for overdue notice file
Summary: Increase 64k text limit for overdue notice file
Status: RESOLVED FIXED
Alias: None
Product: Koha
Classification: Unclassified
Component: Notices (show other bugs)
Version: Main
Hardware: PC All
: P3 normal with 1 vote (vote)
Assignee: Bugs List
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-03-05 01:56 UTC by Chris Cormack
Modified: 2023-10-07 19:45 UTC (History)
2 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.