Installation problem on Trac 0.11 and MySQL
|Reported by:||Roberto Longobardi||Owned by:||Roberto Longobardi|
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 return admin.onecmd(command) 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 return func(arg) File "/usr/local/lib/python2.6/dist-packages/Trac-0.11.5-py2.6.egg/trac/admin/console.py", line 1154, in do_upgrade self.__env.upgrade(backup=do_backup) File "/usr/local/lib/python2.6/dist-packages/Trac-0.11.5-py2.6.egg/trac/env.py", line 457, in upgrade participant.upgrade_environment(db) 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 return self.cursor.execute(sql) 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...
[components] 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.