Ticket #84 (new defect)

Opened 2 years ago

Last modified 2 years ago

SQL error with Postgres (caused by cset:b4a1ba99f734)

Reported by: scsibug Owned by:
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 2 years ago.

Change History

Note: See TracTickets for help on using tickets.