Opened 3 years ago

Closed 2 years ago

#8754 closed defect (fixed)

OperationalError: near "faces": syntax error

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


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

Python Traceback

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

Attachments (0)

Change History (3)

comment:1 Changed 3 years ago by hasienda

  • Component changed from SELECT A HACK to DiscussionPlugin
  • Keywords SQL error added
  • Owner set to Blackhex

Better should be with this plugin, I guess.

comment:2 Changed 3 years ago by Blackhex

  • Status changed from new to assigned

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

as closed .
The resolution will be deleted. Next status will be 'reopened'.

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

Note: See TracTickets for help on using tickets.