[Tickets #5646] Problem with MySQL and many filter rules

[bugs at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=5646
-----------------------------------------------------------------------
 Ticket             | 5646
 Created By         | burghardt at riege.com
 Summary            | Problem with MySQL and many filter rules
 Queue              | Ingo
 Version            | 1.1.3
 Type               | Bug
 State              | Unconfirmed
 Priority           | 2. Medium
 Owners             | 
-----------------------------------------------------------------------


burghardt at riege.com (2007-08-20 04:26) wrote:

Hello,

using the current stable release of Horde and Ingo in conjunction with
Cyrus IMAPD 2.2.12 (+Sieve) and MySQL 4.1.20, we discovered the following
problem:

* a user had a lot of rules
* he added one rule and the rule overview on the web page became empty

On database level happened:
* the 'pref_value' field (type: text) in the 'horde_prefs' table was
filled with 65535 characters as all rules are written with a special syntax
to this field. 
* The final rule was cut off in the middle of the description entry
because it did not fit completely into to database field anymore
* As the syntax was broken the web page became empty.

Probably, it will be better to save the filter rules into an own database
table with each rule as one data entry.

Best regards,
Heiko