OperationalError: (1054, "Unknown column '$ASSIGNED' in 'where clause'")

[666.root@…]

Helo.

I found the following errors

—-

How to Reproduce

While doing a GET operation on /gantt/11, Trac issued an internal error.

(please provide additional details here)

Request parameters:

{'id': u'11'}

User Agent was: Mozilla/5.0 (Windows; U; Windows NT 6.1; ru; rv:1.9.2) Gecko/20100115 Firefox/3.6

System Information

Trac	0.11.6
Python	2.5.5 (r255:77872, Feb 4 2010, 11:49:26) [GCC 4.2.1 20070719 [FreeBSD]]
setuptools	0.6c9
MySQL	server: "5.0.51a", client: "5.0.51a", thread-safe: 1
MySQLdb	1.2.2
Genshi	0.5.1
Pygments	0.11.1
Subversion	1.6.4 (r38063)
jQuery:	1.2.6

Python Traceback

Traceback (most recent call last):
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/web/main.py", line 450, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/web/main.py", line 206, in dispatch
    resp = chosen_handler.process_request(req)
  File "build/bdist.freebsd-7.2-STABLE-i386/egg/tracgantt/gantt.py", line 118, in process_request
    tickets,dates,broken = self._tickets_for_report(db, report['query'], req.perm.username)
  File "build/bdist.freebsd-7.2-STABLE-i386/egg/tracgantt/gantt.py", line 175, in _tickets_for_report
    cursor.execute(query.replace('$USER', "'%s'" % username))
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/db/util.py", line 65, in execute
    return self.cursor.execute(sql)
  File "/usr/local/lib/python2.5/site-packages/MySQLdb/cursors.py", line 166, in execute
    self.errorhandler(self, exc, value)
  File "/usr/local/lib/python2.5/site-packages/MySQLdb/connections.py", line 35, in defaulterrorhandler
    raise errorclass, errorvalue
OperationalError: (1054, "Unknown column '$ASSIGNED' in 'where clause'")

—-

How can I fix it?

Thk.

[Remy Blank]

PluginIssue (​th:GanttPlugin).