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(), 'webmaster@sense-online.nl', 'webmaster@sense-online.nl', 'SENSE', '', '', '--
webmaster@sense-online.nl
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(), 'webmaster@sense-online.nl', 'webmaster@sense-online.nl', 'SENSE', '', '', '--
webmaster@sense-online.nl Welcome to the website of SENSE', 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(), 'webmaster@sense-online.nl', 'webmaster@sense-online.nl', 'SENSE', '', '', '--
webmaster@sense-online.nl 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.