Opened 19 years ago
Closed 18 years ago
#3161 closed defect (fixed)
Updating to Revision 3300 with MySql Support
| Reported by: | Owned by: | Christian Boos | |
|---|---|---|---|
| Priority: | normal | Milestone: | 0.10 |
| Component: | admin/console | Version: | devel |
| Severity: | normal | Keywords: | mysql |
| Cc: | Branch: | ||
| Release Notes: | |||
| API Changes: | |||
| Internal Changes: | |||
Description
I am having difficulty upgrading my database to revision 3300, I am getting the error message
Command failed: (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 'TEMP TABLE session_old AS SELECT * FROM session' at line 1")
when I use the command upgrade --no-backup. I am wondering whether it is because I was previously using one of the patches from bug #986 to provide MySQL support and the database schemas have changed now? Any suggestions for what I could do to upgrade my issue database to support the new 3300 revision from trunk?
Attachments (0)
Change History (3)
comment:1 by , 19 years ago
comment:2 by , 18 years ago
| Keywords: | mysql added |
|---|---|
| Milestone: | → 0.10 |
| Owner: | changed from to |
Looking closer, the TEMP above is in trac/upgrades/db18.py and r3301 fixed only trac/upgrades/db19.py
We need to fix that.
comment:3 by , 18 years ago
| Resolution: | → fixed |
|---|---|
| Status: | new → closed |
For consistency, now TEMPORARY is used everywhere, with r3414.
should be
TEMPORARY, notTEMP. Upgrade to r3301 or higher.(and please don't forget to close as worksforme if this fixes the issue)