Modify

Opened 6 years ago

Closed 5 years ago

#8754 closed defect (fixed)

OperationalError: near "faces": syntax error

Reported by: zgan Owned by: Radek Bartoň
Priority: normal Component: DiscussionPlugin
Severity: normal Keywords: SQL error
Cc: Trac Release: 0.11

Description

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

Attachments (0)

Change History (3)

comment:1 Changed 6 years ago by Steffen Hoffmann

Component: SELECT A HACKDiscussionPlugin
Keywords: SQL error added
Owner: changed from anonymous to Radek Bartoň

Better should be with this plugin, I guess.

comment:2 Changed 6 years ago by Radek Bartoň

Status: newassigned

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