id,summary,reporter,owner,description,type,status,priority,component,severity,resolution,keywords,cc,release 11385,ProgrammingError: You cannot execute SELECT statements in executemany().,matteo.devilli@…,Chris Nelson,"==== 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'5eabd14b40fbec3d0683fa58', 'field_billable': u'1', 'field_blockedby': u'', 'field_blocking': u'', 'field_cc': u'', 'field_checkbox_billable': u'1', 'field_component': u'HW-Mecc/El', 'field_description': u'', 'field_estimatedhours': u'0', 'field_hours': u'0', 'field_keywords': u'', 'field_milestone': u'', 'field_owner': u'', 'field_parent': u'', 'field_parents': u'', 'field_priority': u'major', 'field_project': u'', 'field_reporter': u'devilli', 'field_summary': u'prova', 'field_type': u'sviluppo', 'field_userfinish': u'2013-11-13', 'field_userstart': u'2013-11-13', 'submit': u'Create ticket'} }}} User agent: `Mozilla/5.0 (Windows NT 6.1; WOW64; rv:25.0) Gecko/20100101 Firefox/25.0` ==== System Information ==== || '''`Trac`''' || `1.0.1` || || '''`Genshi`''' || `0.6 (without speedups)` || || '''`Pygments`''' || `1.4` || || '''`pysqlite`''' || `2.4.1` || || '''`Python`''' || `2.6.5 (r265:79063, Apr 16 2010, 13:09:56) ` [[br]] `[GCC 4.4.3]` || || '''`setuptools`''' || `0.6c11` || || '''`SQLite`''' || `3.6.22` || || '''`Subversion`''' || `1.6.6 (r40053)` || || '''`jQuery`''' || `1.7.2` || ==== Enabled Plugins ==== || '''`BatchModify`''' || `0.8.1-trac0.12dev` || || '''`SimpleMultiProject`''' || `0.0.3dev` || || '''`timingandestimationplugin`''' || `1.3.7` || || '''`Trac-jsGantt`''' || `0.10-r13401` || || '''`Tracchildtickets`''' || `2.5.2` || || '''`TracSubTicketsPlugin`''' || `0.2.0.dev-20131113` || ==== Python Traceback ==== {{{ Traceback (most recent call last): File ""build/bdist.linux-i686/egg/trac/web/main.py"", line 497, in _dispatch_request dispatcher.dispatch(req) File ""build/bdist.linux-i686/egg/trac/web/main.py"", line 214, in dispatch resp = chosen_handler.process_request(req) File ""build/bdist.linux-i686/egg/trac/ticket/web_ui.py"", line 180, in process_request return self._process_newticket_request(req) File ""build/bdist.linux-i686/egg/trac/ticket/web_ui.py"", line 465, in _process_newticket_request self._do_create(req, ticket) # (redirected if successful) File ""build/bdist.linux-i686/egg/trac/ticket/web_ui.py"", line 1289, in _do_create ticket.insert() File ""build/bdist.linux-i686/egg/trac/ticket/model.py"", line 256, in insert listener.ticket_created(self) File ""build/bdist.linux-i686/egg/tracjsgantt/tracpm.py"", line 2946, in ticket_created self.rescheduleTickets(ticket, {}) File ""build/bdist.linux-i686/egg/tracjsgantt/tracpm.py"", line 2741, in rescheduleTickets ids = self._findAffected(ticket, old_values) File ""build/bdist.linux-i686/egg/tracjsgantt/tracpm.py"", line 2443, in _findAffected toExplore = more(border) File ""build/bdist.linux-i686/egg/tracjsgantt/tracpm.py"", line 2402, in more newOwners = ownersOf(n) File ""build/bdist.linux-i686/egg/tracjsgantt/tracpm.py"", line 2322, in ownersOf cursor.executemany(query, values) File ""build/bdist.linux-i686/egg/trac/db/util.py"", line 85, in executemany return self.cursor.executemany(sql_escape_percent(sql), args) File ""build/bdist.linux-i686/egg/trac/db/sqlite_backend.py"", line 62, in executemany args) File ""build/bdist.linux-i686/egg/trac/db/sqlite_backend.py"", line 48, in _rollback_on_error return function(self, *args, **kwargs) ProgrammingError: You cannot execute SELECT statements in executemany(). }}}",defect,new,normal,TracJsGanttPlugin,normal,,,lukasz.korpalski@… Sebastian neoxlaws@…,