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: Userlist Timeout  (Read 6339 times)

0 Members and 1 Guest are viewing this topic.

cassie396

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Female
  • Posts: 66
Userlist Timeout
« on: November 14, 2005, 05:07:47 am »
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
Logged

cassie396

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Female
  • Posts: 66
Re: Userlist Timeout
« Reply #1 on: November 15, 2005, 09:06:25 pm »
Is there anyone who can help me with this problem?

~Cassie
Logged

artistsinhawaii

  • VIP
  • Coppermine addict
  • ***
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 856
    • evj art and photography
Re: Userlist Timeout
« Reply #2 on: November 15, 2005, 11:38:13 pm »

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
Logged
Learn and live ... In January of 2011, after a botched stent attempt, the doctors told me I needed a multiple bypass surgery or I could die.  I told them I needed new doctors.

cassie396

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Female
  • Posts: 66
Re: Userlist Timeout
« Reply #3 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?

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

artistsinhawaii

  • VIP
  • Coppermine addict
  • ***
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 856
    • evj art and photography
Re: Userlist Timeout
« Reply #4 on: November 18, 2005, 10:03:15 pm »
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

Logged
Learn and live ... In January of 2011, after a botched stent attempt, the doctors told me I needed a multiple bypass surgery or I could die.  I told them I needed new doctors.

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Userlist Timeout
« Reply #5 on: November 18, 2005, 10:50:49 pm »
you changed what in phpMyAdmin?
Logged

cassie396

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Female
  • Posts: 66
Re: Userlist Timeout
« Reply #6 on: November 20, 2005, 02:40:30 am »
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.
Logged

artistsinhawaii

  • VIP
  • Coppermine addict
  • ***
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 856
    • evj art and photography
Re: Userlist Timeout
« Reply #7 on: November 20, 2005, 03:49:45 am »
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
Logged
Learn and live ... In January of 2011, after a botched stent attempt, the doctors told me I needed a multiple bypass surgery or I could die.  I told them I needed new doctors.

cassie396

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Female
  • Posts: 66
Re: Userlist Timeout
« Reply #8 on: January 17, 2006, 06:57:19 am »
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
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Userlist Timeout
« Reply #9 on: January 17, 2006, 09:18:32 am »
when running into timeouts, use mySqlDumper
Logged
Pages: [1]   Go Up
« previous next »
 

Page created in 0.019 seconds with 19 queries.