Problem with message parsing with >= r326

Thomas Bruederli roundcube at gmail.com
Wed Aug 30 09:05:39 CEST 2006


Looks like no headers at all where returned from the server.

I changed the IMAP command for fetching headers which now sends UID
FETCH together with the message UID. Before, it was just FETCH with the
sequence number. I tried it with several servers and all seemed to
support this command (it's IMAPv4). One reason for this change were
problems with DBMail which returned false answers when trying to resolve
the UID to a sequence number. Now BincIMAP doesn't work... I really hate
those little differences!

The only way to solve this would be to specify the IMAP server in config
or to retry the FETCH command if it failed.

~Thomas


Jim Pingle wrote:
> 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?
> 
> 
> 
> 




More information about the Dev mailing list