Edgewall Software

Opened 5 years ago

Closed 5 years ago

Last modified 5 years ago

#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:


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
  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
  File "/usr/lib/python2.6/site-packages/trac/db/api.py", line 77, in transaction_wrapper
  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
  File "/usr/lib/python2.6/site-packages/trac/db/api.py", line 71, in transaction_wrapper
  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__
  File "/usr/lib/python2.6/site-packages/trac/cache.py", line 185, in invalidate
  File "/usr/lib/python2.6/site-packages/trac/db/api.py", line 73, in transaction_wrapper
  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)

Change History (1)

comment:1 by Ryan J Ollos, 5 years ago

Resolution: cantfix
Status: newclosed

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.

Last edited 5 years ago by Ryan J Ollos (previous) (diff)

Modify Ticket

Change Properties
Set your email in Preferences
as closed The ticket will remain with no owner.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from (none) to the specified user.

Add Comment

E-mail address and name can be saved in the Preferences .
Note: See TracTickets for help on using tickets.