DB Errors while listing mails - Dev

16 Jan 2006


      Hi
I have a Qmail Server/Courrier setup running on CentOS 4.x . I have
installed the CVS version (fetched two days ago) of RoundCube on the
server for webmail access. For some reason, I get these errors
frquently while listing mails in Inbox:
DB Error in /var/www/htdocs/rmail/program/include/rcube_db.inc (437):
DB Error: unknown error Query: INSERT INTO messages (user_id, del,
cache_key, idx, uid, subject, "from", "to", cc, date, size, headers)
VALUES ('1', 0, 'INBOX.msg', '3', '1053', 'Re: WSA DELHI DR NOTE FOR
FDEL/TOR/17745', 'nikhil ', 'ravi ', FALSE, '2006-01-16 13:10:38',
40768, 'O:14:"iilBasicHeader":23:{s:2:"id";s:1:"3";s:3:"uid";s:4:"1053";s:7:"subject";s:40:"Re:
WSA DELHI DR NOTE FOR FDEL/TOR/17745";s:4:"from";s:28:""nikhil"
";s:2:"to";s:26:""ravi" ";s:2:"cc";
DB Error in /var/www/htdocs/rmail/program/include/rcube_db.inc (437):
DB Error: unknown error Query: INSERT INTO messages (user_id, del,
cache_key, idx, uid, subject, "from", "to", cc, date, size, headers)
VALUES ('1', 0, 'INBOX.msg', '4', '1054', 'Re: b/l no. 750020156 -
container no. maeu 8249790/40''hc for istanbul [Our Ref:MUMB85D1 Your
Ref:MUMC59C9]', 'pradhan ', 'ravi , IBT ', FALSE, '2006-01-16
13:11:12', 54804,
'O:14:"iilBasicHeader":23:{s:2:"id";s:1:"4";s:3:"uid";s:4:"1054";s:7:"subject";s:108:"Re:
b/l no. 750020156 - container no. maeu 8249
DB Error in /var/www/htdocs/rmail/program/include/rcube_db.inc (437):
DB Error: unknown error Query: INSERT INTO messages (user_id, del,
cache_key, idx, uid, subject, "from", "to", cc, date, size, headers)
VALUES ('1', 0, 'INBOX.msg', '6', '1056', 'RE: b/l no. 750020156 -
container no. maeu 8249790/40''hc for istanbul [Our Ref:MUMB85D1 Your
Ref:MUMC59C9]', 'IBT ', '''pradhan'' , ''ravi'' ', FALSE, '2006-01-16
13:12:50', 46904,
'O:14:"iilBasicHeader":23:{s:2:"id";s:1:"6";s:3:"uid";s:4:"1056";s:7:"subject";s:108:"RE:
b/l no. 750020156 - container no. m
DB Error in /var/www/htdocs/rmail/program/include/rcube_db.inc (437):
DB Error: unknown error Query: INSERT INTO messages (user_id, del,
cache_key, idx, uid, subject, "from", "to", cc, date, size, headers)
VALUES ('1', 0, 'INBOX.msg', '12', '1062', 'Fw: MANSA Advisory - ST on
Doc charges', 'nikhil ', ', 4d@remindme.com', FALSE, '2006-01-16
14:31:07', 57912,
'O:14:"iilBasicHeader":23:{s:2:"id";s:2:"12";s:3:"uid";s:4:"1062";s:7:"subject";s:38:"Fw:
MANSA Advisory - ST on Doc charges";s:4:"from";s:28:""nikhil"
";s:2:"to";s:38:", <4d@
DB Error in /var/www/htdocs/rmail/program/include/rcube_db.inc (437):
DB Error: unknown error Query: INSERT INTO messages (user_id, del,
cache_key, idx, uid, subject, "from", "to", cc, date, size, headers)
VALUES ('1', 0, 'INBOX.msg', '14', '1064', 'RE: 11802-01 ****
CONTAINER # TRIU5792665 / B/L SAFM750051572******** TOP URGENT ****
TOP URGENT *****', 'Maria Medina ', 'Kim Costew , USASCLCRCIMP , Chris
Hellow , Patri', FALSE, '2006-01-16 14:59:02', 6265,
'O:14:"iilBasicHeader":24:{s:2:"id";s:2:"14";s:3:"u
DB Error in /var/www/htdocs/rmail/program/include/rcube_db.inc (437):
DB Error: unknown error Query: INSERT INTO messages (user_id, del,
cache_key, idx, uid, subject, "from", "to", cc, date, size, headers)
VALUES ('1', 0, 'INBOX.msg', '15', '1065', 'RE: OUT STANDING', 'Mihir
Kotecha ', '''ravi'' , ''kumar'' , ''niren'' , ''bhavesh'' , ''saten',
FALSE, '2006-01-16 17:01:09', 3791,
'O:14:"iilBasicHeader":24:{s:2:"id";s:2:"15";s:3:"uid";s:4:"1065";s:7:"subject";s:16:"RE:
OUT STANDING";s:4:"from";s:36:""Mihir K
The listing though continues after these errors. I have also posted
this on the  bug tracker
(https://sourceforge.net/tracker/index.php?func=detail&aid=1407521&gr...),
but I thought someone might have already solved this problem on the
mailing list.
Regards
Amitabh