(1.4.1) Virtual album - image count 0 when displayable images

[Nibbler]

Code Select Expand

    $sql = "SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword" .
            " FROM {$CONFIG['TABLE_ALBUMS']} AS a " .
            " LEFT JOIN {$CONFIG['TABLE_PICTURES']} AS p ON a.aid = p.aid AND p.approved =  'YES' ".
            "WHERE a.aid IN $album_set" . "GROUP BY p.aid";

Change that GROUP BY to a.aid instead of p.aid in both places that use the code.

[P4ul]

You're the man 

Fixed it for me, i can move my virtual album anywhere in the tree and the linked count is correct , many thanks

that was index.php for anyone who needs the fix

[Tranz]

Confirmed fixed. Thanks, Nibbler!

[Nibbler]

Thanks. Comitted to index.php 1.86