Modify

Opened 3 years ago

Closed 22 months ago

#9593 closed defect (fixed)

OperationalError: near "OK": syntax error

Reported by: dusanov Owned by: Blackhex
Priority: normal Component: DiscussionPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.11

Description

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

Attachments (0)

Change History (3)

comment:1 Changed 3 years ago by rjollos

  • Component changed from SELECT A HACK to DiscussionPlugin
  • Owner set to Blackhex

comment:2 Changed 3 years ago by Blackhex

  • Status changed from new to assigned

Thank you for reporting.

comment:3 Changed 22 months ago by rjollos

  • Resolution set to fixed
  • Status changed from assigned to closed

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

Add Comment

Modify Ticket

Action
as closed .
as The resolution will be set. Next status will be 'closed'.
to The owner will be changed from Blackhex. Next status will be 'closed'.
The resolution will be deleted. Next status will be 'reopened'.
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.