Problem with message parsing with >= r326

Jim Pingle lists at
Tue Aug 29 19:21:40 CEST 2006

Since SVN rev 326, I've had problems on one of my Roundcube setups (of course it's the one that's always the most problematic, the BincIMAP/Apache 1.3/PHP5 server)

With 325, I would see headers but no body on most messages. With 326 I see the body but no headers.

I'm also getting an SQL error in the log. I increased the length of the error that gets printed so it would show the whole thing:

[29-Aug-2006 11:52:22 -0400] DB Error: DB Error: syntax error Query: INSERT INTO messages (user_id, del, cache_key, created, idx, uid, subject, `from`, `to`, cc, date, size, headers, structure) VALUES ('2', 0, 'INBOX.msg', now(), '823', '4812', '', '', '', '', FROM_UNIXTIME(), 779, 'O:14:\"iilBasicHeader\":23:{s:2:\"id\";s:3:\"823\";s:3:\"uid\";s:4:\"4812\";s:7:\"subject\";s:0:\"\";s:4:\"from\";N;s:2:\"to\";N;s:2:\"cc\";N;s:7:\"replyto\";N;s:11:\"in_reply_to\";N;s:4:\"date\";N;s:9:\"messageID\";N;s:4:\"size\";s:3:\"779\";s:8:\"encoding\";N;s:5:\"ctype\";N;s:5:\"flags\";s:0:\"\";s:9:\"timestamp\";N;s:1:\"f\";N;s:4:\"seen\";b:0;s:7:\"deleted\";b:0;s:6:\"recent\";b:0;s:8:\"answered\";b:0;s:4:\"junk\";N;s:12:\"internaldate\";s:20:\"29-Aug-2006 04:05:35\";s:8:\"is_reply\";N;}', NULL)
[nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), 779, 'O:14:\"iilBasicHeader\":23:{s:2:\"id\";s:3:\"823\";s:3:\"uid\";s:4:\"48' at line 3] in /usr/home/webmail/roundcubemail/program/include/ on line 479

I have caching disabled in the config, yet it appears to be attempting to write to the cache. It looks like the information isn't getting into the headers at all. The SQL insert is choking because FROM_UNIXTIME() needs an argument but it's getting an empty string.

I'm using the most current version now (327) and the same problem is still there.

On another server (using Courier IMAP, Apache 2, PHP5), it's working just fine.

I'm sure that BincIMAP is partially to blame, and I wish I could drop it but the server's current setup makes it difficult.

Any ideas?

More information about the Dev mailing list