Modify ↓
      
#12128 closed defect (cantfix)
OperationalError: table cache has 3 columns but 2 values were supplied
| Reported by: | admin | Owned by: | |
|---|---|---|---|
| Priority: | normal | Milestone: | |
| Component: | general | Version: | |
| Severity: | normal | Keywords: | |
| Cc: | Branch: | ||
| Release Notes: | |||
| API Changes: | |||
| Internal Changes: | |||
Description
How to Reproduce
While doing a POST operation on /wiki/WikiStart, Trac issued an internal error.
(please provide additional details here)
Request parameters:
{'__FORM_TOKEN': u'c73ab81a7529fad9789ec526',
 'action': u'delete',
 'page': u'WikiStart'}
User agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/41.0.2272.101 Safari/537.36
System Information
 Trac  |  1.0.6.post2 
 | 
 Babel  |  0.9.4 
 | 
 Docutils  |  0.12 
 | 
 Genshi  |  0.7 (without speedups) 
 | 
 mod_wsgi  |  3.2 (WSGIProcessGroup  WSGIApplicationGroup %{GLOBAL}) 
 | 
 pysqlite  |  2.4.1 
 | 
 Python  |  2.6.6 (r266:84292, Jan 22 2014, 09:42:36)  [GCC 4.4.7 20120313 (Red Hat 4.4.7-4)] 
 | 
 pytz  |  2015.4 
 | 
 setuptools  |  18.0.1 
 | 
 SQLite  |  3.6.20 
 | 
 jQuery  |  1.7.2 
 | 
Enabled Plugins
 TracAccountManager  |  0.4.4 
 | 
Python Traceback
Traceback (most recent call last):
  File "/usr/lib/python2.6/site-packages/trac/web/main.py", line 525, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.6/site-packages/trac/web/main.py", line 246, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.6/site-packages/trac/wiki/web_ui.py", line 147, in process_request
    self._do_delete(req, versioned_page)
  File "/usr/lib/python2.6/site-packages/trac/wiki/web_ui.py", line 254, in _do_delete
    @self.env.with_transaction()
  File "/usr/lib/python2.6/site-packages/trac/db/api.py", line 77, in transaction_wrapper
    fn(ldb)
  File "/usr/lib/python2.6/site-packages/trac/wiki/web_ui.py", line 262, in do_delete
    page.delete(version, db)
  File "/usr/lib/python2.6/site-packages/trac/wiki/model.py", line 87, in delete
    @self.env.with_transaction(db)
  File "/usr/lib/python2.6/site-packages/trac/db/api.py", line 71, in transaction_wrapper
    fn(db)
  File "/usr/lib/python2.6/site-packages/trac/wiki/model.py", line 106, in do_delete
    del WikiSystem(self.env).pages
  File "/usr/lib/python2.6/site-packages/trac/cache.py", line 47, in __delete__
    CacheManager(instance.env).invalidate(id)
  File "/usr/lib/python2.6/site-packages/trac/cache.py", line 185, in invalidate
    @self.env.with_transaction()
  File "/usr/lib/python2.6/site-packages/trac/db/api.py", line 73, in transaction_wrapper
    fn(ldb)
  File "/usr/lib/python2.6/site-packages/trac/cache.py", line 195, in do_invalidate
    (id, 0))
  File "/usr/lib/python2.6/site-packages/trac/db/util.py", line 65, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.6/site-packages/trac/db/sqlite_backend.py", line 78, in execute
    result = PyFormatCursor.execute(self, *args)
  File "/usr/lib/python2.6/site-packages/trac/db/sqlite_backend.py", line 56, in execute
    args or [])
  File "/usr/lib/python2.6/site-packages/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
      Attachments (0)
  Note:
 See   TracTickets
 for help on using tickets.
    


  
InstallationIssue. See #10959. It seems you are still running code from a Trac 0.12.x release even though the database has been upgraded to 1.0.x. Please try reinstalling Trac.