Updating to Revision 3300 with MySql Support

[anthony@…]

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?

[cboos]

should be TEMPORARY, not TEMP. Upgrade to r3301 or higher.

(and please don't forget to close as worksforme if this fixes the issue)

[cboos]

Looking closer, the TEMP above is in trac/upgrades/db18.py and r3301 fixed only trac/upgrades/db19.py

We need to fix that.

[cboos]

For consistency, now TEMPORARY is used everywhere, with r3414.