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.