Opened 14 years ago

Closed 13 years ago

#159 closed defect (fixed)

sensitive tickets plugin causes a bug with milestones

Reported by: geofft Owned by:
Priority: normal Milestone:
Component: internals Keywords:
Cc:

Description

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

Change History (2)

comment:1 Changed 14 years ago by andersk

This is actually a Trac bug, fixed in Trac 0.12, which for some reason isn’t in Fedora yet.

comment:2 Changed 13 years ago by adehnert

  • Resolution set to fixed
  • Status changed from new to closed

This is irrelevant, because we aren't using that plugin anymore and Fedora got to 0.12 eventually (well, not until F15, but we're probably not touching this until that's deployed anyway).

Note: See TracTickets for help on using tickets.