This is a known bug. for additional information: http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html
-------- Original Message -------- Subject: MySQL folder caching Date: Thu, 13 Oct 2005 16:57:09 -0700 From: shaun walbridge tyrian@dumpstermonkey.com To: dev@lists.roundcube.net
Something that is worth mentioning in the documentation is that MySQL is configured on many machines to default to a maximum query size (max_allowed_packet) of 1M. With approximately 1600 messages in my inbox, the attempt to generate a cache of the INBOX folder (a 1.2 MB query) threw unknown errors:
DB Error: unknown error in /www/roundcubemail/program/include/rcube_db.inc on line 124
The resolution is simple enough: In the [mysqld] section of my.cnf, change the max_allowed_packet to a larger value: set-variable = max_allowed_packet=16M
cheers, Shaun Walbridge
Jeremy Aarons wrote:
I've just installed Roundcube and I am very impressed. But I have noticed one very annoying bug. Whenever I try to open an email message with a large attachment (over ~1Mb) a get a bunch of SQL errors. The text of the message opens fine, but the attachment tries to open as unencoded garbled text. The SQL error messages I get are:
DB Error in .../mail/program/include/rcube_db.inc (129): DB Error: unknown error DB Error in .../mail/program/include/rcube_db.inc (204): DB Error: unknown error Query: (created, user_id, session_id, cache_key, data) VALUES (NOW(), ...[and the rest of the message text ...]
Is there an easy fix for this, or is it something to do with a SQL limitation?
I'm using v0.1-20051021
j.