id	summary	reporter	owner	description	type	status	priority	component	severity	resolution	keywords	cc	release
8672	Installation problem on Trac 0.11 and MySQL	seccanj	seccanj	Reporting a mail thread here as a ticket, for reference to other users.\r\n\r\n=================================================\r\n\r\nHello\r\n\r\nI 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?\r\n\r\nTrac 0.11.5 with MySql\r\nServer version: 5.1.41-3ubuntu12.10 (Ubuntu)\r\n\r\n{{{\r\ntrac-admin /trac/trac upgrade\r\nTraceback (most recent call last):\r\n File "/usr/local/bin/trac-admin", line 9, in <module>\r\n   load_entry_point('Trac==0.11.5', 'console_scripts', 'trac-admin')()\r\n File "/usr/local/lib/python2.6/dist-packages/Trac-0.11.5-py2.6.egg/trac/admin/console.py", line 1314, in run\r\n   return admin.onecmd(command)\r\n File "/usr/local/lib/python2.6/dist-packages/Trac-0.11.5-py2.6.egg/trac/admin/console.py", line 133, in onecmd\r\n   rv = cmd.Cmd.onecmd(self, line) or 0\r\n File "/usr/lib/python2.6/cmd.py", line 219, in onecmd\r\n   return func(arg)\r\n File "/usr/local/lib/python2.6/dist-packages/Trac-0.11.5-py2.6.egg/trac/admin/console.py", line 1154, in do_upgrade\r\n   self.__env.upgrade(backup=do_backup)\r\n File "/usr/local/lib/python2.6/dist-packages/Trac-0.11.5-py2.6.egg/trac/env.py", line 457, in upgrade\r\n   participant.upgrade_environment(db)\r\n File "/trac/trac/plugins/TestManager-1.4.4-py2.6.egg/testmanager/model.py", line 638, in upgrade_environment\r\n File "/trac/trac/plugins/TracGenericClass-1.0.4-py2.6.egg/tracgenericclass/model.py", line 1276, in upgrade_db\r\n File "/usr/local/lib/python2.6/dist-packages/Trac-0.11.5-py2.6.egg/trac/db/util.py", line 60, in execute\r\n   return self.cursor.execute(sql)\r\n File "/usr/lib/pymodules/python2.6/MySQLdb/cursors.py", line 166, in execute\r\n   self.errorhandler(self, exc, value)\r\n File "/usr/lib/pymodules/python2.6/MySQLdb/connections.py", line 35, in defaulterrorhandler\r\n   raise errorclass, errorvalue\r\n_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")\r\n}}}\r\n\r\nSorry 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...\r\n\r\n{{{\r\n[components]\r\nadded this->TracXMLRPC.* = enabled\r\nestimationtools.* = enabled\r\ntimingandestimationplugin.* = enabled\r\ntimingandestimationplugin.stopwatch.ticketstopwatch = disabled\r\ntimingandestimationplugin.tande_filters.timeclickfilter = disabled\r\ntimingandestimationplugin.tande_filters.totalhoursfilter = enabled\r\ntimingandestimationplugin.webui.timingestimationandbillingpage = disabled\r\nadded this->TracGenericClass.* = enabled\r\nadded this->TracGenericWorkflow.* = enabled\r\nadded this->TestManager.* = enabled\r\n}}}\r\n\r\nit will start just fine if I disable the TestManager and the ugrade(s) before enabling that went fine without problems\r\n\r\nI marked the modifications my 'added this->'\r\n\r\nFor me it seems like the database modifications won't go through and neither will any trac.ini modifications for the TestManager trac-admin upgrade.\r\n\r\n\r\nI 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.\r\n	defect	closed	normal	TestManagerForTracPlugin	normal	fixed			0.11