Maybe you should upgrade your MySQL version.

Check your database and apache logs.

On Tue, 22 Nov 2005, Tanel Raja wrote:

Hello there,

What are the demans for software to use Roundcube. I mean I installed the Roundcube from CVS, confiured everything there is toconfigure, but I'm still getting errors such as:

*DB Error in /export/www/www.fm.ee/roundcube/roundcubemail/program/include/rcube_db.inc (150):* DB Error: unknown error; QUERY: INSERT INTO cache (created, user_id, session_id, cache_key, data) VALUES (now(), ?, ?, ?, ?)

while loading inbox (which take quite a lot of time -- because of the error probably)

I'm using: Mysql -- 3.23.49 PHP -- PHP 4.3.10 Apache -- 1.3.26

Any idea if this stuff is current enough to run RoundCube?

P

--

Blog -- http://fm.ee/pronto/

Yep .. max_allowed_packet did the trick .. I also upgraded mysql into 4.x, even though it was unnecessary. I had to do it sooner or later, so why not now.

Anyway ... the problem went away, but I found out that there are still few things wrong. First of all the system does write cache entries very selectively. In other words whenever I check my mailbox it always fetches whole bunch from server which means that when I open the inbox the courier cpu usage hits the ceiling, rendering the sofwtare intolerably slow. I actually got rid of it by deleting about 1000 mails, but this is not supposed to happen, I think. When I have like few hundred mails everything is nice and dandy.

P

On 11/22/05, Stephen webshifter@webshifter.com wrote:

Hi,I wrote in with this problem just a few days ago - I followed the link provided by Thomas and implemented the my.cnf fix from that page. Specifically, I created the file /etc/my.cnf and put in it:

[mysqld] set-variable = max_allowed_packet=16M

Then I restarted mysql and it completely fixed the problem. You probably also want to upgrade mysql if you can

Regards, Stephen

On 22-Nov-05, at 9:25 AM, Thomas Bruederli wrote:

This problem is known but has nothing to do with your system configuration: http://lists.dorkzilla.org/archive/roundcube-dev/2005Nov/0925.html

You can switch off caching in config/main.inc.php to avoid these errors.

Regards, Thomas

Tanel Raja wrote:

Hello there,

What are the demans for software to use Roundcube. I mean I installed the Roundcube from CVS, confiured everything there is toconfigure, but I'm still getting errors such as:

*DB Error in /export/www/www.fm.ee/roundcube/roundcubemail/program/include/rcube_db.inchttp://www.fm.ee/roundcube/roundcubemail/program/include/rcube_db.inc (150): * DB Error: unknown error; QUERY: INSERT INTO cache (created, user_id, session_id, cache_key, data) VALUES (now(), ?, ?, ?, ?)

while loading inbox (which take quite a lot of time -- because of the error probably)

I'm using: Mysql -- 3.23.49 PHP -- PHP 4.3.10 Apache -- 1.3.26

Any idea if this stuff is current enough to run RoundCube?

P

--

Blog -- http://fm.ee/pronto/

--

Blog -- http://fm.ee/pronto/