OperationalError: near "faces": syntax error

[zgan]

How to Reproduce

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

(please provide additional details here)

Request parameters:

{'__FORM_TOKEN': u'2289ff6d1a79feac97cf721a',
 'author': u'zgan',
 'body': u'Let me lay out my primary concern about structure. The way I see it there are three basic "faces" to q-chem. 1) core capabilities [integrals and tensor engines, abstract solvers, etc] 2) prime-time methods [HF, MP2, EOM-CC, (TD-)DFT, and geometry optimizer for the forgoing, etc] 3) People\'s toys and experiments ',
 'discussion_action': u'post-add',
 'forum': u'3',
 'subject': u'Comments on code structure by Anthony',
 'submit': u'Submit',
 'subscribers': u''}

User agent: Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; OfficeLiveConnector.1.3; OfficeLivePatch.0.0; InfoPath.2; .NET4.0C; .NET4.0E; MS-RTC EA 2; MS-RTC LM 8; MALC)

System Information

Trac	0.12
Docutils	0.7
Genshi	0.6
mod_wsgi	3.3 (WSGIProcessGroup WSGIApplicationGroup %{GLOBAL})
pysqlite	2.4.1
Python	2.6.2 (r262:71600, Oct 24 2009, 03:15:21) [GCC 4.4.1 [gcc-4_4-branch revision 150839]]
setuptools	0.6c9
SQLite	3.6.16
Subversion	1.6.6 (r40053)
jQuery	1.4.2

Enabled Plugins

TracAccountManager	0.3dev-r0
TracDiscussion	0.7-r0
TracDoxygen	0.11.0.2
TracTocMacro	11.0.0.3

Python Traceback

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

[Steffen Hoffmann]

Better should be with this plugin, I guess.

[Radek Bartoň]

Ok, thanks 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.