Ticket reports don't show any results

[smith]

This looks like a problem with the select statements which look out for fields that don't exist in the design of the db for the piAccess Trac.

[lm]

Caused by lack of 'priority' values in this trac instance. Fixed by modifying queries to use 'severity' instead.

[smith]

Fixed {8} and verified the rest. I think that we'd need the poster to verify these tickets before we close them.

[smith]

Also {9} and {1}

Apparently if you order tickets by severity 'minor' comes after 'major' but before 'normal'.

[lm]

Alphabetically, yes. You should order severity by value.

[smith]

d'ohh!!