﻿id	summary	reporter	owner	description	type	status	priority	milestone	component	version	resolution	keywords	cc
184	"OperationalError: near ""t"": syntax error"	anonymous		"==== 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) ` [[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

}}}
    "	Fehler/Defekt	closed	normal	Neo Version 2.0	Dokumentation/Wiki/Webseiten	2.0 BETA	invalid		
