OperationalError: (1136, "Column count doesn't match value count at row 1")

[maoz]

How to Reproduce

While doing a POST operation on /wiki/TestPage, Trac issued an internal error.

while trying to create new page on wiki, Trac issued an this error, (please provide additional details here)

Request parameters:

{'__FORM_TOKEN': u'4af4ec4587c5d10250f32cdb',
 'action': u'edit',
 'comment': u'',
 'editrows': u'8',
 'from_editor': u'1',
 'page': u'TestPage',
 'save': u'Submit changes',
 'scroll_bar_pos': u'0',
 'text': u'...',
 'version': u'0'}

User agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:41.0) Gecko/20100101 Firefox/41.0

System Information

Trac	1.0.9
Babel	0.9.4
Genshi	0.7 (without speedups)
mod_python	3.3.1
MySQL	server: "5.5.46-log", client: "5.1.54", thread-safe: 0
MySQLdb	1.2.5
Python	2.6.6 (r266:84292, Jul 23 2015, 15:22:56) [GCC 4.4.7 20120313 (Red Hat 4.4.7-11)]
pytz	2010h
setuptools	0.6
jQuery	1.4.4

Enabled Plugins

TracAccountManager	0.4.4
TracAutocompleteUsersPlugin	0.4.3
TracUserManagerPlugin	0.5dev

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 143, in process_request
    return self._do_save(req, versioned_page)
  File "/usr/lib/python2.6/site-packages/trac/wiki/web_ui.py", line 336, in _do_save
    req.remote_addr)
  File "/usr/lib/python2.6/site-packages/trac/wiki/model.py", line 130, in save
    @self.env.with_transaction(db)
  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/model.py", line 148, in do_save
    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/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 205, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
OperationalError: (1136, "Column count doesn't match value count at row 1")

[Ryan J Ollos]

You've filed the bug against WikiFormsPlugin, but WikiFormsPlugin is not included in the list of Enabled Plugins shown in comment:description.

The information in comment:description shows that Trac 1.0.9 is installed, but the traceback shows that the actual source code does not match Trac 1.0.9. Consider the following line of the traceback:

File "/usr/lib/python2.6/site-packages/trac/wiki/model.py", line 130, in save
    @self.env.with_transaction(db)

and compare to ​browser:tags/trac-1.0.9/trac/wiki/model.py@:130#L124.

Did you recently upgrade Trac? It appear you have an ​InstallationIssue. The solution could be as simple as restarting your web server. You could also try deleting the egg for the old version and reinstalling Trac.

If you continue to encounter issues or have additional questions, please ask on the ​MailingList. I'll reply there, and you'll also reach a larger audience of users that can help with your issue.