#351: OperationalError: near "m": syntax error
---------------------------+------------------------------------------------
Reporter: anonymous | Owner:
Type: Fehler/Defekt | Status: new
Priority: normal | Milestone:
Component: unbekannt | Version: 2.0 Final
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'884afd5f150c14212e7b8c1f',
'author': u'[email protected]',
'email': u'',
'field_cc': u'[email protected]',
'field_component': u'Treiber: Linux \u2013 Xkbmap',
'field_description': u"I'm using up-to-date kde and xkeyboard-config from
archlinux repos and encountered a strange behavior.\r\nwhen loading neo
via 'setxkbmap de neo' it breaks a whole lot of key combinations (i.e.
alt-tab, alt-f2, ctrl-esc).\r\nafter editing /usr/share/X11/xkb/symbols/de
and changing level 1 binding of numlock to NoSymbol, everything works
again.\r\nSo, why on earth is numlock defined as Tab?\r\n(same problem
also with xmodmap from this website)\r\nalso see bugreport on
freedesktop.org [0]\r\n[0]
https://bugs.freedesktop.org/show_bug.cgi?id=63457";,
'field_keywords': u'',
'field_milestone': u'',
'field_owner': u'',
'field_priority': u'normal',
'field_summary': u'Numlock as Tab breaks kwin',
'field_type': u'Fehler/Defekt',
'field_version': u'2.0 Final',
'recaptcha_challenge_field': u'03AHJ_VutdVGbSw-
1fiuF07w7hxxnMYTUGNf4JEklkX6Et8ZL5c7s5oD5c0d1JoTz9vHE1ArUmf7P4B6yT23qIuFusTVn1XVVAl0D8PmocC5ihzyJjnSLWN7PSooD7LxBsDk0z1GWVeQ_M3uBfM_wQdhcKfJF87-axJXyqfrnmXtI5gxsmGAczqZM',
'recaptcha_response_field': u'lishippr except',
'submit': u'Create ticket',
'url': u'6808443'}
}}}
User Agent was: `Mozilla/5.0 (X11; Linux x86_64; rv:20.0) Gecko/20100101
Firefox/20.0`
==== System Information ====
|| '''Trac''' || `0.11.7` ||
|| '''Python''' || `2.6.6 (r266:84292, Dec 26 2010, 22:48:11) ` [[br]]
`[GCC 4.4.5]` ||
|| '''setuptools''' || `0.6` ||
|| '''SQLite''' || `3.7.3` ||
|| '''pysqlite''' || `2.4.1` ||
|| '''Genshi''' || `0.6` ||
|| '''mod_python''' || `3.3.1` ||
|| '''Pygments''' || `1.3.1` ||
|| '''Subversion''' || `1.6.12 (r955767)` ||
|| '''RPC''' || `1.0.6` ||
|| '''jQuery:''' || `1.4.2` ||
==== Python Traceback ====
{{{
Traceback (most recent call last):
File "/usr/lib/python2.6/dist-packages/trac/web/main.py", line 450, in
_dispatch_request
dispatcher.dispatch(req)
File "/usr/lib/python2.6/dist-packages/trac/web/main.py", line 206, in
dispatch
resp = chosen_handler.process_request(req)
File "/usr/lib/python2.6/dist-packages/trac/ticket/web_ui.py", line 183,
in process_request
return self._process_newticket_request(req)
File "/usr/lib/python2.6/dist-packages/trac/ticket/web_ui.py", line 397,
in _process_newticket_request
valid = self._validate_ticket(req, ticket)
File "/usr/lib/python2.6/dist-packages/trac/ticket/web_ui.py", line 989,
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 65, in
execute
return self.cursor.execute(sql)
File "/usr/lib/python2.6/dist-packages/trac/db/sqlite_backend.py", line
80, in execute
result = PyFormatCursor.execute(self, *args)
File "/usr/lib/python2.6/dist-packages/trac/db/sqlite_backend.py", line
59, in execute
args or [])
File "/usr/lib/python2.6/dist-packages/trac/db/sqlite_backend.py", line
51, in _rollback_on_error
return function(self, *args, **kwargs)
OperationalError: near "m": syntax error
}}}
--
Ticket URL: <http://wiki.neo-layout.org/ticket/351>
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.
