TypeError: 'ConnectionWrapper' object is not iterable

[dhealey@…]

How to Reproduce

While doing a GET operation on /query, Trac issued an internal error.

(please provide additional details here)

Request parameters:

{'col': [u'id',
         u'summary',
         u'fixed_in_build',
         u'component',
         u'milestone',
         u'status',
         u'owner',
         u'type',
         u'priority',
         u'version',
         u'resolution',
         u'media',
         u'cross_ref',
         u'reference'],
 'component': [u'ART Software',
               u'EESOH-MIS Application',
               u'EESOH-MIS Database',
               u'ART Database'],
 'fixed_in_build': u'!~RC0',
 'format': u'tab',
 'max': u'350',
 'milestone': u'1.5.0.0',
 'order': u'id',
 'report': u'43',
 'status': u'verified'}

User agent: #USER_AGENT#

System Information

Trac	1.1.2dev-r0
Babel	0.9.4
Docutils	0.6
Genshi	0.6.1 (without speedups)
mod_wsgi	3.4 (WSGIProcessGroup WSGIApplicationGroup trac.eesohsupport.com)
MySQL	server: "5.1.73-log", client: "5.1.73", thread-safe: 1
MySQLdb	1.2.3c1
Pygments	1.1.1
Python	2.6.6 (r266:84292, Jul 10 2013, 06:42:56) [GCC 4.4.7 20120313 (Red Hat 4.4.7-3)]
pytz	2010h
setuptools	0.6
Subversion	1.9.0 (under development)
jQuery	#JQUERY#
jQuery UI	#JQUERYUI#
jQuery Timepicker	#JQUERYTP#

Enabled Plugins

AdvancedTicketWorkflowPlugin	0.11dev
ContextMenuPlugin	0.2dev
gantt	0.3dev
HudsonTrac	0.5
ImportExportXLS	0.1.6
IniAdmin	0.3
mail2trac	1
MultipleWorkflowPlugin	1.0
NavAdd	0.1
ticketvalidator.admin	N/A
ticketvalidator.core	N/A
timingandestimationplugin	1.3.7b
TracAccountManager	0.5dev
TracBrowserSvnOperations	0.1
TracCondFields	2.0
TracCustomFieldAdmin	0.2.8
TracDiscussion	0.8
TracDragDrop	0.12.0.11
TracDynamicFields	2.2.0dev
TracMasterTickets	3.0.5dev-r0
TracMenusPlugin	0.1.1
TracReportManager	0.1
tracreposearch	0.2
TracRevtreePlugin	0.6.4dev
TracScheduler	0.1
TracSecDl	0.1.2
TracSubTicketsPlugin	0.2.0.dev-20130917
TracWorkflowAdmin	0.12.0.2
WorkflowEditorPlugin	1.2.0dev

Python Traceback

Traceback (most recent call last):
  File "build/bdist.linux-x86_64/egg/trac/web/main.py", line 530, in _dispatch_request
    dispatcher.dispatch(req)
  File "build/bdist.linux-x86_64/egg/trac/web/main.py", line 223, in dispatch
    resp = chosen_handler.process_request(req)
  File "build/bdist.linux-x86_64/egg/trac/ticket/query.py", line 961, in process_request
    format, filename=filename)
  File "build/bdist.linux-x86_64/egg/trac/mimeview/api.py", line 1009, in send_converted
    content, selector)
  File "build/bdist.linux-x86_64/egg/trac/mimeview/api.py", line 696, in convert_content
    output = converter.convert_content(req, mimetype, content, ck)
  File "build/bdist.linux-x86_64/egg/trac/ticket/query.py", line 857, in convert_content
    mimetype='text/tab-separated-values')
  File "build/bdist.linux-x86_64/egg/timingandestimationplugin/tande_filters.py", line 54, in new_csv_export
    results = query.execute(req, self.env.get_read_db())
  File "build/bdist.linux-x86_64/egg/trac/ticket/query.py", line 294, in execute
    sql, args = self.get_sql(req, cached_ids, authname, tzinfo, locale)
  File "build/bdist.linux-x86_64/egg/trac/ticket/query.py", line 622, in get_sql
    (','.join([str(id) for id in cached_ids])))
TypeError: 'ConnectionWrapper' object is not iterable

[Ryan J Ollos]

PluginIssue - ​th:TimingAndEstimationPlugin.

In [12826] we removed the deprecated db parameter from execute. ​th:TimingAndEstimationPlugin simply needs to change line 54 in timingandestimationplugin/tande_filters.py:

-results = query.execute(req, self.env.get_read_db())
+results = query.execute(req)

​th:TimingAndEstimationPlugin can make that change and be backward compatible to Trac 1.0, but not earlier versions of Trac.

[Ryan J Ollos]

Reported to ​th:TimingAndEstimationPlugin in ​th:#11898.

[bobbysmith007@…]

This plugin has been updated to be inline with trac1.0 standards and hopefully this issue resolved.

Cheers and thanks for the continued good work