Ticket #1484967 (closed Bugs: fixed)

Opened 9 months ago

Last modified 9 months ago

MySQL error on 0.1.1 upgrade

Reported by: xyanide Owned by:
Priority: 2 Milestone: 0.2-alpha
Component: Database Version: 0.1.1
Severity: normal Keywords:
Cc:

Description

The file mysql.update.sql in the 0.1.1 download file gives an Mysql error.

This is the 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.

Attachments

mysql.update.sql (425 bytes) - added by xyanide 9 months ago.
Original sql update file

Change History

Changed 9 months ago by xyanide

Original sql update file

Changed 9 months ago by alec

  • status changed from new to closed
  • resolution set to fixed

Fixed in r1262. Please use update script from svn

Note: See TracTickets for help on using tickets.