Opened 5 years ago

Closed 5 years ago

#1484967 closed Bugs (fixed)

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 (1)

mysql.update.sql (425 bytes) - added by xyanide 5 years ago.
Original sql update file

Download all attachments as: .zip

Change History (2)

Changed 5 years ago by xyanide

Original sql update file

comment:1 Changed 5 years ago by alec

  • Resolution set to fixed
  • Status changed from new to closed

Fixed in r1262/svn. Please use update script from svn

Note: See TracTickets for help on using tickets.