Roundcube Community Forum
Release Support => Release Discussion => Topic started by: PRE on February 13, 2012, 04:26:34 AM
-
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> _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
-
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