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)
Change History (2)
Changed 5 years ago by xyanide
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

Original sql update file