Issue with recurring error

[dbyte]

I am getting this error recurring in my roundcube logs.


[31-Aug-2011 15:47:49 -0500]: DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_418a37d4a7fab366ab727c15ecb0125098f68fc24 FROM 'SELECT uid FROM messages WHERE user_id=? AND cache_key=? AND idx=?']
[Native code: 1054]
[Native message: Unknown column 'idx' in 'where clause']
 in /var/www/html/roundcubemail-0.5.4/program/include/rcube_mdb2.php on line 268 (GET /roundcube/?_task=mail&_remote=1&_action=list&_mbox=INBOX&_refresh=1&_=1314823686957&_unlock=loading1314823686955)

type particular session information changes (of course) but I need some guidance in fixing the index.

[JohnDoh]

not sure how you have managed that, the idx column has always been part of the messages table, atleast since v0.1-beta2. if i were you i'd backup the contents of the db and then create a fresh one using the latest initial sql file and then restore the contents. you can empty the messages and cache table and rc will rebuild them.

[faaaa]

I don't have this message, sorry

[dbyte]

Is there a way to simply add the idx field on the fly?  dumping and restoring really isn't a great option due to the number of users and the fact that I would not even come close to considering myself a mysql guru.

[dbyte]

Ok.. I nuked and reloaded roundcube completely (including the DB) and then reloaded the data.  I am now getting the following error.  Any thoughts?


[01-Sep-2011 11:36:09 -0500]: DB Error: MDB2 Error: constraint violation Query: _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_4c24765b0e4662f7f8719ac887eb430062167b93c USING @0, @1, @2] [Native code: 1062] [Native message: Duplicate entry 'de4857f68c09cbef2ba3e57cf24c90c8' for key 1]  in /var/www/html/roundcubemail-0.5.4/program/include/rcube_mdb2.php on line 642 (GET /roundcube/?_task=mail&_remote=1&_action=list&_mbox=INBOX&_refresh=1&_=1314894990133&_unlock=loading1314894990131)

[dbyte]

[01-Sep-2011 11:36:09] MDB2 Error: constraint violation (-3): _doQuery: [Error message: Could not execute statement]
[Last executed query: EXECUTE mdb2_statement_mysql_4c24765b0e4662f7f8719ac887eb430062167b93c USING @0, @1, @2]
[Native code: 1062]
[Native message: Duplicate entry 'de4857f68c09cbef2ba3e57cf24c90c8' for key 1]

[JohnDoh]

did you emtpy the messages and cache table and let rc rebuild it?

[dbyte]

I didn't backup the data in either table, but if someone can help me with the SQL query to do so, I will happily clean both of them out again..

Actually both tables are currently empty???

[dbyte]

I went into the config and enabled the caching and then it started throwing these errors:


[01-Sep-2011 12:27:33] MDB2 Error: constraint violation (-3): _doQuery: [Error message: Could not execute statement]
[Last executed query: EXECUTE mdb2_statement_mysql_1362585573b44d4bcfa100ef22936d485d690311e19 USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10]
[Native code: 1062]
[Native message: Duplicate entry '162-INBOX.msg-89332' for key 2]

[01-Sep-2011 12:27:33 -0500]: DB Error: MDB2 Error: constraint violation Query: _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_1362585573b44d4bcfa100ef22936d485d690311e19 USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10] [Native code: 1062] [Native message: Duplicate entry '162-INBOX.msg-89332' for key 2]  in /var/www/html/roundcubemail-0.5.4/program/include/rcube_mdb2.php on line 642 (POST /roundcube/?_task=mail&_action=moveto?_task=&_action=)

[JohnDoh]

I went into the config and enabled the caching and then it started throwing these errors:

I dont understand, surely you've had this enabled all along or you wouldnt have got any errors about the messages table.