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

* Your Email Address
* Spam protection	Enter the letters below: .___.__.. ,. .. . [__ \| \| \./ \|\/\|\| \| \| \|__\| \| \| \|\|/\\|
Comment	> 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
Attachment
Watch this ticket