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 The owner will remain obs.
Author


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

 
Note: See TracTickets for help on using tickets.