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
Is there anyone who can help me with this problem?
~Cassie
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
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?
Quote from: cassie396 on November 18, 2005, 08:12:15 PM
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
you changed what in phpMyAdmin?
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.
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
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
when running into timeouts, use mySqlDumper (http://www.mysqldumper.de/en/index.php)