Modify ↓
Opened 18 years ago
Closed 17 years ago
#3802 closed defect (wontfix)
upgrading mysql database from v17 to v19 broken
| Reported by: | neomantra | Owned by: | daniel |
|---|---|---|---|
| Priority: | normal | Milestone: | |
| Component: | admin/console | Version: | 0.10rc1 |
| Severity: | normal | Keywords: | mysql upgrade needinfo |
| Cc: | Branch: | ||
| Release Notes: | |||
| API Changes: | |||
| Internal Changes: | |||
Description
upgrading mysql database from v17 to v19 is broken. the following error occurs: Command failed: (1170, "BLOB/TEXT column 'sid' used in key specification without a key length")
my workaround:
i don't care about session history in my upgrade so i commented out the parts of upgrades/db18.py that transfers the session information.
i also had to comment out the changes in upgrades/db19.py and manually modify the column name (from 'sql' to 'query').
Attachments (0)
Change History (2)
comment:1 by , 18 years ago
| Keywords: | needinfo added; trac-admin removed |
|---|
comment:2 by , 17 years ago
| Resolution: | → wontfix |
|---|---|
| Status: | new → closed |
Since MySQL wasn't supported until v19 of the database we can't support upgrades for earlier versions.
Note:
See TracTickets
for help on using tickets.
Trac did not support MySQL until v19 of the database schema. Did you patch an earlier version of Trac for MySQL support, or is this the result of migrating SQLite data into MySQL?