hi all,
I have RC 0.4 installed on my FreeBSD 8 server, configured for sqlite. When I try to add an additional identity, RC reports "an error occured while saving".
If I look in the error log, I see this:
[code]
[09-Oct-2010 23:05:09] MDB2 Error: no such field (-19): _doQuery: [Error message: Could not execute statement]
[Last executed query: INSERT INTO identities (changed, "name", "email", "organization", "reply-to", "bcc", "signature", "standard", "html_signature", user_id) VALUES (now(), '
[email protected]', '
[email protected]', 'SENSE', '', '', '--
[email protected] http://www.sense-online.nl
[Native code: 1]
[Native message: table identities has no column named changed]
[09-Oct-2010 23:05:09 +0200]: DB Error: MDB2 Error: no such field Query: _doQuery: [Error message: Could not execute statement] [Last executed query: INSERT INTO identities (changed, "name", "email", "organization", "reply-to", "bcc", "signature", "standard", "html_signature", user_id) VALUES (now(), '
[email protected]', '
[email protected]', 'SENSE', '', '', '--
[email protected] Welcome to the website of SENSE (http://www.sense-online.nl)', 0, 0, '1')] [Native code: 1] [Native message: table identities has no column named changed] in /usr/local/www/roundcubemail-0.4/program/include/rcube_mdb2.php on line 644 (POST /rc/?_task=settings&_action=save-identity)
[09-Oct-2010 23:05:09] MDB2 Error: no such field (-19): lastInsertID: [Error message: Could not get last insert ID]
[Last executed query: INSERT INTO identities (changed, "name", "email", "organization", "reply-to", "bcc", "signature", "standard", "html_signature", user_id) VALUES (now(), '
[email protected]', '
[email protected]', 'SENSE', '', '', '--
[email protected] http://www.sense-online.nl
[Native code: 1]
[Native message: table identities has no column named changed]
[code]
Any ideas what is going wrong here?
Thanks.
The identities table should have a column named "changed" I am guessing that your RoundCube install was upgraded from 0.3.1, try running the update sql data again and see if that fix's the problem.