Author Topic: Adressbook dont work after migration from 0.6  (Read 3159 times)

Offline PRE

  • Newbie
  • *
  • Posts: 2
Adressbook dont work after migration from 0.6
« on: February 13, 2012, 04:26:34 AM »
Hi. I have little problem with my adressbook. When I click the icon I get:
Code: [Select]
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:
Code: [Select]
ALTER TABLE `messages` DROP INDEX `idx` ,
DROP INDEX `uid` ;

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

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
Adressbook dont work after migration from 0.6
« Reply #1 on: February 13, 2012, 09:09:07 AM »
Don't run the whole update file, open it and run the lines under the version your upgrading from. Example: run all lines under:
Code: [Select]
-- Updates from version 0.6