Modify

Opened 4 years ago

Last modified 2 years ago

#8009 new defect

Running a report generates error

Reported by: morgand@… Owned by: obs
Priority: normal Component: BlackMagicTicketTweaksPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.12

Description

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

Attachments (0)

Change History (8)

comment:1 Changed 4 years ago by 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

comment:2 Changed 4 years ago by morgand@…

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

comment:3 Changed 4 years ago by morgand@…

<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

comment:4 Changed 4 years ago by morgand

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?????

comment:5 Changed 4 years ago by morgand

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*

comment:6 Changed 4 years ago by morgand

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

comment:7 Changed 3 years ago by anonymous

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

comment:8 Changed 3 years ago by 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.

Add Comment

Modify Ticket

Action
as new .
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.