OperationalError: no such table: agilo_sprint

[mcpbalaji@…]

How to Reproduce

While doing a GET operation on /admin/agilo/AgiloTicketReport, Trac issued an internal error.

(please provide additional details here)

Request parameters:

{'cat_id': u'agilo', 'panel_id': u'AgiloTicketReport', 'path_info': None}

User Agent was: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.0.5) Gecko/2008121911 CentOS/3.0.5-1.el5.centos Firefox/3.0.5

System Information

Trac	0.11.7
Python	2.5.2 (r252:60911, Jan 20 2010, 22:05:59) [GCC 4.2.4 (Ubuntu 4.2.4-1ubuntu3)]
setuptools	0.6c11
SQLite	3.4.2
pysqlite	2.3.2
Genshi	0.5.1
mod_python	3.3.1
Subversion	1.4.6 (r28521)
CustomFieldAdmin	0.2.2
jQuery:	1.2.6

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.5/site-packages/Trac-0.11.7-py2.5.egg/trac/web/main.py", line 450, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.5/site-packages/Trac-0.11.7-py2.5.egg/trac/web/main.py", line 206, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.5/site-packages/Trac-0.11.7-py2.5.egg/trac/admin/web_ui.py", line 114, in process_request
    path_info)
  File "build/bdist.linux-i686/egg/AgiloTicketReport/ticketreport.py", line 91, in render_admin_panel
    data['sprint_list'] = self.get_sprint_list()
  File "build/bdist.linux-i686/egg/AgiloTicketReport/ticketreport.py", line 187, in get_sprint_list
    return self.get_backlog_list("select name,start,sprint_end from agilo_sprint order by sprint_end")
  File "build/bdist.linux-i686/egg/AgiloTicketReport/ticketreport.py", line 156, in get_backlog_list
    cursor.execute(sql)
  File "/usr/lib/python2.5/site-packages/Trac-0.11.7-py2.5.egg/trac/db/util.py", line 65, in execute
    return self.cursor.execute(sql)
  File "/usr/lib/python2.5/site-packages/Trac-0.11.7-py2.5.egg/trac/db/sqlite_backend.py", line 80, in execute
    result = PyFormatCursor.execute(self, *args)
  File "/usr/lib/python2.5/site-packages/Trac-0.11.7-py2.5.egg/trac/db/sqlite_backend.py", line 59, in execute
    args or [])
  File "/usr/lib/python2.5/site-packages/Trac-0.11.7-py2.5.egg/trac/db/sqlite_backend.py", line 51, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: no such table: agilo_sprint

Please help to resolve this problem.

[Christian Boos]

AgiloForScrum issue.

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

@reporter: it seems you have a really ancient version of Agilo installed. The best thing is probably to update (in a test environment first). Please also join our support google group if you need further help. For details see AgiloForScrum. :-)

@cboos: Thansk for wrangling! :-)