Edgewall Software
Modify

Opened 5 years ago

Closed 5 years ago

Last modified 5 years ago

#11639 closed defect (cantfix)

TypeError: 'ConnectionWrapper' object is not iterable

Reported by: dhealey@… Owned by:
Priority: high Milestone:
Component: query system Version: 1.1dev
Severity: blocker Keywords:
Cc: Branch:
Release Notes:
API Changes:

Description

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

Attachments (0)

Change History (4)

comment:1 by Ryan J Ollos, 5 years ago

Resolution: cantfix
Status: newclosed

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.

Last edited 5 years ago by Ryan J Ollos (previous) (diff)

comment:2 by Jun Omae, 5 years ago

Component: report systemquery system
Keywords: Reporting removed
Version: 1.0dev1.1dev

comment:4 by bobbysmith007@…, 5 years ago

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

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The ticket will remain with no owner.
The resolution will be deleted.
to The owner will be changed from (none) to the specified user.

Add Comment


E-mail address and name can be saved in the Preferences .
 
Note: See TracTickets for help on using tickets.