Modify

Opened 4 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

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 4 years ago by hasienda

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

Better should be with this plugin, I guess.

comment:2 Changed 4 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

Action
as closed The owner will remain Blackhex.
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.