Not signed in (Sign In)

Vanilla 1.1.10 is a product of Lussumo. More Information: Documentation, Community Support.

    • CommentAuthoriYummy
    • CommentTimeJan 5th 2006
    With my plogger site, when you order an album by number of comments in descending order and then click on a picture, i get the error

    Unknown column 'num_comments' in 'order clause'

    SELECT id FROM `plogger_pictures` WHERE parent_album = 5 ORDER BY `num_comments` DESC

    I'm sure this is a simple fix just have to join the plogger_comments table to the current query, but thought i let you know