Author Topic: MySQL error on 0.1.1 upgrade  (Read 3817 times)

Offline chameleon

  • Newbie
  • *
  • Posts: 4
MySQL error on 0.1.1 upgrade
« 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? ???

Offline xyanide

  • Jr. Member
  • **
  • Posts: 41
Re: MySQL error on 0.1.1 upgrade
« Reply #1 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.

Offline chameleon

  • Newbie
  • *
  • Posts: 4
Re: MySQL error on 0.1.1 upgrade
« Reply #2 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.

Offline chameleon

  • Newbie
  • *
  • Posts: 4
Re: MySQL error on 0.1.1 upgrade
« Reply #3 on: April 06, 2008, 12:39:21 PM »
That should read 'semi-colon' :)

Offline xyanide

  • Jr. Member
  • **
  • Posts: 41
Re: MySQL error on 0.1.1 upgrade
« Reply #4 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