Modify

Opened 6 years ago

Closed 5 years ago

#9593 closed defect (fixed)

OperationalError: near "OK": syntax error

Reported by: dusanov Owned by: Radek Bartoň
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 6 years ago by Ryan J Ollos

Component: SELECT A HACKDiscussionPlugin
Owner: changed from anonymous to Radek Bartoň

comment:2 Changed 6 years ago by Radek Bartoň

Status: newassigned

Thank you for reporting.

comment:3 Changed 5 years ago by Ryan J Ollos

Resolution: fixed
Status: assignedclosed

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

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain Radek Bartoň.
The resolution will be deleted.

Add Comment


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

 
Note: See TracTickets for help on using tickets.