Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: All users not showing  (Read 2589 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.017 seconds with 19 queries.