Reports Not Working (No Handler Matched)

[oliver.thylmann@…]

Installation of the plugin went fine. Upgrade went through without errors. The time fields in the tasks are there. The Management menu item is there.

The thing that doesn't work is the reports. I get an error like this:

No handler matched request to /report/9

Here is the url: ​http://trac.somewhere/report/9?BILLABLE=1&UNBILLABLE=1&NEW=new&ASSIGNED=assigned&REOPENED=reopened&CLOSED=closed&STARTDATE=0&ENDDATE=2000000000

The install was done with: clearsilver-0.10.3-3.fc4 python-clearsilver-0.10.3-3.fc4 trac 0.10

To make sure that it's not a trac problem, I then upgraded trac to 0.10.4 this morning and upgraded again (only the trac upgrade obviously) and it is still not working.

If you need further information please tell me.

[Russ Tyndall]

Do you have the WebAdmin Plugin Installed?

• If so can you please ensure that all components are enabled
• if not check your trac.ini file for:

  [components]
  timingandestimationplugin.* = enabled
  

if something was not enabled, enable it then re-run

trac-admin [trac-instance] upgrade

If this is not the problem or does not fix it we need to determine which of the following is the case.

• there is a problem with the mapping between the Management Page and the reports
• the reports did not get properly installed.

Also:

• What database backend are your running?
• Do the other trac reports still work ?

Hopefully this will allow us to diagnose and treat the problem,

Russ

[oliver.thylmann@…]

hi,

this already in there:

[components] timingandestimationplugin.* = enabled trac.ticket.report.* = disabled webadmin.* = enabled mastertickets.* = enabled burndown.* = enabled

just so you have all of them.

Database is: trac.db: SQLite database (Version 3)

The other reports still work, the ones under /query you mean I presume. I can also add the fields for estimate and work performed and see those there.

[Russ Tyndall]

The following line should not appear in your components section.

trac.ticket.report.* = disabled

That is turning off reports. If that is disabled due to one of the other plugins that have been installed, I am not sure what to tell you. I have not been notified that this plugin conflicted with others, but it would not be the most surprising thing in the world either.

Hope this gets you running, let me know how it goes.

[Russ Tyndall]

also feel free to reopen if this doesn't solve your problem

[oliver.thylmann@…]

ok cool, that worked. The disabled flag was for disabling the old reports in 0.10 by the way. Does not seem to be needed anymore in 0.10.4 which uses the new reports by default.

The problem is that I still have problems. But we are one step further! :)

now I get this:

Report execution failed: near "as": syntax error

​http://somewhere.com/report/16?BILLABLE=0&UNBILLABLE=0&NEW=new&ASSIGNED=assigned&REOPENED=reopened&CLOSED=&STARTDATE=0&ENDDATE=2000000000

That's with every report. I put in # in front of the line in question and restarted apache just to be sure.

[Russ Tyndall]

see if this helps: #1480 he claims that some versions of sqlite over the required version still have the same problem. and lists some versions that fixed the problem for him.

Hopefully this will help. Please let me know if this fixes it for you.

[oliver.thylmann@…]

We updated to sqlite-3.3.17.so and it's working. Thanks a lot.