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: [Solved]: I can't view the users anymore after upgrading  (Read 3447 times)

0 Members and 1 Guest are viewing this topic.

Laicodc

  • Coppermine newbie
  • Offline Offline
  • Posts: 17
[Solved]: I can't view the users anymore after upgrading
« on: February 17, 2009, 04:15:38 pm »

I upgraded today from 1.4.10 to 1.4.20 and I just noticed that when I click on the users tab it doesn't work.  I really need to be able to look at the registered users.  Any ideas what to check?
Thanks!
Marc
« Last Edit: February 18, 2009, 09:10:31 pm by Nibbler »
Logged

Laicodc

  • Coppermine newbie
  • Offline Offline
  • Posts: 17
can't view registered users anymore after upgrade
« Reply #1 on: February 17, 2009, 04:46:01 pm »

I upgraded today from 1.4.10 to 1.4.20 and I just noticed that when I click on the users tab it doesn't work.  I really need to be able to look at the registered users.  Any ideas what to check?
Thanks!
Marc
Logged

Laicodc

  • Coppermine newbie
  • Offline Offline
  • Posts: 17
Re: can't view registered users anymore after upgrade
« Reply #2 on: February 17, 2009, 06:16:16 pm »

Everything else is working.  I just can't get usermgr.php to work.   any help is greatly appreciated.  Thanks
Logged

Nibbler

  • Guest
Re: I can't view the users anymore after upgrading
« Reply #3 on: February 17, 2009, 06:46:54 pm »

Maybe if you ask some more that will help...

Post a link to your gallery, exactly what you mean by "doesn't work" and mention how many users you have (roughly). There's also a known problem if you are the sole uploader to the gallery, so mention if that applies to you and I'll dig up the fix.
Logged

Laicodc

  • Coppermine newbie
  • Offline Offline
  • Posts: 17
Re: I can't view the users anymore after upgrading
« Reply #4 on: February 18, 2009, 01:05:14 am »

My gallery url is: http://laicodc.com/gallery

What I mean by doesn't work is that when clicking on the user tab (which points to http://laicodc.com/gallery/usermgr.php)  it hangs for a long time and then comes back with this error:

"Critical error
There was an error while processing a database query"

All the other php files under gallery seem to work fine.  Only the usermgr.php is having problems.   I am the sole uploader to the gallery and I have about 4 or 5 thousand registered users.   

Thanks for your help. 
Logged

Laicodc

  • Coppermine newbie
  • Offline Offline
  • Posts: 17
Re: I can't view the users anymore after upgrading
« Reply #5 on: February 18, 2009, 06:41:29 am »

The script appears to be taking too long to search the database and is getting killed by one of the resource scripts.


