Opened 12 years ago

Closed 10 years ago

Last modified 10 years ago

#770 closed defect (worksforme)

reports broken for 0.10: $NEW not defined

Reported by: fux@… Owned by: Russ Tyndall
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 12 years ago by Russ Tyndall

Resolution: worksforme
Status: newclosed

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 10 years ago by anonymous

Resolution: worksforme
Status: closedreopened

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 10 years ago by anonymous

PS: I've forgot it.

Using SQLite 3.3.8 on Ubuntu.

comment:4 Changed 10 years ago by Russ Tyndall

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 10 years ago by Russ Tyndall

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 10 years ago by anonymous

Resolution: worksforme
Status: reopenedclosed

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 10 years ago by Russ Tyndall

Glad this worked out for you



Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain Russ Tyndall.
The resolution will be deleted.

Add Comment

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

Note: See TracTickets for help on using tickets.