#184: OperationalError: near "t": syntax error
------------------------------------------+---------------------------------
Reporter: anonymous | Owner:
Type: Fehler/Defekt | Status: new
Priority: normal | Milestone: Neo Version 2.0
Component: Dokumentation/Wiki/Webseiten | Version: 2.0 BETA
Keywords: |
------------------------------------------+---------------------------------
==== 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'[email protected]',
'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) `
[[br]] `[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
}}}
--
Ticket URL: <https://wiki.neo-layout.org/ticket/184>
Neo-Layout <http://neo-layout.org/>
Das Neo-Tastaturlayout ist ein freies und ergonomisch optimiertes
Tastaturlayout für die deutsche Sprache, das auch sehr viele Sonderzeichen
direkt verfügbar macht.
