OperationalError: no such column: parents

[ravindrakumarg]

How to Reproduce

While doing a POST operation on /ticket/510, Trac issued an internal error.

(please provide additional details here)

Request parameters:

{'__FORM_TOKEN': u'd28e5fdb55dd7a4319bdabf0',
 'action': u'resolve',
 'action_resolve_resolve_resolution': u'Fixed',
 'comment': u'This feature successfully completed.',
 'field_component': u'DuOS',
 'field_description': u'Make the DuOS default Player of .apk files of host system.\r\nBy adding this feature, whenever user click on any .apk file present\r\nin the host system(Windows / Linux) it will automatically installed in DuOS.\r\n',
 'field_keywords': u'',
 'field_rd_points': u'0',
 'field_reporter': u'ravindrakumarg',
 'field_sprint': u'',
 'field_story_priority': u'Mandatory',
 'field_summary': u'Make DuOS Default player of .APK files',
 'field_type': u'Story',
 'id': u'510',
 'replyto': u'',
 'start_time': u'1355115709341551',
 'submit': u'Submit changes',
 'view_time': u'1355115709341551'}

User agent: Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.153 Safari/537.36

System Information

Trac	1.0.1
Agilo	0.9.12
Babel	0.9.5
Genshi	0.6 (with speedups)
mod_wsgi	3.2 (WSGIProcessGroup WSGIApplicationGroup localhost|/ptracker)
Pygments	1.3.1
pysqlite	2.4.1
Python	2.6.6 (r266:84292, Sep 15 2010, 16:41:53) [GCC 4.4.5]
pytz	2010b
setuptools	0.6
SQLite	3.7.2
Subversion	1.6.12 (r955767)
jQuery	1.7.2

Enabled Plugins

agilo	0.9.12
AutocompleteUsers	0.4.1
ExcelDownloadPlugin	0.12.0.3
NavAdd	0.1
SVN-URLs	0.6
TestManager	1.6.1
TracAccountManager	0.3.1
TracDateField	1.0.4-r11026
TracGenericClass	1.1.5
TracGenericWorkflow	1.0.4
TracMasterTickets	3.0.2
tracreposearch	0.2
TracSubTicketsPlugin	0.1.0
TracSupose	0.0.1
TracWikiToPdfPlugin	2.3.1-r10443
whiteboard	0.1.0-trac0.12

Python Traceback

Traceback (most recent call last):
  File "/usr/local/lib/python2.6/dist-packages/Trac-1.0.1-py2.6.egg/trac/web/main.py", line 497, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/local/lib/python2.6/dist-packages/Trac-1.0.1-py2.6.egg/trac/web/main.py", line 214, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/local/lib/python2.6/dist-packages/Trac-1.0.1-py2.6.egg/trac/ticket/web_ui.py", line 179, in process_request
    return self._process_ticket_request(req)
  File "/usr/local/lib/python2.6/dist-packages/agilo-0.9.12-py2.6.egg/agilo/ticket/web_ui.py", line 227, in _process_ticket_request
    template, data, content_type = super(AgiloTicketModule, self)._process_ticket_request(req)
  File "/usr/local/lib/python2.6/dist-packages/Trac-1.0.1-py2.6.egg/trac/ticket/web_ui.py", line 614, in _process_ticket_request
    self._do_save(req, ticket, action)
  File "/usr/local/lib/python2.6/dist-packages/Trac-1.0.1-py2.6.egg/trac/ticket/web_ui.py", line 1328, in _do_save
    replyto=req.args.get('replyto'))
  File "/usr/local/lib/python2.6/dist-packages/agilo-0.9.12-py2.6.egg/agilo/ticket/model.py", line 860, in save_changes
    res = super(AgiloTicket, self).save_changes(author, comment, when, db, cnum, replyto=replyto)
  File "/usr/local/lib/python2.6/dist-packages/Trac-1.0.1-py2.6.egg/trac/ticket/model.py", line 346, in save_changes
    % name, (self[name], self.id))
  File "/usr/local/lib/python2.6/dist-packages/Trac-1.0.1-py2.6.egg/trac/db/util.py", line 121, in execute
    cursor.execute(query, params)
  File "/usr/local/lib/python2.6/dist-packages/Trac-1.0.1-py2.6.egg/trac/db/util.py", line 65, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/local/lib/python2.6/dist-packages/Trac-1.0.1-py2.6.egg/trac/db/sqlite_backend.py", line 78, in execute
    result = PyFormatCursor.execute(self, *args)
  File "/usr/local/lib/python2.6/dist-packages/Trac-1.0.1-py2.6.egg/trac/db/sqlite_backend.py", line 56, in execute
    args or [])
  File "/usr/local/lib/python2.6/dist-packages/Trac-1.0.1-py2.6.egg/trac/db/sqlite_backend.py", line 48, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: no such column: parents

[Stefano Rago]

Thanks for reporting this issue. This is probably related to bad interaction with other plugins, which we don't support. Please try disabling all of them, and re-enable them one by one checking the error, if you want to figure out which one is causing the problem.