Opened 7 years ago

Closed 7 years ago

#1421861 closed Bugs (Fixed)

Database Error

Reported by: nobody Owned by: roundcube
Priority: 5 Milestone:
Component: Database Version: 0.1-alpha
Severity: Keywords:
Cc:

Description

Two folders on my imap server wont load normally in
roundcude when I try to browse to them. Just gives the
loading message and then nothing. Strange thing is if I
browse to something like personal settings and then
back to email the folder will load fine.

Contact me at ryaner_at_redbrick.dcu.ie if you need
further information.

The Error log gives the following with IMAP info following.

[01-Feb-2006 20:48:40 +0000] DB Error: DB Error:
unknown error in
/webtree/r/ryaner/roundcube/program/include/rcube_db.inc
on line 130
[01-Feb-2006 20:48:40 +0000] DB Error: DB Error:
unknown error Query: INSERT INTO cache (created,
user_id, session_id, cache_key, data) VALUES (NOW(), 1,
NULL, 'IMAP.INBOX.AdminsList.msg',
'a:1412:{i:1468;O:14:\"iilbasicheader\":23:{s:2:\"id\";s:4:\"1407\";s:3:\"uid\";s:4:\"1468\";s:7:\"subject\";s:36:\"Re:
[rb-admins] Dave Murphy
(drjolt)\";s:4:\"from\";s:39:\"Dermot Hanley
<dhanley@irish-times.com>\";s:2:\"to\";s:40:\"David
Johnston
<emperor@redbrick.dcu.ie>\";s:2:\"cc\";s:22:\"admins@redbrick.dcu.ie\";s:7:\"replyto\";s:0:\"\";s:11:\"in_reply_to\";s:45:\"20060131140200.GA19295@carbon.redbrick.dcu.ie\";s:4:\"date\";s:31:\"Tue,
31 Jan 2006 15:16:47
+0000\";s:9:\"messageID\";s:47:\"1138720607.29978.65.camel@localhost.localdomain\";s:4:\"size\";s:4:\"4796\";s:8:\"encoding\";s:4:\"7bit\";s:5:\"ctype\";s:10:\"text/plain\";s:5:\"flags\";s:4:\"Seen\";s:9:\"timestamp\";d:1138720634;s:1:\"f\";N;s:4:\"seen\";b:1;s:7:\"deleted\";b:0;s:6:\"recent\";b:0;s:8:\"answered\";b:0;s:4:\"junk\";N;s:12:\"internaldate\";s:20:\"31-Jan-2006
15:17:14\";s:8:\"is_reply\";N;}i:1467;O:14:\"iilbasicheader\"
in
/webtree/r/ryaner/roundcube/program/include/rcube_db.inc
on line 205

Imap info: * CAPABILITY IMAP4rev1 UIDPLUS CHILDREN
NAMESPACE THREAD=ORDEREDSUBJECT THREAD=REFERENCES SORT
QUOTA IDLE AUTH=PLAIN ACL ACL2=UNION cp01 OK CAPABILITY
completed Tried PLAIN: Resource id #23


Change History (3)

comment:1 Changed 7 years ago by tvkbhaskar

Logged In: YES 
user_id=723025

You may please look at changing the max_allowed_packet 
global variable in roundcube mysql database to say 10MB

regards

comment:2 Changed 7 years ago by nobody

Logged In: NO 

Changing the packet size sorted the problem.
Thanks

comment:3 Changed 7 years ago by roundcube

  • Status changed from assigned to closed
Logged In: YES 
user_id=1262041

New caching mechanism should solve this.
Note: See TracTickets for help on using tickets.