Re: [RCD] Can not save the "Display Name" and "Email Address" setting

On 19.10.2010 16:47, johnw wrote:

[19-Oct-2010 22:45:36] MDB2 Error: no such field (-19): prepare: [Error message: Unable to create prepared statement handle] [Last executed query: DEALLOCATE PREPARE mdb2_statement_mysqli_2e215a59789b633f24647b313a960c2930a335e8c] [Native code: 1054] [Native message: Unknown column 'changed' in 'field list']

[19-Oct-2010 22:45:36 +0800]: DB Error: prepare: [Error message: Unable to create prepared statement handle] [Last executed query: DEALLOCATE PREPARE mdb2_statement_mysqli_2e215a59789b633f24647b313a960c2930a335e8c] [Native code: 1054] [Native message: Unknown column 'changed' in 'field list'] in /httpd/roundcubemail/program/include/rcube_mdb2.php on line 268 (POST /webmail/?_task=settings&_action=save-identity)

searching the mysql.update.sql script:

$ grep -i changed mysql.update.sql ADD INDEX changed_index (changed); ALTER TABLE identities ADD changed datetime NOT NULL DEFAULT '1000-01-01 00:00:00' AFTER user_id; changed datetime NOT NULL DEFAULT '1000-01-01 00:00:00',

most probably, you exported your roundcube database *including* "drop table if exists" commands. thus, your dumpfile will recreate the hole database and restore the backup as it was at the time of the export.

please use the "-f" switch and re-apply the mysql.update.sql script (already pointed out a couple of days ago)

please post the output to the list

thanks, raoul _______________________________________________ List info: http://lists.roundcube.net/dev/ BT/aba52c80