Author Topic: Can not save new identity in r3590  (Read 3128 times)

Offline ABerglund

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 673
Can not save new identity in r3590
« 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?
Arne Berglund
SysAdmin, Internet Services
Lane Education Service District
Eugene, OR, USA

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
Can not save new identity in r3590
« Reply #1 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.
Regards,
Rosali
__________________
MyRoundcube Project (commercial)

Offline ABerglund

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 673
Can not save new identity in r3590
« Reply #2 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.
Arne Berglund
SysAdmin, Internet Services
Lane Education Service District
Eugene, OR, USA