Hi
Just got the CVS, got the same error.. I applied the patch, it seems to work..
Please confirm us if it's the right method.
Thanks
Nicolas
-----Message d'origine----- De : Carlos Galisteo de Cabo [mailto:cgalisteo@k-rolus.net] Envoyé : mardi 24 janvier 2006 20:35 À : dev@lists.roundcube.net Objet : DB error after cvs update
Hi.
After my early morning cvs update I get the following error when reading messages:
DB Error in /var/www/roundcubemail/program/include/rcube_db.inc (427): DB
Error: no such field Query: INSERT INTO messages (user_id, del, cache_key,
created, idx, uid, subject, from, to, cc, date, size, headers) [private
data here ;)]
I've fixed it by creating the missing field 'created':
ALTER TABLE messages ADD created DATETIME DEFAULT '0000-00-00 00:00:00'
NOT NULL AFTER cache_key ;
I suppose (something like)this to be included in a further *.update.sql, meanwhile, here is my workaround just for the record.