Opened 10 years ago

Closed 9 years ago

Last modified 9 years ago

#770 closed defect (worksforme)

reports broken for 0.10: $NEW not defined

Reported by: fux@… Owned by: bobbysmith007
Priority: normal Component: TimingAndEstimationPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.10



trac 0.10 and the standard reports don't seem to work together (not even on the demopage):

{12} Ticket Hours
Report execution failed: Dynamic variable '$NEW' not defined.

thx for fixing or pointing me to a solution,



Attachments (0)

Change History (7)

comment:1 Changed 10 years ago by bobbysmith007

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

THe reports are not broken. They use custom variables that are filled from the Billing and Estimation UI that was added. On the demo site this page is :

Please see the User Manual for more info.

Also if you want that page to work you need Javascript enabled (this is how it is building the links from the UI).

comment:2 Changed 9 years ago by anonymous

  • Resolution worksforme deleted
  • Status changed from closed to reopened

Do you mean this:

The reports can only be called from the Management Page. They will not work from the Trac View Tickets page. (Due to the custom variables that need values).

If I call the reports from the Management Page, it shows me another error. Report execution failed: near "AS": syntax error

However no report available.

comment:3 Changed 9 years ago by anonymous

PS: I've forgot it.

Using SQLite 3.3.8 on Ubuntu.

comment:4 Changed 9 years ago by bobbysmith007

Well then this is not really the same problem as this ticket describes, but either way. Please paste in the contents of the report you are trying to run. Also any trac logs you have related to this might be helpful and might also give you the contents of the report you were trying to run when it failed.

Thanks, Russ

comment:5 Changed 9 years ago by bobbysmith007

ps. that error usually comes from not being able to CAST(col as OtherType). This was unsupported in previous versions of sqlite, though I thought that 3.3.8 was well past that revision. You should be able to check this by running a query like "SELECT CAST(1 as text)" in the sqlite command line program.

comment:6 Changed 9 years ago by anonymous

  • Resolution set to worksforme
  • Status changed from reopened to closed

Sorry for reopening the bug.

Just need to rebuild Python SQL binding because they were using an older version of SQLite.

Then upgrade all projects databases.

Sorry again for not posting in the right place. Thanks for your time.

comment:7 Changed 9 years ago by bobbysmith007

Glad this worked out for you



Add Comment

Modify Ticket

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

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

Note: See TracTickets for help on using tickets.