Hi list: I'm trying to add iteration plugin on my trac (0.11.1)installation. it's actually running on freebsd 7.1 RC.
trac is working with python 2.5. I've followed these steps, which worked fine on debian and python 2.4 http://www.agile-trac.org/wiki/AgileTracPluginInstall but, on my bsd server, I get Trac detected an internal error: OperationalError: near "installation": syntax error here's some debug messages: > > Python Traceback > > Most recent call last: > > * File > > "/usr/local/lib/python2.5/site-packages/Trac-0.11.1-py2.5.egg/trac/web/main.py", > line *423*, in _dispatch_request > <http://vista/meditrans/iterations#frame0> > > > Code fragment: > > 418. | try:| > 419. | if not env and env_error:| > 420. | raise HTTPInternalError(env_error)| > 421. | try:| > 422. | dispatcher = RequestDispatcher(env)| > 423. | dispatcher.dispatch(req)| > 424. | except RequestDone:| > 425. | pass| > 426. | resp = req._response or []| > 427. | | > 428. | except HTTPException, e:| > > > Local variables: > > Name > Value > after > |[u' except RequestDone:', u' pass', u' resp = ...| > before > |[u' try:', u' if not env and env_error:', u' raise ...| > dispatcher > |<trac.web.main.RequestDispatcher object at 0x28f225ac>| > e > |OperationalError('near "installation": syntax error',)| > env > |<trac.env.Environment object at 0x28b9ca4c>| > env_error > |None| > exc_info > |(<class 'pysqlite2.dbapi2.OperationalError'>, > OperationalError('near ...| > filename > > |'/usr/local/lib/python2.5/site-packages/Trac-0.11.1-py2.5.egg/trac/web/main > ...| > frames > |[{'function': '_dispatch_request', 'lines_before': [u' try:', > u' ...| > has_admin > |True| > line > |u' dispatcher.dispatch(req)'| > lineno > |422| > message > |u'OperationalError: near "installation": syntax error'| > req > |<Request "GET u'/iterations'">| > resp > |[]| > tb > |<traceback object at 0x29444cfc>| > tb_hide > |None| > traceback > |'Traceback (most recent call last):\n File ...| > > > * File > > "/usr/local/lib/python2.5/site-packages/Trac-0.11.1-py2.5.egg/trac/web/main.py", > line *197*, in dispatch <http://vista/meditrans/iterations#frame1> > > > Code fragment: > > 192. | req.args.get('__FORM_TOKEN') != req.form_token:| > 193. | raise HTTPBadRequest('Missing or invalid form token. '| > 194. | 'Do you have cookies enabled?')| > 195. | | > 196. | # Process the request and render the template| > 197. | resp = chosen_handler.process_request(req)| > 198. | if resp:| > 199. | if len(resp) == 2: # Clearsilver| > 200. | chrome.populate_hdf(req)| > 201. | template, content_type = \| > 202. | self._post_process_request(req, *resp)| > > > Local variables: > > Name > Value > chosen_handler > |<trac.ticket.roadmap.IterationsModule object at 0x28f3cd0c>| > chrome > |<trac.web.chrome.Chrome object at 0x2908f84c>| > err > |(<class 'pysqlite2.dbapi2.OperationalError'>, > OperationalError('near ...| > handler > |<trac.ticket.roadmap.IterationsModule object at 0x28f3cd0c>| > req > |<Request "GET u'/iterations'">| > self > |<trac.web.main.RequestDispatcher object at 0x28f225ac>| > > > * File > > "/usr/local/lib/python2.5/site-packages/Trac-0.11.1-py2.5.egg/trac/ticket/roadmap.py", > line *379*, in process_request > <http://vista/meditrans/iterations#frame2> > > > Code fragment: > > 374. | iterations.sort(lambda x, y: cmp(x.end_date, y.end_date))| > 375. | | > 376. | iterations_info = []| > 377. | | > 378. | for iteration in iterations:| > 379. | iteration_info = > TicketSystem(self.env).get_iteration_info(iteration, req, > self.stats_provider)| > 380. | iterations_info.append( iteration_info )| > 381. | | > 382. | ticket_fields = TicketSystem(self.env).get_ticket_fields()| > 383. | completion_stages = > TicketSystem(self.env).get_completion_stages()| > 384. | | > > > Local variables: > > Name > Value > db > |<trac.db.pool.PooledConnection object at 0x290a9fac>| > i > |<trac.ticket.model.Iteration object at 0x29446dec>| > iteration > |<trac.ticket.model.Iteration object at 0x29446dec>| > iterations > |[<trac.ticket.model.Iteration object at 0x29446dec>]| > iterations_info > |[]| > iterations_realm > |<Resource 'iteration'>| > req > |<Request "GET u'/iterations'">| > self > |<trac.ticket.roadmap.IterationsModule object at 0x28f3cd0c>| > showall > |False| > > > * File > > "/usr/local/lib/python2.5/site-packages/Trac-0.11.1-py2.5.egg/trac/ticket/api.py", > line *605*, in get_iteration_info > <http://vista/meditrans/iterations#frame3> > > > Code fragment: > > 600. | | > 601. | tickets = self.get_tickets_for_iteration(db, > iteration.tickets)| > 602. | tickets = self.apply_ticket_permissions(req, tickets)| > 603. | | > 604. | milestones = self.get_milestones_for_tickets(tickets)| > 605. | milestone_sizing_stats = > self.get_sizing_statistics_for_milestones(milestones)| > 606. | | > 607. | end_date = date.today() | > 608. | if iteration.end_date:| > 609. | end_date = iteration.end_date.date()| > 610. | | > > > Local variables: > > Name > Value > db > |<trac.db.pool.PooledConnection object at 0x29446dcc>| > iteration > |<trac.ticket.model.Iteration object at 0x29446dec>| > milestones > |set([])| > req > |<Request "GET u'/iterations'">| > self > |<trac.ticket.api.TicketSystem object at 0x29446a6c>| > stats_provider > |<trac.ticket.roadmap.DefaultTicketGroupStatsProvider object at > 0x29446eec>| > tickets > |[]| > > > * File > > "/usr/local/lib/python2.5/site-packages/Trac-0.11.1-py2.5.egg/trac/ticket/api.py", > line *415*, in get_sizing_statistics_for_milestones > <http://vista/meditrans/iterations#frame4> > > > Code fragment: > > 410. | else:| > 411. | sizing_stats[stage_name]['average_defined_size'] = > sizing_stats['average_defined_size']| > 412. | | > 413. | if sizing_stats['average_defined_size'] == 0:| > 414. |cursor.execute("SELECT tc.ticket,tc.stage,tc.size FROM > ticket_completion tc, ticket t WHERE tc.ticket = t.id AND > t.milestone IN (\'%s\')" %| > 415. | "\',\'".join(remaining_milestones))| > 416. | | > 417. | for ticket, stage, size in cursor:| > 418. | integer_size = 0| > 419. | size_defined = True| > 420. | try:| > > > Local variables: > > Name > Value > Milestone > |<class 'trac.ticket.model.Milestone'>| > cursor > |<trac.db.util.IterableCursor object at 0x294470d4>| > m > |<trac.ticket.model.Milestone object at 0x2944a14c>| > milestones_names > |set([])| > remaining_milestones > |[u'-1: Ancien Projet (v01)', u'Decoupage', u'Iterations', > u'M00 : ...| > self > |<trac.ticket.api.TicketSystem object at 0x29446a6c>| > sizing_stats > |{'acceptance_complete': {'min_size': 0, > 'average_defined_size': 0, ...| > stage > |{'order': 3, 'name': 'acceptance_complete', 'short_label': > u'Acceptance', ...| > stage_name > |'acceptance_complete'| > stages > |[{'order': 1, 'name': 'test_complete', 'short_label': > u'Tested', 'label': ...| > > > * File > > "/usr/local/lib/python2.5/site-packages/Trac-0.11.1-py2.5.egg/trac/db/util.py", > line *51*, in execute <http://vista/meditrans/iterations#frame5> > > > Code fragment: > > 46. | # -- In case of SQL errors, uncomment the following > 'print' statements| > 47. | # print 'execute', repr(sql)| > 48. | if args:| > 49. | # print repr(args)| > 50. | return self.cursor.execute(sql_escape_percent(sql), args)| > 51. | return self.cursor.execute(sql)| > 52. | | > 53. | def executemany(self, sql, args=None):| > 54. | # print 'executemany', repr(sql)| > 55. | if args:| > 56. | # print repr(args)| > > > Local variables: > > Name > Value > args > |None| > self > |<trac.db.util.IterableCursor object at 0x294470d4>| > sql > |u"SELECT tc.ticket,tc.stage,tc.size FROM ticket_completion tc, > ticket t ...| > > > * File > > "/usr/local/lib/python2.5/site-packages/Trac-0.11.1-py2.5.egg/trac/db/sqlite_backend.py", > line *58*, in execute <http://vista/meditrans/iterations#frame6> > > > Code fragment: > > 53. | raise| > 54. | def execute(self, sql, args=None):| > 55. | if args:| > 56. | sql = sql % (('?',) * len(args))| > 57. | return self._rollback_on_error(sqlite.Cursor.execute, sql,| > 58. | args or [])| > 59. | def executemany(self, sql, args=None):| > 60. | if args:| > 61. | sql = sql % (('?',) * len(args[0]))| > 62. | return > self._rollback_on_error(sqlite.Cursor.executemany, sql,| > 63. | args or [])| > > > Local variables: > > Name > Value > args > |None| > self > |<trac.db.sqlite_backend.PyFormatCursor object at 0x2941a4ac>| > sql > |u"SELECT tc.ticket,tc.stage,tc.size FROM ticket_completion tc, > ticket t ...| > > > * File > > "/usr/local/lib/python2.5/site-packages/Trac-0.11.1-py2.5.egg/trac/db/sqlite_backend.py", > line *50*, in _rollback_on_error > <http://vista/meditrans/iterations#frame7> > > > Code fragment: > > 45. | sqlite_version_string = '%d.%d.%d' % (_ver[0], _ver[1], > int(_ver[2]))| > 46. | | > 47. | class PyFormatCursor(sqlite.Cursor):| > 48. | def _rollback_on_error(self, function, *args, **kwargs):| > 49. | try:| > 50. | return function(self, *args, **kwargs)| > 51. | except sqlite.DatabaseError, e:| > 52. | self.cnx.rollback()| > 53. | raise| > 54. | def execute(self, sql, args=None):| > 55. | if args:| > > > Local variables: > > Name > Value > args > |(u"SELECT tc.ticket,tc.stage,tc.size FROM ticket_completion > tc, ticket t ...| > e > |OperationalError('near "installation": syntax error',)| > function > |<method 'execute' of 'pysqlite2.dbapi2.Cursor' objects>| > kwargs > |{}| > self > |<trac.db.sqlite_backend.PyFormatCursor object at 0x2941a4ac>| > > > File > "/usr/local/lib/python2.5/site-packages/Trac-0.11.1-py2.5.egg/trac/web/main.py", > line 423, in _dispatch_request > dispatcher.dispatch(req) > File > "/usr/local/lib/python2.5/site-packages/Trac-0.11.1-py2.5.egg/trac/web/main.py", > line 197, in dispatch > resp = chosen_handler.process_request(req) > File > "/usr/local/lib/python2.5/site-packages/Trac-0.11.1-py2.5.egg/trac/ticket/roadmap.py", > line 379, in process_request > iteration_info = TicketSystem(self.env).get_iteration_info(iteration, req, > self.stats_provider) > File > "/usr/local/lib/python2.5/site-packages/Trac-0.11.1-py2.5.egg/trac/ticket/api.py", > line 605, in get_iteration_info > milestone_sizing_stats = > self.get_sizing_statistics_for_milestones(milestones) > File > "/usr/local/lib/python2.5/site-packages/Trac-0.11.1-py2.5.egg/trac/ticket/api.py", > line 415, in get_sizing_statistics_for_milestones > "\',\'".join(remaining_milestones)) > File > "/usr/local/lib/python2.5/site-packages/Trac-0.11.1-py2.5.egg/trac/db/util.py", > line 51, in execute > return self.cursor.execute(sql) > File > "/usr/local/lib/python2.5/site-packages/Trac-0.11.1-py2.5.egg/trac/db/sqlite_backend.py", > line 58, in execute > args or []) > File > "/usr/local/lib/python2.5/site-packages/Trac-0.11.1-py2.5.egg/trac/db/sqlite_backend.py", > line 50, in _rollback_on_error > return function(self, *args, **kwargs) > in fact, I've had to patch my trac installation, which broken some features :-( , such like "roadmap" and old ticket's modification. thanks for helps --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to trac-users@googlegroups.com To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~----------~----~----~----~------~----~------~--~---
