Roundcube Community Forum

 

SQL Error during Update

Started by szmansky, April 07, 2008, 11:33:30 AM

Previous topic - Next topic

szmansky

I upgraded today to the v0.1.1 version from the 0.1 Stable. I get the following MySQL error when running the mysql.update.sql file:

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

Any help would be appreciated. Thanks.