Userlist Timeout

[cassie396]

I know that I have about 130 users at my gallery. The other day I wanted to make a friend of mine an admin, but when I went to load the userlist, it timed out. This is common on my host with batch add and such, but usually something comes up and then I just refresh until the entire list is loaded. But nothing loads in the userlist.

I get:
Fatal error: Maximum execution time of 30 seconds exceeded in E:\home\Default\guidinglightmultimedia.com\htdocs\gallery\include\functions.inc.php on line 79

I tried to change her to an admin through myphpadmin, but it wouldn't take, and I'm not surprised since I'm not good with databases, I don't really know what I'm doing.

Is there something I can do to get this list to load?

Thanks!
Cassie

[cassie396]

Is there anyone who can help me with this problem?

~Cassie

[artistsinhawaii]

You could contact your webhost and ask if they can increase your Maximum execution time. (somewhat doubtful, but I've seen it happen.)

OR, you could edit your database with a tool like phpMYadmin browse your User table and change the user_group status of your friend from (2) registered to (1) administrator.

Dennis

[cassie396]

I've tried changing it manually through PHPMYADMIN, but after I edit the record and submit, I get a page filled with garble database-y looking stuff and the changes don't take!

Any suggestions on this one?

And is there anyway to edit the code so that it will only bring a few users up at a time in pages?

[artistsinhawaii]

I've tried changing it manually through PHPMYADMIN, but after I edit the record and submit, I get a page filled with garble database-y looking stuff and the changes don't take!
Any suggestions on this one?

Hmm... not a good sign.  In phpMYadmin, there should be a repair database option. Try running that first and see if that helps.  Maybe you have a corrupted table somewhere.

Dennis

[Joachim Müller]

you changed what in phpMyAdmin?

[cassie396]

I changed the user level from 2 to 1.

I'm scared to run the repair table because I don't have a backup and my host is a butthead about that kind of stuff.

[artistsinhawaii]

cassie,

just go over the steps in the link that gaugau provided you back in July.

http://coppermine.sourceforge.net/faq.php#BackupDatabase

you should always have a current backup of your database.

Dennis

[cassie396]

I've tried this several times, but my host always times out. And its not a huge database, like 12MB or so.

I was wondering now if I update to 1.4.3 if that might fix the userlist problem?

Thanks!
Cassie

[Joachim Müller]

when running into timeouts, use mySqlDumper