id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc
1488301	MySQL error in upgrade 0.6 -> 0.7.1	kitserve		"I just tried to upgrade my RoundCube install from 0.6 to 0.7.1 using the independent tarfile, running on MySQL backend.

Attempting to run update.sh results in the following:
{{{
root@localhost:/usr/local/share/roundcube# ./bin/update.sh 
What version are you upgrading from? Type '?' if you don't know.
0.6
WARNING: Database schema needs to be updated!
Missing table 'cache_index'
Missing table 'cache_thread'
Missing table 'cache_messages'
Missing table 'dictionary'
Missing table 'searches'

Do you want to run the update queries to get the schmea fixed? (y/N)
y
MDB2 Error: not found (-4): _doQuery: [Error message: Could not execute statement]
[Last executed query: ALTER TABLE `contacts` DROP INDEX `user_contacts_index`;
]
[Native code: 1091]
[Native message: Can't DROP 'user_contacts_index'; check that column/key exists]

This instance of Roundcube is up-to-date.
Have fun!
}}}
Attempting to run the mysql.update.sql directly in phpMyAdmin results in this output:
{{{
SQL query:

-- Updates from version 0.7
ALTER TABLE `contacts` DROP FOREIGN KEY `user_id_fk_contacts` ;

MySQL said: Documentation
#1025 - Error on rename of './roundcubedb/contacts' to './roundcubedb/#sql2-6f9-3b74d' (errno: 152)
}}}
On a side topic, is it expected that in version 0.7.1, clicking on a contact in the contact list or on a preference on the preferences page will bring up a full page dialogue for the contact/preference? I liked the old behaviour better, where the contact/preference appears in a pane on the right of the page. Maybe this is just a glitch caused by the failed upgrade though (I have since restored version 0.6 from backup).

Thanks."	Bugs	closed	5	0.8-beta	Addressbook	0.7	normal	duplicate