usrmgr.php Hangs up! Why?

[kurt]

I got now ovar 6000 users in my database.
When I click on usermgr.php the script hangs up.

I figured out the this part of the script is to havy for the server:

   # $sql = "SELECT user_id, user_name, UNIX_TIMESTAMP(user_regdate) as user_regdate, UNIX_TIMESTAMP(user_lastvisit) as user_lastvisit, user_active, ".
   #        "COUNT(pid) as pic_count, ROUND(SUM(total_filesize)/1024) as disk_usage, group_name, group_quota ".
   #        "FROM {$CONFIG['TABLE_USERS']} AS u ".
   #        "INNER JOIN {$CONFIG['TABLE_USERGROUPS']} AS g ON user_group = group_id ".
   #        "LEFT JOIN {$CONFIG['TABLE_PICTURES']} AS p ON p.owner_id = u.user_id ".
   #        "GROUP BY user_id ".
   #        "ORDER BY " . $sort_codes[$sort] . " ".
   #        "LIMIT $lower_limit, $user_per_page;";


Any help or update?

[Nibbler]

Can you verify you have an index on user_id on your users table ?

[kurt]

user_id is underlined in phpMyAdin. PRIMERY_KEY is user_id.

Hope that is what you wanted to know.

I have changed user_id from INT(11) to bigint(20). Was that the mistake?

[Nibbler]

I dont know, but seems pretty pointless unless you are expecting more than 2 billion users to sign up for your gallery.

Add an index using

Code Select Expand

ALTER TABLE CPG_pictures ADD INDEX owner_id( `owner_id` );

where CPG_ is your tablename prefix as set on install.

[kurt]

--> ALTER TABLE cpg132_pictures ADD INDEX owner_id( `owner_id` )

SQL Error Message: Allready exists 'owern_id'
I change BIGINT(20) back into to INT(11).

But it still hangsup. I think that maybe the SQL statement is wrong, or the result is to big, or it take too much time for this query, so an server time out comes.

[kurt]

OK !!! EXCELLENT!!!

I create a new Index over the user_id on *_users
and one over *_pictures on ownerid!!!

Now it runs!

VERY GOOD SUPPORT HERE!!! THANKS A LOT!