Roundcube Community Forum

News and Announcements => General Discussion => Topic started by: chameleon on April 06, 2008, 02:47:56 AM

Title: MySQL error on 0.1.1 upgrade
Post by: chameleon on April 06, 2008, 02:47:56 AM

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? ???

Title: Re: MySQL error on 0.1.1 upgrade
Post by: xyanide on April 06, 2008, 11:22:09 AM

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

*Edit, I made a ticket for it.

Title: Re: MySQL error on 0.1.1 upgrade
Post by: chameleon on April 06, 2008, 12:37:59 PM

Try this on line 8 of MySQL update;


DROP INDEX `uid`; (missing colon) :)

Courtesy of chicchiricco on Sourceforge Roundcube forum.

Title: Re: MySQL error on 0.1.1 upgrade
Post by: chameleon on April 06, 2008, 12:39:21 PM

That should read 'semi-colon' :)

Title: Re: MySQL error on 0.1.1 upgrade
Post by: xyanide on April 06, 2008, 04:33:52 PM

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