MySQL error on 0.1.1 upgrade

[chameleon]

Hi,
I just upgraded from 0.1 to 0.1.1 and I get this MySQL error;

Error

SQL query:

ALTER TABLE `messages` DROP INDEX `idx` ,
DROP INDEX `uid` ALTER TABLE `cache` DROP INDEX `cache_key` ,
DROP INDEX `session_id` ,
ADD INDEX `user_cache_index` ( `user_id` , `cache_key` ) ;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE `cache`
 DROP INDEX `cache_key`,
 DROP INDEX `session_id`,
 AD' at line 5

Roundcube seems to work OK.
Any ideas?

[xyanide]

I`ve got the same problem. (roundcube works fine on my end to).

*Edit, I made a ticket for it.

[chameleon]

Try this on line 8 of MySQL update;


DROP INDEX `uid`; (missing colon)

Courtesy of chicchiricco on Sourceforge Roundcube forum.

[chameleon]

That should read 'semi-colon'

[xyanide]

The problem has already been fixed

Link to the right update file:
http://trac.roundcube.net/browser/branches/release-0.1-stable/SQL/mysql.update.sql?rev=1262