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

Author Topic: user manager times out...  (Read 21180 times)

0 Members and 1 Guest are viewing this topic.

drummerkid08

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 32
user manager times out...
« on: February 06, 2006, 09:36:04 pm »

everything in my gallery seems to work fine.  however when i click on "users" in the admin panel, it always times out.  is there something i can do to fix this?

this is my site:  www.shineon-media.com/gallery
and if you need to login, here's a temp username: drummerkid08   password: sturunnr
« Last Edit: February 15, 2006, 06:26:13 am by Abbas Ali »
Logged

Nibbler

  • Guest
Re: user manager times out...
« Reply #1 on: February 06, 2006, 09:41:03 pm »

You don't allow users to view the memberlist, so there is nothing for us to see at your site. How many users do you have ?
Logged

drummerkid08

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 32
Re: user manager times out...
« Reply #2 on: February 06, 2006, 09:54:56 pm »

okay, i've changed it so you can view the memberlist.  i'm not sure how many users i have, which is why i wanted to check the user manager.
Logged

drummerkid08

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 32
Re: user manager times out...
« Reply #3 on: February 11, 2006, 05:20:24 am »

does it time out because i have too many users registered?? i need to add some people but it still times out.  is there a way to get to that page a different way?
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: user manager times out...
« Reply #4 on: February 11, 2006, 11:08:13 am »

Logged

Abbas Ali

  • Administrator
  • Coppermine addict
  • *****
  • Country: in
  • Offline Offline
  • Gender: Male
  • Posts: 2165
  • Spread the PHP Web
    • Ranium Systems
Re: user manager times out...
« Reply #5 on: February 11, 2006, 11:58:04 am »

i'm not sure how many users i have, which is why i wanted to check the user manager.
Logged
Chief Geek at Ranium Systems

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: user manager times out...
« Reply #6 on: February 11, 2006, 12:34:09 pm »

phpMyAdmin?
Logged

Abbas Ali

  • Administrator
  • Coppermine addict
  • *****
  • Country: in
  • Offline Offline
  • Gender: Male
  • Posts: 2165
  • Spread the PHP Web
    • Ranium Systems
Re: user manager times out...
« Reply #7 on: February 11, 2006, 12:59:45 pm »

I guess drummerkid08 doesn't know phpMyAdmin....

@drummerkid08: If you know phpMyAdmin or any other database management tool then browse your database and see how many records are there in cpg_users table (cpg_ should be replaced by prefix you have used).
Logged
Chief Geek at Ranium Systems

drummerkid08

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 32
Re: user manager times out...
« Reply #8 on: February 11, 2006, 05:52:11 pm »

it says 1,675
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: user manager times out...
« Reply #9 on: February 11, 2006, 07:17:27 pm »

uhmm, I dunno.. but what for is
Code: [Select]
'' as user_active, in the SQL in function get_users
Code: [Select]
SELECT {$f['user_id']} as user_id, {$f['username']} as user_name, {$f['email']} as user_email, {$f['regdate']} as user_regdate, lastvisit as user_lastvisit, '' as user_active,

drummerkid08

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 32
Re: user manager times out...
« Reply #10 on: February 11, 2006, 07:26:01 pm »

i'm not quite sure....is it not supposed to be there?
Logged

drummerkid08

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 32
Re: user manager times out...
« Reply #11 on: February 12, 2006, 08:57:37 pm »

uhmm, I dunno.. but what for is
Code: [Select]
'' as user_active, in the SQL in function get_users
Code: [Select]
SELECT {$f['user_id']} as user_id, {$f['username']} as user_name, {$f['email']} as user_email, {$f['regdate']} as user_regdate, lastvisit as user_lastvisit, '' as user_active,


where exactly would i find that code.
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: user manager times out...
« Reply #12 on: February 13, 2006, 08:12:54 am »

that was a question to the other devs... but you can find it in bridge/mybb.inc.php

drummerkid08

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 32
Re: user manager times out...
« Reply #13 on: February 14, 2006, 05:26:34 am »

oh, okay.  so is there anything i can do?
Logged

Nibbler

  • Guest
Re: user manager times out...
« Reply #14 on: February 14, 2006, 02:27:12 pm »

If you are happy to PM me FTP and db access to your gallery then I can take a look for you.

Stramm, if you wish to discuss unrelated coding issues please do so on the dev or coding boards.
Logged

drummerkid08

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 32
Re: user manager times out...
« Reply #15 on: February 14, 2006, 07:48:29 pm »

okay. i pm'ed you.  thanks :)
Logged

Nibbler

  • Guest
Re: user manager times out...
« Reply #16 on: February 14, 2006, 09:46:25 pm »

It's the main query that's the problem here:

Code: [Select]
SELECT user_id AS user_id, user_name AS user_name, user_email AS user_email, UNIX_TIMESTAMP( user_regdate ) AS user_regdate, UNIX_TIMESTAMP( user_lastvisit ) AS user_lastvisit, user_active AS user_active, COUNT( pid ) AS pic_count, ROUND( SUM( total_filesize ) /1024 ) AS disk_usage, group_name, group_quota
FROM `shineon_copp1`.cpg143_users AS u
INNER JOIN cpg143_usergroups AS g ON u.user_group = g.group_id
LEFT JOIN cpg143_pictures AS p ON p.owner_id = u.user_id
GROUP BY user_id
ORDER BY user_regdate DESC
LIMIT 0 , 25

It takes several minutes to run due to the fact that it's not using any keys in the joins (see pic). All the keys are there that should be according to the schema.

I don't know what to suggest to solve this other than to get your mysql updated to the latest stable version. Maybe another supporter will come along and suggest something.
Logged

drummerkid08

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 32
Re: user manager times out...
« Reply #17 on: February 14, 2006, 10:43:35 pm »

hmmm...okay.  thanks for trying.  i don't know if i can update my mysql...i think my webhost has to do that...what's the newest version, because right now i have 4.1.14-standard.
Logged

Nibbler

  • Guest
Re: user manager times out...
« Reply #18 on: February 14, 2006, 11:52:48 pm »

I fixed it :D

Solution was to force the index in udb_base.inc.php

Code: [Select]
// Build SQL table, should work with all bridges
        $sql = "SELECT {$f['user_id']} as user_id, {$f['username']} as user_name, {$f['email']} as user_email, {$f['regdate']} as user_regdate, {$f['lastvisit']} as user_lastvisit, {$f['active']} as user_active, ".
               "COUNT(pid) as pic_count, ROUND(SUM(total_filesize)/1024) as disk_usage, group_name, group_quota ".
               "FROM {$this->usertable} AS u ".
               "INNER JOIN {$C['TABLE_USERGROUPS']} AS g ON u.{$f['usertbl_group_id']} = g.group_id ".
               "LEFT JOIN {$C['TABLE_PICTURES']} AS p FORCE INDEX ( owner_id ) ON p.owner_id = u.{$f['user_id']} ".
               $options['search'].
               "GROUP BY user_id " . "ORDER BY " . $sort_codes[$options['sort']] . " ".
               "LIMIT {$options['lower_limit']}, {$options['users_per_page']};";
Logged

drummerkid08

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 32
Re: user manager times out...
« Reply #19 on: February 15, 2006, 05:20:35 am »

OMFG!!! Thank you sooooo much Nibbler, you're a lifesaver.  I really appreciate all your help.
Logged
Pages: [1] 2   Go Up
 

Page created in 0.027 seconds with 19 queries.