Author Topic: SQL Error during Update  (Read 2427 times)

Offline szmansky

  • Newbie
  • *
  • Posts: 1
SQL Error during Update
« on: April 07, 2008, 11:33:30 AM »
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.

Offline BlueC

  • Jr. Member
  • **
  • Posts: 25
Re: SQL Error during Update
« Reply #1 on: April 07, 2008, 12:46:35 PM »
try using the forum search feature...

http://roundcubeforum.net/forum/index.php?topic=2942.0