OperationalError: (1054, "Unknown column 'weight' in 'field list'")

[jai.sharma@…]

How to Reproduce

While doing a GET operation on /ticket/1187, Trac issued an internal error.

(please provide additional details here)

Request parameters:

{'id': u'1187'}

User Agent was: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.4 (KHTML, like Gecko) Chrome/22.0.1229.94 Safari/537.4

System Information

Trac	0.11
Python	2.4.3 (#1, Jun 18 2012, 08:55:23) [GCC 4.1.2 20080704 (Red Hat 4.1.2-52)]
setuptools	0.6c11
MySQL	server: "5.0.95-log", client: "5.0.95", thread-safe: 1
MySQLdb	1.2.3
Genshi	0.6
Subversion	1.5.0 (r31699)
jQuery:	1.2.6

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/Trac-0.11-py2.4.egg/trac/web/main.py", line 450, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.4/site-packages/Trac-0.11-py2.4.egg/trac/web/main.py", line 206, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.4/site-packages/Trac-0.11-py2.4.egg/trac/ticket/web_ui.py", line 185, in process_request
    return self._process_ticket_request(req)
  File "/usr/lib/python2.4/site-packages/Trac-0.11-py2.4.egg/trac/ticket/web_ui.py", line 457, in _process_ticket_request
    ticket = Ticket(self.env, id, version=version)
  File "/usr/lib/python2.4/site-packages/Trac-0.11-py2.4.egg/trac/ticket/model.py", line 47, in __init__
    self.fields = TicketSystem(self.env).get_ticket_fields()
  File "/usr/lib/python2.4/site-packages/Trac-0.11-py2.4.egg/trac/ticket/api.py", line 208, in get_ticket_fields
    self._fields = self._get_ticket_fields()
  File "/usr/lib/python2.4/site-packages/Trac-0.11-py2.4.egg/trac/ticket/api.py", line 255, in _get_ticket_fields
    options = [val.name for val in cls.select(self.env, db=db)]
  File "/usr/lib/python2.4/site-packages/Trac-0.11-py2.4.egg/trac/ticket/model.py", line 948, in select
    cursor.execute(sql)
  File "/usr/lib/python2.4/site-packages/Trac-0.11-py2.4.egg/trac/db/util.py", line 65, in execute
    return self.cursor.execute(sql)
  File "build/bdist.linux-x86_64/egg/MySQLdb/cursors.py", line 174, in execute
  File "build/bdist.linux-x86_64/egg/MySQLdb/connections.py", line 36, in defaulterrorhandler
OperationalError: (1054, "Unknown column 'weight' in 'field list'")

[Christian Boos]

PluginIssue (​AgileTrac) again…

Look, if you're unable to get support from there and you can't fix the errors by yourself, then the best thing for you is probably to stop trying to use it and just use "plain" Trac (upgrade to a recent version, 0.12.4 or 1.0, so to be sure to not use the patched one), or a different solution altogether.

But here we don't know, don't endorse, don't support AgileTrac, so please stop reporting issues.