Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: 1 [2]   Go Down

Author Topic: (1.4.1) Virtual album - image count 0 when displayable images  (Read 16619 times)

0 Members and 1 Guest are viewing this topic.

Nibbler

  • Guest
Re: (1.4.1) Virtual album - image count 0 when displayable images
« Reply #20 on: September 04, 2005, 02:27:28 am »

Code: [Select]
    $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.

Logged

P4ul

  • Coppermine newbie
  • Offline Offline
  • Posts: 7
Re: (1.4.1) Virtual album - image count 0 when displayable images
« Reply #21 on: September 04, 2005, 02:49:25 am »

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
Logged

Tranz

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Female
  • Posts: 6149
Re: (1.4.1) Virtual album - image count 0 when displayable images
« Reply #22 on: September 04, 2005, 02:57:21 am »

Confirmed fixed. Thanks, Nibbler! :)
Logged

Nibbler

  • Guest
Re: (1.4.1) Virtual album - image count 0 when displayable images
« Reply #23 on: September 04, 2005, 03:08:28 am »

Thanks. Comitted to index.php 1.86
Logged
Pages: 1 [2]   Go Up
 

Page created in 0.015 seconds with 19 queries.