id summary reporter owner description type status priority component severity resolution keywords cc release 8672 Installation problem on Trac 0.11 and MySQL Roberto Longobardi Roberto Longobardi "Reporting a mail thread here as a ticket, for reference to other users. ================================================= Hello 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 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. " defect closed normal TestManagerForTracPlugin normal fixed 0.11