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/8f4f07cd
