id	summary	reporter	owner	description	type	status	priority	milestone	component	resolution	keywords	cc
159	sensitive tickets plugin causes a bug with milestones	geofft		"I clicked on ""Fedora 11"" on the milestones page and got:

> Trac detected an internal error:
> 
> 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 'sensitive\nFROM ticket AS t\n  LEFT OUTER JOIN ticket_custom AS sensitive ON (id=s' at line 1"")
{{{
File ""/usr/lib/python2.6/site-packages/trac/web/main.py"", line 450, in _dispatch_request
  dispatcher.dispatch(req)
File ""/usr/lib/python2.6/site-packages/trac/web/main.py"", line 206, in dispatch
  resp = chosen_handler.process_request(req)
File ""/usr/lib/python2.6/site-packages/trac/ticket/query.py"", line 836, in process_request
  return self.display_html(req, query)
File ""/usr/lib/python2.6/site-packages/trac/ticket/query.py"", line 889, in display_html
  tickets = query.execute(req, db)
File ""/usr/lib/python2.6/site-packages/trac/ticket/query.py"", line 264, in execute
  self.num_items = self._count(sql, args, db)
File ""/usr/lib/python2.6/site-packages/trac/ticket/query.py"", line 249, in _count
  cursor.execute(count_sql, args);
File ""/usr/lib/python2.6/site-packages/trac/db/util.py"", line 64, in execute
  return self.cursor.execute(sql_escape_percent(sql), args)
File ""/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py"", line 173, in execute
  self.errorhandler(self, exc, value)
File ""/usr/lib64/python2.6/site-packages/MySQLdb/connections.py"", line 36, in defaulterrorhandler
  raise errorclass, errorvalue
}}}"	defect	closed	normal		internals	fixed