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]   Go Down

Author Topic: All users not showing  (Read 2647 times)

0 Members and 1 Guest are viewing this topic.

UK10

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
All users not showing
« on: August 20, 2006, 07:44:10 pm »

Since recently not all user are showing on the user galleries page (index.php?cat=1).
I worked out that the error is to do with the following query.
Code: [Select]
SELECT user_id as user_id,user_name as user_name,COUNT(DISTINCT a.aid) as alb_count,COUNT(DISTINCT pid) as pic_count,MAX(pid) as thumb_pid, MAX(galleryicon) as gallery_pid FROM cpg135_albums AS a INNER JOIN `dpspot_fotoupg`.cpg135_users as u on u.user_id = a.category - 10000 INNER JOIN cpg135_pictures AS p ON p.aid = a.aid WHERE ((isnull(approved) or approved='YES') AND category > 10000)  GROUP BY category ORDER BY category LIMIT 0, 9
Also I tried changing the LIMIT 0,9 to LIMIT 0,500 in phpMyAdmin and then it does show the results that I am looking for.

Link is http://www.dutchplanespotters.nl/_dev/cpg143/index.php

Can anyone help to fix this problem?
Logged

Nibbler

  • Guest
Logged
Pages: [1]   Go Up
 

Page created in 0.02 seconds with 20 queries.