id,summary,reporter,owner,description,type,status,priority,component,severity,resolution,keywords,cc,release
3163,tm.py macro error,shelly@…,fsbojason,"When you go to the Timeline tab of the Trac site using the tm.py or Ticket Milestone Display Macro, it causes the following error in the logs:

{{{
cvs Trac[macros] ERROR: Wiki macro tm failed (invalid input syntax for integer: ""189/LANL08-100.sql"" ) Traceback (most recent call last):   File ""/usr/lib/python2.3/site-packages/trac/wiki/macros.py"", line 459, in render_macro     return module.execute(req and req.hdf, content, self.env)   File ""/files0/trac-sites/webPMIS/plugins/tm.py"", line 15, in execute   File ""/usr/lib/python2.3/site-packages/trac/db/util.py"", line 51, in execute     return self.cursor.execute(sql)   File ""/usr/lib/python2.3/site-packages/trac/db/util.py"", line 51, in execute     return self.cursor.execute(sql) ProgrammingError: invalid input syntax for integer: ""189/LANL08-100.sql""
Jun 10 15:26:05 cvs Trac[formatter] ERROR: Macro tm(189/LANL08-100.sql) failed Traceback (most recent call last):   File ""/usr/lib/python2.3/site-packages/trac/wiki/formatter.py"", line 441, in _macro_formatter     return macro.process(self.req, args, True)   File ""/usr/lib/python2.3/site-packages/trac/wiki/formatter.py"", line 114, in process     text = self.processor(req, text)   File ""/usr/lib/python2.3/site-packages/trac/wiki/formatter.py"", line 102, in _macro_processor     return self.macro_provider.render_macro(req, self.name, text)   File ""/usr/lib/python2.3/site-packages/trac/wiki/macros.py"", line 459, in render_macro     return module.execute(req and req.hdf, content, self.env)   File ""/files0/trac-sites/webPMIS/plugins/tm.py"", line 15, in execute   File ""/usr/lib/python2.3/site-packages/trac/db/util.py"", line 51, in execute     return self.cursor.execute(sql)   File ""/usr/lib/python2.3/site-packages/trac/db/util.py"", line 51, in execute     return self.cursor.execute(sql) ProgrammingError: invalid input syntax for
Jun 10 15:26:05 cvs Trac[main] WARNING: 500 Internal Error (Repository checkins  event provider (<tt>ChangesetModule</tt>) failed:<br /><br />ProgrammingError: current transaction is aborted, commands ignored until end of transaction block <p>You may want to see the other kind of events from the <a href=""/webPMIS/timeline?milestone=on&amp;ticket=on&amp;wiki=on"">Timeline</a></p>)
}}}

Any ideas?",defect,new,high,TicketMilestoneDisplayMacro,major,,tm.py wiki plugin,,0.10