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.
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.
I don't have this message, sorry
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.
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)
[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]
did you emtpy the messages and cache table and let rc rebuild it?
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???
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=)
QuoteI 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.