Reporting a mail thread here as a ticket, for reference to other users.
I hope you don't mind me asking, not creating a ticket (checked them, there was one simillar to my problem), but have you seen anything like this?
Trac 0.11.5 with MySql?
Server version: 5.1.41-3ubuntu12.10 (Ubuntu)
trac-admin /trac/trac upgrade
Traceback (most recent call last):
File "/usr/local/bin/trac-admin", line 9, in <module>
load_entry_point('Trac==0.11.5', 'console_scripts', 'trac-admin')()
File "/usr/local/lib/python2.6/dist-packages/Trac-0.11.5-py2.6.egg/trac/admin/console.py", line 1314, in run
File "/usr/local/lib/python2.6/dist-packages/Trac-0.11.5-py2.6.egg/trac/admin/console.py", line 133, in onecmd
rv = cmd.Cmd.onecmd(self, line) or 0
File "/usr/lib/python2.6/cmd.py", line 219, in onecmd
File "/usr/local/lib/python2.6/dist-packages/Trac-0.11.5-py2.6.egg/trac/admin/console.py", line 1154, in do_upgrade
File "/usr/local/lib/python2.6/dist-packages/Trac-0.11.5-py2.6.egg/trac/env.py", line 457, in upgrade
File "/trac/trac/plugins/TestManager-1.4.4-py2.6.egg/testmanager/model.py", line 638, in upgrade_environment
File "/trac/trac/plugins/TracGenericClass-1.0.4-py2.6.egg/tracgenericclass/model.py", line 1276, in upgrade_db
File "/usr/local/lib/python2.6/dist-packages/Trac-0.11.5-py2.6.egg/trac/db/util.py", line 60, in execute
File "/usr/lib/pymodules/python2.6/MySQLdb/cursors.py", line 166, in execute
self.errorhandler(self, exc, value)
File "/usr/lib/pymodules/python2.6/MySQLdb/connections.py", line 35, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.ProgrammingError: (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 'int64,\n PRIMARY KEY (`id`(255))\n)' at line 7")
Sorry to ask, but my knowledge about python is very limited and this is my first attemt to install a plugin into Trac. I did manage to solve some issues as it stated for example that the TracXMLRPC was missing...
added this->TracXMLRPC.* = enabled
estimationtools.* = enabled
timingandestimationplugin.* = enabled
timingandestimationplugin.stopwatch.ticketstopwatch = disabled
timingandestimationplugin.tande_filters.timeclickfilter = disabled
timingandestimationplugin.tande_filters.totalhoursfilter = enabled
timingandestimationplugin.webui.timingestimationandbillingpage = disabled
added this->TracGenericClass.* = enabled
added this->TracGenericWorkflow.* = enabled
added this->TestManager.* = enabled
it will start just fine if I disable the TestManager? and the ugrade(s) before enabling that went fine without problems
I marked the modifications my 'added this->'
For me it seems like the database modifications won't go through and neither will any trac.ini modifications for the TestManager? trac-admin upgrade.
I will try to install this into a Ubuntu virtual box during the weekend, but if you have seen anything like this and are able to spot something I'm missing the help is greatly appreciated.