OperationalError: table cache has 3 columns but 2 values were supplied

[fabian@…]

How to Reproduce

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

(please provide additional details here)

Request parameters:

{'__FORM_TOKEN': u'ed0ee407e7195d28e5092bcf',
 'add': u'Add',
 'cat_id': u'ticket',
 'name': u'Backend',
 'owner': u'fabian',
 'panel_id': u'components',
 'path_info': None}

User agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_5) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.64 Safari/537.11

System Information

Trac	0.12.3
Genshi	0.6
mod_wsgi	3.3 (WSGIProcessGroup WSGIApplicationGroup dev.onetomeet.com|/trac)
pysqlite	2.6.0
Python	2.7.0+ (r27:82500, Sep 15 2010, 18:45:01) [GCC 4.4.5]
setuptools	0.6
SQLite	3.7.2
jQuery	1.7.2

Enabled Plugins

Python Traceback

Traceback (most recent call last):
  File "/usr/local/lib/python2.7/dist-packages/Trac-0.12.3-py2.7.egg/trac/web/main.py", line 522, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/local/lib/python2.7/dist-packages/Trac-0.12.3-py2.7.egg/trac/web/main.py", line 243, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/local/lib/python2.7/dist-packages/Trac-0.12.3-py2.7.egg/trac/admin/web_ui.py", line 117, in process_request
    path_info)
  File "/usr/local/lib/python2.7/dist-packages/Trac-0.12.3-py2.7.egg/trac/ticket/admin.py", line 53, in render_admin_panel
    return self._render_admin_panel(req, cat, page, version)
  File "/usr/local/lib/python2.7/dist-packages/Trac-0.12.3-py2.7.egg/trac/ticket/admin.py", line 110, in _render_admin_panel
    comp.insert()
  File "/usr/local/lib/python2.7/dist-packages/Trac-0.12.3-py2.7.egg/trac/ticket/model.py", line 854, in insert
    @self.env.with_transaction(db)
  File "/usr/local/lib/python2.7/dist-packages/Trac-0.12.3-py2.7.egg/trac/db/api.py", line 77, in transaction_wrapper
    fn(ldb)
  File "/usr/local/lib/python2.7/dist-packages/Trac-0.12.3-py2.7.egg/trac/ticket/model.py", line 863, in do_insert
    TicketSystem(self.env).reset_ticket_fields()
  File "/usr/local/lib/python2.7/dist-packages/Trac-0.12.3-py2.7.egg/trac/ticket/api.py", line 272, in reset_ticket_fields
    del self.fields
  File "/usr/local/lib/python2.7/dist-packages/Trac-0.12.3-py2.7.egg/trac/cache.py", line 47, in __delete__
    CacheManager(instance.env).invalidate(id)
  File "/usr/local/lib/python2.7/dist-packages/Trac-0.12.3-py2.7.egg/trac/cache.py", line 185, in invalidate
    @self.env.with_transaction()
  File "/usr/local/lib/python2.7/dist-packages/Trac-0.12.3-py2.7.egg/trac/db/api.py", line 73, in transaction_wrapper
    fn(ldb)
  File "/usr/local/lib/python2.7/dist-packages/Trac-0.12.3-py2.7.egg/trac/cache.py", line 195, in do_invalidate
    (id, 0))
  File "/usr/local/lib/python2.7/dist-packages/Trac-0.12.3-py2.7.egg/trac/db/util.py", line 65, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/local/lib/python2.7/dist-packages/Trac-0.12.3-py2.7.egg/trac/db/sqlite_backend.py", line 78, in execute
    result = PyFormatCursor.execute(self, *args)
  File "/usr/local/lib/python2.7/dist-packages/Trac-0.12.3-py2.7.egg/trac/db/sqlite_backend.py", line 56, in execute
    args or [])
  File "/usr/local/lib/python2.7/dist-packages/Trac-0.12.3-py2.7.egg/trac/db/sqlite_backend.py", line 48, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: table cache has 3 columns but 2 values were supplied

[Remy Blank]

Something is broken in your installation and / or environment. Your environment was upgraded to 1.0, but you are running 0.12.3. As such, it's an InstallationIssue.

[anonymous]

trac-admin upgrade should validate the database scheme and fix such issues. This issue should therefore be reopened. I'm experiencing the issue with 1.0.5.dev r14004. trac-admin upgrade says Database is up to date, no upgrade necessary., so that can't be write - either trac-admin upgrade needs to fail or trac needs to work.