Ticket #84 (new defect)

Opened 3 months ago

Last modified 3 months ago

SQL error with Postgres (caused by cset:b4a1ba99f734)

Reported by: scsibug Assigned to:
Priority: minor Milestone:
Component: blog Version:
Keywords: blogroll Cc:

Description

It appears that one of the changes merged in recently doesn't work well with postgres. The query in apps/blogroll/templatetags/blogroll_extras.py gives the following SQL error:

column "comment_nodes.upd_date" must appear in the GROUP BY clause or be used in an aggregate function

This breaks any page that shows a blogroll.

A patch is included mainly to show context, it removes the functionality of sorting links by last comment.

Attachments

blogroll_postgres.patch (0.9 kB) - added by scsibug on 06/04/08 05:19:15.

Change History

06/04/08 05:19:15 changed by scsibug

  • attachment blogroll_postgres.patch added.

06/04/08 08:26:51 changed by piranha

  • keywords set to blogroll.

Patch is applied while we're waiting for real fix.

Ohloh project report for byteflow