OperationalError: near "OK": syntax error

[dusanov]

How to Reproduce

While doing a POST operation on /discussion/forum/2, Trac issued an internal error.

(please provide additional details here)

Request parameters:

{'__FORM_TOKEN': u'2d3506df3bd198db27ded7fe',
 'author': u'dusanov',
 'body': u'"OK sadsadasd "',
 'discussion_action': u'post-add',
 'forum': u'2',
 'subject': u'',
 'submit': u'Submit',
 'subscribers': u''}

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

System Information

Trac	0.12.2
Babel	0.9.5
Docutils	0.7
Genshi	0.6
Pygments	1.4
pysqlite	2.4.1
Python	2.6.6 (r266:84292, Dec 27 2010, 00:02:40) [GCC 4.4.5]
setuptools	0.6c11
SQLite	3.7.3
jQuery	1.4.2

Enabled Plugins

NavAdd	0.1
TracAccountManager	0.3.2
TracDiscussion	0.7-r8725
TracDownloads	0.3
TracGit	0.12.0.5dev

Python Traceback

Traceback (most recent call last):
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/trac/web/main.py", line 511, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/trac/web/main.py", line 237, in dispatch
    resp = chosen_handler.process_request(req)
  File "build/bdist.linux-i686/egg/tracdiscussion/core.py", line 111, in process_request
    template, data = api.process_discussion(context)
  File "build/bdist.linux-i686/egg/tracdiscussion/api.py", line 245, in process_discussion
    self._do_actions(context, actions)
  File "build/bdist.linux-i686/egg/tracdiscussion/api.py", line 960, in _do_actions
    self.add_topic(context, topic)
  File "build/bdist.linux-i686/egg/tracdiscussion/api.py", line 1746, in add_topic
    self._add_item(context, 'topic', tmp_topic)
  File "build/bdist.linux-i686/egg/tracdiscussion/api.py", line 1725, in _add_item
    context.cursor.execute(sql)
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/trac/db/util.py", line 66, in execute
    return self.cursor.execute(sql)
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/trac/db/sqlite_backend.py", line 78, in execute
    result = PyFormatCursor.execute(self, *args)
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/trac/db/sqlite_backend.py", line 56, in execute
    args or [])
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/trac/db/sqlite_backend.py", line 48, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: near "OK": syntax error

[Radek Bartoň]

Thank you for reporting.

[Ryan J Ollos]

I appears to have been fixed in [9456]. Please reopen if you continue to have trouble after upgrading to the latest version.