Ticket #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
Change History
Note: See
TracTickets for help on using
tickets.
