forum.coppermine-gallery.net

Support => Older/other versions => cpg1.3.x Support => Topic started by: willstein on November 29, 2005, 03:37:18 am

Title: Undefined Index?
Post by: willstein on November 29, 2005, 03:37:18 am
I havent touched it in about a week.
This came up randomly...

any ideas?

Code: [Select]
Notice: Undefined index: debug_mode in /home/stfusaco/public_html/gallery/include/functions.inc.php on line 96
Fatal error :
There was an error while processing a database query

Title: Re: Undefined Index?
Post by: kegobeer on November 29, 2005, 03:51:18 am
What version are you running?
Title: Re: Undefined Index?
Post by: willstein on November 29, 2005, 05:20:25 am
1.3.4
Title: Re: Undefined Index?
Post by: willstein on November 29, 2005, 05:21:11 am
This error also comes up with fetch:

Code: [Select]
User 'stfusaco_photo' has exceeded the 'max_questions' resource (current value: 50000)
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/stfusa/public_html/fetch/cpmfetch_dao.php on line 710
Title: Re: Undefined Index?
Post by: kegobeer on November 29, 2005, 05:25:12 am
Have you made any modifications recently?  Has you host done anything recently?
Title: Re: Undefined Index?
Post by: Nibbler on November 29, 2005, 10:41:35 am
That would be a limit on the number of db queries you are permitted to run per hour set by your host.
Title: Re: Undefined Index?
Post by: willstein on November 29, 2005, 02:27:54 pm
No I did not make any changes recently.

It looks like the site is back up.
50,000 queries/hour seems like a lot.

What are the major query hogs?
I think I read some where that it could be reduced by deleting the "Overall hits" statistic.

Any suggestions to reduce DB queries?
Title: Re: Undefined Index?
Post by: Stramm on December 02, 2005, 06:20:01 am
not really, the stats just need lots of resources (when you have a huge gallery, pics, users, comments). but it's 'only' 3-4 queries per index load

But if you don't need the stats you can remove them