OperationalError: near "=": syntax error

[Aman]

How to Reproduce

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

(please provide additional details here)

Request parameters:

{'path': u'1228', 'realm': u'ticket'}

User Agent was: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 (.NET CLR 3.5.30729)

System Information

Trac	0.11.3
Python	2.5.2 (r252:60911, Oct 5 2008, 19:24:49) [GCC 4.3.2]
setuptools	0.6c9
SQLite	3.5.9
pysqlite	2.3.2
Genshi	0.5.1
Agilo	0.7.3.3-r1417-20090313
Subversion	1.5.1 (r32289)
jQuery:	1.2.6

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/web/main.py", line 435, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/web/main.py", line 205, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/attachment.py", line 392, in process_request
    return self._render_list(req, parent)
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/attachment.py", line 644, in _render_list
    parent))
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/attachment.py", line 436, in attachment_data
    'can_create': 'ATTACHMENT_CREATE' in context.perm(new_att),
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/perm.py", line 524, in has_permission
    return self._has_permission(action, resource)
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/perm.py", line 538, in _has_permission
    check_permission(action, perm.username, resource, perm)
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/perm.py", line 425, in check_permission
    perm)
  File "/usr/lib/python2.5/site-packages/agilo-0.7.3.3_r1417_20090313-py2.5.egg/agilo/utils/permissions.py", line 272, in check_permission
    return self.action_map[action](username, resource, perm)
  File "/usr/lib/python2.5/site-packages/agilo-0.7.3.3_r1417_20090313-py2.5.egg/agilo/utils/permissions.py", line 189, in check_attachment_create
    ticket = self._get_agilo_ticket(resource)
  File "/usr/lib/python2.5/site-packages/agilo-0.7.3.3_r1417_20090313-py2.5.egg/agilo/utils/permissions.py", line 108, in _get_agilo_ticket
    return AgiloTicket(self.env, resource.id)
  File "/usr/lib/python2.5/site-packages/agilo-0.7.3.3_r1417_20090313-py2.5.egg/agilo/ticket/model.py", line 87, in __init__
    self._fetch_ticket(tkt_id, db=db, t_type=t_type)
  File "/usr/lib/python2.5/site-packages/agilo-0.7.3.3_r1417_20090313-py2.5.egg/agilo/ticket/model.py", line 107, in _fetch_ticket
    t_type = self._get_type(tkt_id, db)
  File "/usr/lib/python2.5/site-packages/agilo-0.7.3.3_r1417_20090313-py2.5.egg/agilo/ticket/model.py", line 756, in _get_type
    cursor.execute(sql_get_type)
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/db/util.py", line 51, in execute
    return self.cursor.execute(sql)
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/db/sqlite_backend.py", line 58, in execute
    args or [])
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/db/sqlite_backend.py", line 50, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: near "=": syntax error

[Christian Boos]

agilo-0.7.3.3_r1417_20090313

Please see AgiloForScrum.

[Martin Häcker <martin.haecker@…>]

That's an awfully old version of Agilo - so I suggest you update it first. If the problem persists, please don't hesitate to contact our google group.