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.

=================================================

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 <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.
",defect,closed,normal,TestManagerForTracPlugin,normal,fixed,,,0.11