Roundcube Community Forum

SVN Releases => SVN Discussion => Topic started by: ABerglund on May 03, 2010, 07:26:13 PM

Title: Can not save new identity in r3590
Post by: ABerglund on May 03, 2010, 07:26:13 PM

Unable to save new identity in r3590. Entries in error.log are:

Code: [Select]


[03-May-2010 16:22:00 -0700]: DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_571a8a41fc0e7cc346191c8becf6ddb88483c92a0 FROM 'INSERT INTO identities (changed, `name`, `email`, `organization`, `reply-to`, `bcc`, `signature`, `standard`, `html_signature`, user_id) VALUES (now(), ?, ?, ?, ?, ?, ?, ?, ?, ?)']
[Native code: 1054]
[Native message: Unknown column 'changed' in 'field list']
 in /var/www/html/svn/program/include/rcube_mdb2.php on line 262 (POST /svn/?_task=settings&_action=save-identity)


Is this an error in my DB, or a bug?

Title: Can not save new identity in r3590
Post by: rosali on May 03, 2010, 11:04:42 PM

It looks like you didn't update the database.

ALTER TABLE `identities` ADD INDEX `user_identities_index` (`user_id`, `del`);
ALTER TABLE `identities` ADD `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00' AFTER `user_id`;

There are more changes in the database structure. You have to run the whole update script.

Title: Can not save new identity in r3590
Post by: ABerglund on May 03, 2010, 11:48:44 PM

That would make sense, except I know that I had done so. As confirmed because when I ran it again, it kept telling me that the changes already existed.

But in any case, I babied and nursed the update script to run through again, and it works fine now. Thanks for the clue.