id,summary,reporter,owner,description,type,status,priority,component,severity,resolution,keywords,cc,release 3143,"All Billing Reports fail with ""Report execution failed: ORDER BY column number 0 out of range - should be between 1 and 7""",petros@…,Russ Tyndall," - Trac 0.11rc1 sqlite3 - Just upgraded from 0.10.4 (never used TimingAndEstimationPlugin before) - WorkLogPlugin and TimingAndEstimationPlugin are the only plugins - Ticket/Hour Reports work fine - Other reports work fine Edit report shows me this: {{{ SELECT author as __group__,__style__, ticket, summary, newvalue as Work_added, time as datetime, _ord FROM( SELECT '' as __style__, author, t.id as ticket, t.summary as summary, CASE WHEN newvalue = '' OR newvalue IS NULL THEN 0 ELSE CAST( newvalue AS DECIMAL ) END as newvalue, ticket_change.time as time, 0 as _ord FROM ticket_change JOIN ticket t on t.id = ticket_change.ticket LEFT JOIN ticket_custom as billable on billable.ticket = t.id and billable.name = 'billable' WHERE field = 'hours' and t.status IN ($ASSIGNED, $CLOSED, $NEW, $REOPENED) AND billable.value in ($BILLABLE, $UNBILLABLE) AND ticket_change.time >= $STARTDATE AND ticket_change.time < $ENDDATE UNION SELECT 'background-color:#DFE;' as __style__, author, NULL as ticket, Null as summary, SUM( CASE WHEN newvalue = '' OR newvalue IS NULL THEN 0 ELSE CAST( newvalue AS DECIMAL ) END) as newvalue, NULL as time, 1 as _ord FROM ticket_change JOIN ticket t on t.id = ticket_change.ticket LEFT JOIN ticket_custom as billable on billable.ticket = t.id and billable.name = 'billable' WHERE field = 'hours' and t.status IN ($ASSIGNED, $CLOSED, $NEW, $REOPENED) AND billable.value in ($BILLABLE, $UNBILLABLE) AND ticket_change.time >= $STARTDATE AND ticket_change.time < $ENDDATE GROUP By author ) as tbl ORDER BY author, _ord ASC, time }}} ''Thanks for your work'' ",defect,closed,normal,TimingAndEstimationPlugin,normal,duplicate,"report, 0.11,upgrade,sqlite3",,0.11