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/rcube_db.inc 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?
