Modify

Opened 3 years ago

Closed 2 years 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 2 years 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 .
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.