Roundcube Community Forum

 

Adressbook dont work after migration from 0.6

Started by PRE, February 13, 2012, 04:26:34 AM

Previous topic - Next topic

PRE

Hi. I have little problem with my adressbook. When I click the icon I get:
DB Error in /path_to_rc/program/include/rcube_mdb2.php (293):</b>&nbsp;_doQuery: [Error message: Could not execute statement]<br />
[Last executed query: PREPARE mdb2_statement_mysql_45c2cc91b7d339121304da2b5f4211cfdc7c3df82 FROM 'SELECT search_id AS id, `name` FROM searches WHERE user_id = ? AND `type` = ? ORDER BY `name`']

I used mysql.udate.sql from roundcubemail-0.7/SQL and I get in PMA:
ALTER TABLE `messages` DROP INDEX `idx` ,
DROP INDEX `uid` ;

#1091 - Can't DROP 'idx'; check that column/key exists

SKaero

Don't run the whole update file, open it and run the lines under the version your upgrading from. Example: run all lines under:
-- Updates from version 0.6