can't save additional profile

[cbrace]

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', 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.

[SKaero]

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.

[cbrace]

OK, running this in the RC directory fixed it:

$ sudo sqlite -init SQL/sqlite.update.sql sqlite.db

Thanks.