[Trac-tickets] [The Trac Project] #3161: Updating to Revision 3300 with MySql Support

[The Trac Project]

#3161: Updating to Revision 3300 with MySql Support
----------------------------------------+-----------------------------------
 Reporter:  anthony at warwickcontrol.com  |       Owner:  daniel
     Type:  defect                      |      Status:  new   
 Priority:  normal                      |   Milestone:        
Component:  trac-admin                  |     Version:  devel 
 Severity:  normal                      |    Keywords:        
----------------------------------------+-----------------------------------
 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?

-- 
Ticket URL: <http://projects.edgewall.com/trac/ticket/3161>
The Trac Project <http://trac.edgewall.com/>