Author Topic: Roundcube can't save settings  (Read 51485 times)

Offline Beretta92

  • Newbie
  • *
  • Posts: 2
Roundcube can't save settings
« on: July 29, 2012, 11:13:58 AM »
Hi all,
I am running on a Debian Squeeze with ISPconfig 3. I updated today from debian's 0.7.1 package to the backported 0.7.2. But nobody can get their address books back, and it won't save any settings, getting an error every times.
Please help me, here are parts of my log:


Code: [Select]
[29-Jul-2012 16:15:15 +0200]: DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_323baea1fb37b4baa4d4f8b1090ad273b537af798 FROM 'INSERT INTO identities (changed, `name`, `email`, `organization`, `reply-to`, `bcc`, `standard`, `signature`, `html_signature`, user_id) VALUES (now(), ?, ?, ?, ?, ?, ?, ?, ?, ?)']
[Native code: 1054]
[Native message: Unknown column 'changed' in 'field list']
 in /usr/share/roundcube/program/include/rcube_mdb2.php on line 293 (POST /webmail/?_task=settings&_action=save-identity)
[29-Jul-2012 16:16:15] PHP Deprecated:  Assigning the return value of new by reference is deprecated in /usr/share/php/MDB2.php on line 393
[29-Jul-2012 16:16:15] PHP Deprecated:  Assigning the return value of new by reference is deprecated in /usr/share/php/MDB2.php on line 2647
[29-Jul-2012 16:16:18] PHP Deprecated:  Assigning the return value of new by reference is deprecated in /usr/share/php/MDB2.php on line 393
[29-Jul-2012 16:16:18] PHP Deprecated:  Assigning the return value of new by reference is deprecated in /usr/share/php/MDB2.php on line 2647
[29-Jul-2012 16:16:20] PHP Deprecated:  Assigning the return value of new by reference is deprecated in /usr/share/php/MDB2.php on line 393
[29-Jul-2012 16:16:20] PHP Deprecated:  Assigning the return value of new by reference is deprecated in /usr/share/php/MDB2.php on line 2647
[29-Jul-2012 16:16:20] PHP Deprecated:  Assigning the return value of new by reference is deprecated in /usr/share/php/MDB2.php on line 393
[29-Jul-2012 16:16:20] PHP Deprecated:  Assigning the return value of new by reference is deprecated in /usr/share/php/MDB2.php on line 2647
[29-Jul-2012 16:16:32] PHP Deprecated:  Assigning the return value of new by reference is deprecated in /usr/share/php/MDB2.php on line 393
[29-Jul-2012 16:16:32] PHP Deprecated:  Assigning the return value of new by reference is deprecated in /usr/share/php/MDB2.php on line 2647
[29-Jul-2012 16:16:33] MDB2 Error: no such field (-19): _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_7e98442114b360ef6269b01ad2b45312776944ce5 FROM 'INSERT INTO identities (changed, `email`, `name`, `standard`, user_id) VALUES (now(), ?, ?, ?, ?)']
[Native code: 1054]
[Native message: Unknown column 'changed' in 'field list']

[29-Jul-2012 16:16:33 +0200]: DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_7e98442114b360ef6269b01ad2b45312776944ce5 FROM 'INSERT INTO identities (changed, `email`, `name`, `standard`, user_id) VALUES (now(), ?, ?, ?, ?)']
[Native code: 1054]
[Native message: Unknown column 'changed' in 'field list']
 in /usr/share/roundcube/program/include/rcube_mdb2.php on line 293 (POST /webmail/?_task=login&_action=login)
[29-Jul-2012 16:16:33] PHP Deprecated:  Assigning the return value of new by reference is deprecated in /usr/share/php/MDB2.php on line 393
[29-Jul-2012 16:16:33] PHP Deprecated:  Assigning the return value of new by reference is deprecated in /usr/share/php/MDB2.php on line 2647
[29-Jul-2012 16:16:33] PHP Deprecated:  Assigning the return value of new by reference is deprecated in /usr/share/php/MDB2.php on line 393
[29-Jul-2012 16:16:33] PHP Deprecated:  Assigning the return value of new by reference is deprecated in /usr/share/php/MDB2.php on line 393
[29-Jul-2012 16:16:33] PHP Deprecated:  Assigning the return value of new by reference is deprecated in /usr/share/php/MDB2.php on line 2647
[29-Jul-2012 16:16:33] PHP Deprecated:  Assigning the return value of new by reference is deprecated in /usr/share/php/MDB2.php on line 2647
[29-Jul-2012 16:16:37] PHP Deprecated:  Assigning the return value of new by reference is deprecated in /usr/share/php/MDB2.php on line 393
[29-Jul-2012 16:16:37] PHP Deprecated:  Assigning the return value of new by reference is deprecated in /usr/share/php/MDB2.php on line 2647
[29-Jul-2012 16:16:40] PHP Deprecated:  Assigning the return value of new by reference is deprecated in /usr/share/php/MDB2.php on line 393
[29-Jul-2012 16:16:40] PHP Deprecated:  Assigning the return value of new by reference is deprecated in /usr/share/php/MDB2.php on line 2647
[29-Jul-2012 16:16:42] PHP Deprecated:  Assigning the return value of new by reference is deprecated in /usr/share/php/MDB2.php on line 393
[29-Jul-2012 16:16:42] PHP Deprecated:  Assigning the return value of new by reference is deprecated in /usr/share/php/MDB2.php on line 2647
[29-Jul-2012 16:16:48] PHP Deprecated:  Assigning the return value of new by reference is deprecated in /usr/share/php/MDB2.php on line 393
[29-Jul-2012 16:16:48] PHP Deprecated:  Assigning the return value of new by reference is deprecated in /usr/share/php/MDB2.php on line 2647
[29-Jul-2012 16:16:49] MDB2 Error: no such field (-19): _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_32228f882223ddea8981fe8a1ada17586be8beaae 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']

