Running a report generates error

[Dave Morgan]

I updated to v12 - and also updated to the latest blackmagic.

All seems good except for one report - when I run this one particular report it generates an error:

Trac detected an internal error: KeyError: id

[anonymous]

Trac 0.12.1 Docutils 0.5 Genshi 0.6 mod_python 3.3.1 MySQL server: "5.1.37-log", client: "5.1.37", thread-safe: 1 MySQLdb 1.2.3c1 Pygments 1.1.1 Python 2.6 (r26:66714, Jun 8 2009, 16:07:26) [GCC 4.4.0 20090506 (Red Hat 4.4.0-4)] setuptools 0.6c9 Subversion 1.6.5 (r38866) jQuery 1.4.2

AdvancedTicketWorkflowPlugin 0.10dev /usr/lib/python2.6/site-packages/AdvancedTicketWorkflowPlugin-0.10dev-py2.6.egg BlackMagicTicketTweaks 0.12r1 /usr/lib/python2.6/site-packages/BlackMagicTicketTweaks-0.12r1-py2.6.egg EstimationTools 0.4 /usr/lib/python2.6/site-packages/EstimationTools-0.4-py2.6.egg MilestoneTeams 0.15 /usr/lib/python2.6/site-packages/MilestoneTeams-0.15-py2.6.egg TicketCreationStatus 0.1 /usr/lib/python2.6/site-packages/TicketCreationStatus-0.1-py2.6.egg ticketvalidator.admin N/A /usr/lib/python2.6/site-packages/TicketValidator-0.1-py2.6.egg/ticketvalidator/admin.pyc ticketvalidator.core N/A /usr/lib/python2.6/site-packages/TicketValidator-0.1-py2.6.egg/ticketvalidator/core.pyc TracAccountManager 0.3dev /usr/lib/python2.6/site-packages/TracAccountManager-0.3dev-py2.6.egg TracDateField 1.0.1 /usr/lib/python2.6/site-packages/TracDateField-1.0.1-py2.6.egg TracMasterTickets 3.0.1 /usr/lib/python2.6/site-packages/TracMasterTickets-3.0.1-py2.6.egg TracUserManagerPlugin 0.4 /usr/lib/python2.6/site-packages/TracUserManagerPlugin-0.4-py2.6.egg TypedTicketWorkflow-plugin 0.1dev /usr/lib/python2.6/site-packages/TypedTicketWorkflow_plugin-0.1dev-py2.6.egg

[Dave Morgan]

Well that wasnt very readable... lets try again....

• Trac 0.12.1
• Docutils 0.5
• Genshi 0.6
• mod_python 3.3.1
• MySQL server: "5.1.37-log", client: "5.1.37", thread-safe: 1
• MySQLdb 1.2.3c1
• Pygments 1.1.1
• Python 2.6 (r26:66714, Jun 8 2009, 16:07:26) [GCC 4.4.0 20090506 (Red Hat 4.4.0-4)]
• setuptools 0.6c9
• Subversion 1.6.5 (r38866)
• jQuery 1.4.2

[Dave Morgan]

<BR>AdvancedTicketWorkflowPlugin 0.10dev /usr/lib/python2.6/site-packages/AdvancedTicketWorkflowPlugin-0.10dev-py2.6.egg <BR>BlackMagicTicketTweaks 0.12r1 /usr/lib/python2.6/site-packages/BlackMagicTicketTweaks-0.12r1-py2.6.egg <BR>EstimationTools 0.4 /usr/lib/python2.6/site-packages/EstimationTools-0.4-py2.6.egg <BR>MilestoneTeams 0.15 /usr/lib/python2.6/site-packages/MilestoneTeams-0.15-py2.6.egg <BR>TicketCreationStatus 0.1 /usr/lib/python2.6/site-packages/TicketCreationStatus-0.1-py2.6.egg <BR>ticketvalidator.admin N/A /usr/lib/python2.6/site-packages/TicketValidator-0.1-py2.6.egg/ticketvalidator/admin.pyc <BR>ticketvalidator.core N/A /usr/lib/python2.6/site-packages/TicketValidator-0.1-py2.6.egg/ticketvalidator/core.pyc <BR>TracAccountManager 0.3dev /usr/lib/python2.6/site-packages/TracAccountManager-0.3dev-py2.6.egg <BR>TracDateField 1.0.1 /usr/lib/python2.6/site-packages/TracDateField-1.0.1-py2.6.egg <BR>TracMasterTickets 3.0.1 /usr/lib/python2.6/site-packages/TracMasterTickets-3.0.1-py2.6.egg <BR>TracUserManagerPlugin 0.4 /usr/lib/python2.6/site-packages/TracUserManagerPlugin-0.4-py2.6.egg <BR>TypedTicketWorkflow-plugin 0.1dev /usr/lib/python2.6/site-packages/TypedTicketWorkflow_plugin-0.1dev-py2.6.egg

[Dave Morgan]

It appears to be something IN the sql I am running as other reports work fine...both scripted & SQL.

Interestingly I copied & paste the SQL as a new query - saved it, and it generated a DIFFERENT error.....Trac detected an internal error: KeyError: numrows

... I cut & cut & cut.. and still get the error.

Finally I end up with "SELECT * FROM ticket" and it still produces the error! Yet other SQL queries dont?????

[Dave Morgan]

DOH - I saved the query into the description..... I need more coffee.... Ok - so that solved the numrows issue.... but am back to the ID issue...

ok - the problem is this

SELECT t.owner FROM ticket t GROUP BY t.owner with rollup

*GENERATES ERROR*

SELECT * FROM ticket t GROUP BY t.owner with rollup

*DISPLAYS RESULTS*

[Dave Morgan]

Only way I could get this to work was to remove the whole section from blackmagic.py related to "report_view.html"

[anonymous]

I had the exact same problem, and the workaround provided by morgand worked ok. Thanks, morgand.

[PabloS]

Bump! Same problem for me. Interestingly, I don't have to have any blackmagic tweaks in place for this to generate an error. Simply enabling the plugin breaks the report page.

[Ryan J Ollos]

This plugin is deprecated in Trac 1.4 and later. See migration tips on BlackMagicTicketTweaksPlugin page.