OperationalError: near "m": syntax error #351

New Issue

anonymous · 2013-04-18T15:38:02+02:00

anonymous commented

2013-04-18 15:38:02 +02: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'884afd5f150c14212e7b8c1f',
 'author': u'g.schlisio@dukun.de',
 'email': u'',
 'field_cc': u'g.schlisio@dukun.de',
 '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)`
`[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

#### 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'g.schlisio@dukun.de', 'email': u'', 'field_cc': u'g.schlisio@dukun.de', '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) ` `[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 ```

anonymous added the

Bug

label 2013-04-18 15:38:02 +02:00

anonymous closed this issue

2013-04-26 09:34:24 +02:00

anonymous added the

Invalid

label 2013-04-26 09:34:24 +02:00

Sign in to join this conversation.

No Milestone

No Assignees

1 Participants

Notifications

Due Date

The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: neo/neo-layout#351