I'm currently using Round Cube 0.1rc2 and I'm getting some error that is caused, I think, by my MySQL server that is in Strict Mode.
When I first logged in, everything seems fine. But when you write a message for the first time, no identities were created (and no "From:" is set to the mail). In the error log, I get this error :
[23-Nov-2007 17:12:17 -0500] DB Error: DB Error: unknown error Query: INSERT INTO identities (user_id, del, standard, name, email) VALUES (1, 0, 1, '', 'sfilteau@exemple.com') [nativecode=1364 ** Field 'signature' doesn't have a default value] in /var/www/exemple.com/mail/program/include/rcube_db.inc on line 505
I get another error like that when I try to insert a contact with the recipients of my mail :
[23-Nov-2007 17:20:46 -0500] DB Error: DB Error: unknown error Query: INSERT INTO contacts (user_id, changed, del, `name`, `email`) VALUES ('1', now(), 0, 'Losamigos', 'losamigos@exemple.com') [nativecode=1364 ** Field 'vcard' doesn't have a default value] in /var/www/exemple.com/mail/program/include/rcube_db.inc on line 505
I use the mysqli extension with PHP5.2.2, MySQL 5.0.22 on Ubuntu 6.06.
To set MySQL in STRICT MODE, I set
sql_mode = "STRICT_TRANS_TABLES"
in the [mysqld] section of the MySQL configuration file (my.cnf)
Overall, I'm really impressed of your software