Modify

Opened 7 years ago

Closed 7 years ago

Last modified 7 years ago

#3022 closed defect (invalid)

Error Billing Reports

Reported by: anonymous Owned by: bobbysmith007
Priority: normal Component: TimingAndEstimationPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.11

Description

getting the following error when clicking on any of the Billing Reports on the Management page:

Report execution failed: ORDER BY column number 0 out of range - should be between 1 and 7

Using

Trac: 0.11rc1 Python: 2.5.2 (r252:60911, Apr 21 2008, 11:29:43) [GCC 4.2.3 (Ubuntu 4.2.3-2ubuntu7)] setuptools: 0.6c8 SQLite: 3.4.2 pysqlite: 2.4.0 Genshi: 0.5dev-r851 mod_python: 3.3.1 jQuery: 1.2.3

Any ideas?

Thanks!

Attachments (0)

Change History (5)

comment:1 follow-up: Changed 7 years ago by bobbysmith007

I am not sure having never seen that error, but try editing the report and changing the order by statement in the Ticket Work Summary report from:

ORDER BY __ticket__, _ord ASC, time ASC

to

ORDER BY __group__, _ord ASC, time ASC

and let me know if that fixes it. There may have been a change in how column aliasing is resolved in the order by (but I would sor of doubt it). If it doesnt work, just change it back so that this will not be the source of future errors.

comment:2 in reply to: ↑ 1 Changed 7 years ago by anonymous

Replying to bobbysmith007:

Thanks for the fast reply! But unfortunately that didn't help me. I tried the suggested changes to the report (of course with a backup copy), still the same error message. Also skipping the ORDER BY clause didn't change anything. I use custom workflows and other plugins in my trac project so I set up a new and clean trac project to rule out that the error comes from my own workflows and other plugins. But the error is the same there.

comment:3 Changed 7 years ago by bobbysmith007

It still gives you an error about the order-by column even when the order by clause is entirely removed! That is strange indeed.

I replicated the error on my end by upgrading trac, genshi and tande to the head revisions. Trying to figure it out now

comment:4 Changed 7 years ago by bobbysmith007

  • Resolution set to invalid
  • Status changed from new to closed

I finally tracked down what was going on. It seems the group column that trac reports use to group the results is broken in the trac head at the moment.

This is a bug in Trac11rc1 see: http://trac.edgewall.org/ticket/7179

Hopefully it will be fixed soon. There is a patch for this on the ticket if you are the adventurous type.

Thanks for the good bug report and excellent feedback,

Russ

comment:5 Changed 7 years ago by bobbysmith007

This seems to be fixed in the head of http://svn.edgewall.com/repos/trac/branches/0.11-stable/

Add Comment

Modify Ticket

Action
as closed The owner will remain bobbysmith007.
The resolution will be deleted. Next status will be 'reopened'.
Author


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

 
Note: See TracTickets for help on using tickets.