Roundcube Community Forum

 

MySQL error on 0.1.1 upgrade

Started by chameleon, April 06, 2008, 02:47:56 AM

Previous topic - Next topic

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