Ticket #37 (closed defect: fixed)

Opened 9 months ago

Last modified 9 months ago

Subversion and/or Trac problems with site...dB related?

Reported by: ericjarvies Owned by: saurik
Priority: minor Component: General
Keywords: Subversion, Trac, Wiki, Website Cc:

Description

home > View Tickets > All Tickets By Milestone (Including closed) is erring with the following message:

Report execution failed: ERROR: column "modified" does not exist at character 619

Change History

Changed 9 months ago by ericjarvies

  • summary changed from Subversion and/or Trac problems with site... to Subversion and/or Trac problems with site...dB related?

actually, this is likely a dB problem.

If this site is using PostgreSQL, PostgreSQL does not use aliases in ORDER BY.

ORDER BY

look into changing 'modified' to 'changetime' cast p.value to int

Changed 9 months ago by saurik

  • status changed from new to closed
  • resolution set to fixed

Done (with a slight modification on the p.value stuff), and I added ericjarvies as an admin to Trac.

Note: See TracTickets for help on using tickets.