Edgewall Software

Opened 14 years ago

Closed 14 years ago

#9044 closed defect (cantfix)

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

Reported by: 666.root@… Owned by:
Priority: normal Milestone:
Component: general Version: 0.11.6
Severity: normal Keywords:
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:



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
  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?


Attachments (0)

Change History (1)

comment:1 by Remy Blank, 14 years ago

Resolution: cantfix
Status: newclosed

Modify Ticket

Change Properties
Set your email in Preferences
as closed The ticket will remain with no owner.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from (none) to the specified user.

Add Comment

E-mail address and name can be saved in the Preferences .
Note: See TracTickets for help on using tickets.