[ 1234925881 ] [ laicodc_laicobot ] [ 956503 ] [ 49 ] [ laicodc_photo ] [ Query ] [ KILLED ] [ gator539.hostgator.com ] [ SELECT user_id as user_id, user_name as user_name, user_email as user_email, UNIX_TIMESTAMP(user_reg ]
[ 1234925881 ] [ laicodc_laicobot ] [ 956510 ] [ 44 ] [ laicodc_photo ] [ Query ] [ KILLED ] [ gator539.hostgator.com ] [ UPDATE cpg1410_pictures SET hits=hits+1, lasthit_ip='68.100.147.134', mtime=CURRENT_TIMESTAMP WHERE  ]
[ 1234925881 ] [ laicodc_laicobot ] [ 956514 ] [ 42 ] [ laicodc_photo ] [ Query ] [ KILLED ] [ gator539.hostgator.com ] [ SELECT COUNT(*) from cpg1410_pictures WHERE ((aid='231'  AND aid NOT IN (4) ) ) AND approved='YES' A ]
[ 1234925881 ] [ laicodc_laicobot ] [ 956531 ] [ 35 ] [ laicodc_photo ] [ Query ] [ KILLED ] [ gator539.hostgator.com ] [ SELECT COUNT(*) from cpg1410_pictures WHERE ((aid='229'  AND aid NOT IN (4) ) ) AND approved='YES' A ]
[ 1234925881 ] [ laicodc_laicobot ] [ 956533 ] [ 34 ] [ laicodc_photo ] [ Query ] [ KILLED ] [ gator539.hostgator.com ] [ UPDATE cpg1410_pictures SET hits=hits+1, lasthit_ip='68.100.147.134', mtime=CURRENT_TIMESTAMP WHERE  ]
[ 1234925881 ] [ laicodc_laicobot ] [ 956538 ] [ 32 ] [ laicodc_photo ] [ Query ] [ KILLED ] [ gator539.hostgator.com ] [ SELECT COUNT(*) from cpg1410_pictures WHERE ((aid='231'  AND aid NOT IN (4) ) ) AND approved='YES' A ]
[ 1234925881 ] [ laicodc_laicobot ] [ 956541 ] [ 32 ] [ laicodc_photo ] [ Query ] [ KILLED ] [ gator539.hostgator.com ] [ UPDATE cpg1410_pictures SET hits=hits+1, lasthit_ip='68.100.147.134', mtime=CURRENT_TIMESTAMP WHERE  ]
[ 1234925881 ] [ laicodc_laicobot ] [ 956545 ] [ 30 ] [ laicodc_photo ] [ Query ] [ KILLED ] [ gator539.hostgator.com ] [ SELECT COUNT(*) from cpg1410_pictures WHERE ((aid='229'  AND aid NOT IN (4) ) ) AND approved='YES' A ]
[ 1234925881 ] [ laicodc_laicobot ] [ 956564 ] [ 18 ] [ laicodc_photo ] [ Query ] [ KILLED ] [ gator539.hostgator.com ] [ SELECT COUNT(*) from cpg1410_pictures WHERE ((aid='229'  AND aid NOT IN (4) ) ) AND approved='YES' A ]


I did go ahead and run optimize table on the database tables but this hasn't helped. Is there something that can be done to speed up the mysql queries? 
Logged

Laicodc

  • Coppermine newbie
  • Offline Offline
  • Posts: 17
Re: I can't view the users anymore after upgrading
« Reply #6 on: February 18, 2009, 09:54:49 am »

Here is the code from debug:
Logged

Nibbler

  • Guest
Logged

Laicodc

  • Coppermine newbie
  • Offline Offline
  • Posts: 17
Re: I can't view the users anymore after upgrading
« Reply #8 on: February 18, 2009, 08:41:03 pm »

Thanks Nibbler,  I read that thread and see that you found a fix where you force the index in udb_base.inc.php.  Can you take a look at mine and see if that will work for me?  or can you tell me where to change the code so I can try it?   I can pm you my login info and anything else you need.  I really appreciate your help.  If you're ever in DC you get a Table and $300 bar tab on me!
Logged

Nibbler

  • Guest
Re: I can't view the users anymore after upgrading
« Reply #9 on: February 18, 2009, 08:54:01 pm »

Find

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 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']};";

Change to

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

Laicodc

  • Coppermine newbie
  • Offline Offline
  • Posts: 17
Re: I can't view the users anymore after upgrading
« Reply #10 on: February 18, 2009, 08:58:22 pm »

oh, ok, which file?  usermgr.php or that other file udb_base.inc.php

Logged

Nibbler

  • Guest
Re: I can't view the users anymore after upgrading
« Reply #11 on: February 18, 2009, 09:03:42 pm »

udb_base.inc.php
Logged

Laicodc

  • Coppermine newbie
  • Offline Offline
  • Posts: 17
Re: I can't view the users anymore after upgrading
« Reply #12 on: February 18, 2009, 09:06:20 pm »

I did it.  THANK YOU SO MUCH
Logged
Pages: [1]   Go Up
 

Page created in 0.019 seconds with 19 queries.