OperationalError: near "t": syntax error #184

New Issue

anonymous · 2009-12-16T11:09:13+01:00

anonymous commented

2009-12-16 11:09:13 +01:00

How to Reproduce

While doing a POST operation on /newticket, Trac issued an internal error.

(please provide additional details here)

Request parameters:

{'__FORM_TOKEN': u'282ba1bde75983ce2dc36fa2',
 'author': u'j_i_m@web.de',
 'email': u'',
 'field_cc': u'',
 'field_component': u'Treiber: Windows \u2013 Kbdneo',
 'field_description': u"In the keyboard view on the NEO homepage the position of \u20ac is on SHIFT-7 and the position of $ is on SHIFT-6. But in the windows 64bit driver the mapping of these two keys are swapped. I didn't check other driver versions.",
 'field_keywords': u'',
 'field_milestone': u'Neo Version 2.0',
 'field_owner': u'',
 'field_priority': u'normal',
 'field_status': u'new',
 'field_summary': u'Position of \u20ac and $ swapped',
 'field_type': u'Fehler/Defekt',
 'field_version': u'2.0 BETA',
 'submit': u'Create ticket',
 'url': u'6135116'}

User Agent was: Mozilla/5.0 (Windows; U; Windows NT 6.1; de; rv:1.9.1.6) Gecko/20091201 Firefox/3.5.6

System Information

Trac	`0.11.1`
Python	`2.6.2 (release26-maint, Apr 19 2009, 02:11:59)`
`[GCC 4.3.3]`
setuptools	`0.6c9`
SQLite	`3.6.10`
pysqlite	`2.5.0`
Genshi	`0.5.1`
mod_python	`3.3.1`
Pygments	`0.10`
Subversion	`1.5.4 (r33841)`
RPC	`1.0.6`
jQuery:	`1.2.6`

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.6/dist-packages/trac/web/main.py", line 423, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.6/dist-packages/trac/web/main.py", line 197, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.6/dist-packages/trac/ticket/web_ui.py", line 171, in process_request
    return self._process_newticket_request(req)
  File "/usr/lib/python2.6/dist-packages/trac/ticket/web_ui.py", line 378, in _process_newticket_request
    valid = self._validate_ticket(req, ticket)
  File "/usr/lib/python2.6/dist-packages/trac/ticket/web_ui.py", line 945, in _validate_ticket
    for field, message in manipulator.validate_ticket(req, ticket):
  File "build/bdist.linux-i686/egg/mathcaptcha/MathCaptcha.py", line 305, in validate_ticket
    return self.validate_mathcaptcha(req)
  File "build/bdist.linux-i686/egg/mathcaptcha/MathCaptcha.py", line 220, in validate_mathcaptcha
    self.store_failed_attempt(req, id, user_solution)
  File "build/bdist.linux-i686/egg/mathcaptcha/MathCaptcha.py", line 251, in store_failed_attempt
    self.get_failed_attempt_text(req), id))
  File "/usr/lib/python2.6/dist-packages/trac/db/util.py", line 51, in execute
    return self.cursor.execute(sql)
  File "/usr/lib/python2.6/dist-packages/trac/db/sqlite_backend.py", line 58, in execute
    args or [])
  File "/usr/lib/python2.6/dist-packages/trac/db/sqlite_backend.py", line 50, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: near "t": syntax error

#### How to Reproduce While doing a POST operation on `/newticket`, Trac issued an internal error. *(please provide additional details here)* Request parameters: ``` {'__FORM_TOKEN': u'282ba1bde75983ce2dc36fa2', 'author': u'j_i_m@web.de', 'email': u'', 'field_cc': u'', 'field_component': u'Treiber: Windows \u2013 Kbdneo', 'field_description': u"In the keyboard view on the NEO homepage the position of \u20ac is on SHIFT-7 and the position of $ is on SHIFT-6. But in the windows 64bit driver the mapping of these two keys are swapped. I didn't check other driver versions.", 'field_keywords': u'', 'field_milestone': u'Neo Version 2.0', 'field_owner': u'', 'field_priority': u'normal', 'field_status': u'new', 'field_summary': u'Position of \u20ac and $ swapped', 'field_type': u'Fehler/Defekt', 'field_version': u'2.0 BETA', 'submit': u'Create ticket', 'url': u'6135116'} ``` User Agent was: `Mozilla/5.0 (Windows; U; Windows NT 6.1; de; rv:1.9.1.6) Gecko/20091201 Firefox/3.5.6` #### System Information | **Trac** | `0.11.1` | | :---: | :---: | | **Python** | `2.6.2 (release26-maint, Apr 19 2009, 02:11:59) ` `[GCC 4.3.3]` | | **setuptools** | `0.6c9` | | **SQLite** | `3.6.10` | | **pysqlite** | `2.5.0` | | **Genshi** | `0.5.1` | | **mod_python** | `3.3.1` | | **Pygments** | `0.10` | | **Subversion** | `1.5.4 (r33841)` | | **RPC** | `1.0.6` | | **jQuery:** | `1.2.6` | #### Python Traceback ``` Traceback (most recent call last): File "/usr/lib/python2.6/dist-packages/trac/web/main.py", line 423, in _dispatch_request dispatcher.dispatch(req) File "/usr/lib/python2.6/dist-packages/trac/web/main.py", line 197, in dispatch resp = chosen_handler.process_request(req) File "/usr/lib/python2.6/dist-packages/trac/ticket/web_ui.py", line 171, in process_request return self._process_newticket_request(req) File "/usr/lib/python2.6/dist-packages/trac/ticket/web_ui.py", line 378, in _process_newticket_request valid = self._validate_ticket(req, ticket) File "/usr/lib/python2.6/dist-packages/trac/ticket/web_ui.py", line 945, in _validate_ticket for field, message in manipulator.validate_ticket(req, ticket): File "build/bdist.linux-i686/egg/mathcaptcha/MathCaptcha.py", line 305, in validate_ticket return self.validate_mathcaptcha(req) File "build/bdist.linux-i686/egg/mathcaptcha/MathCaptcha.py", line 220, in validate_mathcaptcha self.store_failed_attempt(req, id, user_solution) File "build/bdist.linux-i686/egg/mathcaptcha/MathCaptcha.py", line 251, in store_failed_attempt self.get_failed_attempt_text(req), id)) File "/usr/lib/python2.6/dist-packages/trac/db/util.py", line 51, in execute return self.cursor.execute(sql) File "/usr/lib/python2.6/dist-packages/trac/db/sqlite_backend.py", line 58, in execute args or []) File "/usr/lib/python2.6/dist-packages/trac/db/sqlite_backend.py", line 50, in _rollback_on_error return function(self, *args, **kwargs) OperationalError: near "t": syntax error ```

anonymous added the

Bug

Dokumentation

labels 2009-12-16 11:09:13 +01:00

martin_r closed this issue

2010-09-20 11:20:07 +02:00

martin_r added the

Invalid

label 2010-09-20 11:20:07 +02:00

Sign in to join this conversation.