[29-Jul-2012 16:16:49 +0200]: DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_32228f882223ddea8981fe8a1ada17586be8beaae 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 /usr/share/roundcube/program/include/rcube_mdb2.php on line 293 (POST /webmail/?_task=settings&_action=save-identity)

When trying to add a new contact for exemple:

Code: [Select]
[29-Jul-2012 17:41:09] MDB2 Error: no such table (-18): _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_3efcd8dc9098bbfd7cbaf3f7eb08edb5c91bf5752 FROM 'SELECT * FROM contactgroups WHERE del<>1 AND user_id=? ORDER BY name']
[Native code: 1146]
[Native message: Table 'roundcube.contactgroups' doesn't exist]

[29-Jul-2012 17:41:09 +0200]: DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_3efcd8dc9098bbfd7cbaf3f7eb08edb5c91bf5752 FROM 'SELECT * FROM contactgroups WHERE del<>1 AND user_id=? ORDER BY name']
[Native code: 1146]
[Native message: Table 'roundcube.contactgroups' doesn't exist]
 in /usr/share/roundcube/program/include/rcube_mdb2.php on line 293 (GET /webmail/?_task=addressbook)
[29-Jul-2012 17:41:09] MDB2 Error: no such table (-18): _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_44dadbe3cc5bc7821d58ca024c5fc9c31973f078d FROM 'SELECT search_id AS id, `name` FROM searches WHERE user_id = ? AND `type` = ? ORDER BY `name`']
[Native code: 1146]
[Native message: Table 'roundcube.searches' doesn't exist]

[29-Jul-2012 17:41:09 +0200]: DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_44dadbe3cc5bc7821d58ca024c5fc9c31973f078d FROM 'SELECT search_id AS id, `name` FROM searches WHERE user_id = ? AND `type` = ? ORDER BY `name`']
[Native code: 1146]
[Native message: Table 'roundcube.searches' doesn't exist]
 in /usr/share/roundcube/program/include/rcube_mdb2.php on line 293 (GET /webmail/?_task=addressbook)
[29-Jul-2012 17:41:10] PHP Deprecated:  Assigning the return value of new by reference is deprecated in /usr/share/php/MDB2.php on line 393
[29-Jul-2012 17:41:10] PHP Deprecated:  Assigning the return value of new by reference is deprecated in /usr/share/php/MDB2.php on line 2647
[29-Jul-2012 17:41:15] PHP Deprecated:  Assigning the return value of new by reference is deprecated in /usr/share/php/MDB2.php on line 393
[29-Jul-2012 17:41:15] PHP Deprecated:  Assigning the return value of new by reference is deprecated in /usr/share/php/MDB2.php on line 2647
[29-Jul-2012 17:41:16] MDB2 Error: no such table (-18): _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_3bc23633a96a8d481bb005ce9750ac397e2560856 FROM 'SELECT 1 FROM contactgroups WHERE del<>1 AND user_id=? AND name=?']
[Native code: 1146]
[Native message: Table 'roundcube.contactgroups' doesn't exist]

[29-Jul-2012 17:41:16 +0200]: DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_3bc23633a96a8d481bb005ce9750ac397e2560856 FROM 'SELECT 1 FROM contactgroups WHERE del<>1 AND user_id=? AND name=?']
[Native code: 1146]
[Native message: Table 'roundcube.contactgroups' doesn't exist]
 in /usr/share/roundcube/program/include/rcube_mdb2.php on line 293 (POST /webmail/?_task=addressbook&_action=group-create?_task=&_action=)
[29-Jul-2012 17:41:16] MDB2 Error: no such table (-18): _doQuery: [Error message: Could not execute statement]
[Last executed query: INSERT INTO contactgroups (user_id, changed, name) VALUES (3, now(), 'test')]
[Native code: 1146]
[Native message: Table 'roundcube.contactgroups' doesn't exist]

[29-Jul-2012 17:41:16 +0200]: DB Error: MDB2 Error: no such table Query: _doQuery: [Error message: Could not execute statement] [Last executed query: INSERT INTO contactgroups (user_id, changed, name) VALUES (3, now(), 'test')] [Native code: 1146] [Native message: Table 'roundcube.contactgroups' doesn't exist]  in /usr/share/roundcube/program/include/rcube_mdb2.php on line 717 (POST /webmail/?_task=addressbook&_action=group-create?_task=&_action=)
« Last Edit: July 29, 2012, 11:44:17 AM by Beretta92 »

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
Re: Roundcube can't save settings
« Reply #1 on: July 29, 2012, 04:24:58 PM »
It appears the database wasn't updated.

Offline Beretta92

  • Newbie
  • *
  • Posts: 2
Re: Roundcube can't save settings
« Reply #2 on: July 30, 2012, 07:10:57 AM »
yes, it apears using Debian's packages is not a good idea, it doesn't update the DB and manual update gave me errors about the groups in mysql..
Had to go by a new clean install of roundcube with a new DB....
This is solved thank you