neo/neo-layout
18
15
Fork 25
Code Issues 77 Pull Requests 3 Releases Wiki Activity

OperationalError: near "m": syntax error #351

New Issue
Closed
opened 2013-04-18 15:38:02 +02:00 by anonymous · 0 comments
anonymous commented 2013-04-18 15:38:02 +02:00
Copy Link

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 added the
Invalid
 label 2013-04-26 09:34:24 +02:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels   
(╯°□°）╯︵ ┻━┻

   
Bug

   
Diskussion

Besprechungen zu einem Thema mit offenem Ausgang

  
Dokumentation

   
Duplikat

Ähnliche Issues vorhanden

  
Gitea

   
Hardware

   
Hilfe

Unterstützung gesucht

  
Invalid

   
Java

   
Lernen

Tipptrainer und andere Hilfsmittel

  
Qt

   
Remote

VM, Remote Desktop usw.

  
Subversion

   
Tablet

   
Tastaturbelegung

   
Test

   
Treiber/Android

   
Treiber/iOS

   
Treiber/Linux/Konsole

   
Treiber/Linux/xkb

   
Treiber/Linux/xmodmap

   
Treiber/MacOS

   
Treiber/Windows/AHK

   
Treiber/Windows/kbdneo

   
Treiber/Windows/ReNeo

   
Verbesserung

   
Website

   
Windows 11

   
Wontfix

Wird nicht behoben

  
Worksforme
No Label
(╯°□°）╯︵ ┻━┻
Bug
Diskussion
Dokumentation
Duplikat
Gitea
Hardware
Hilfe
Invalid
Java
Lernen
Qt
Remote
Subversion
Tablet
Tastaturbelegung
Test
Treiber/Android
Treiber/iOS
Treiber/Linux/Konsole
Treiber/Linux/xkb
Treiber/Linux/xmodmap
Treiber/MacOS
Treiber/Windows/AHK
Treiber/Windows/kbdneo
Treiber/Windows/ReNeo
Verbesserung
Website
Windows 11
Wontfix
Worksforme
Milestone
Clear milestone
No items
No Milestone
Assignees
Clear assignees
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
No description provided.
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?