coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: eka on January 31, 2008, 01:08:37 PM

Title: Fatal error - please help
Post by: eka on January 31, 2008, 01:08:37 PM
Hi,

I've got this message, only 2 words:  "fatal error" when I tried to click on a coppermine-page link on my website, www. photograffs.com.  I can access my index (html) page, www.photograffs.com/index.htm but when I tried to click a link to a coppermine page, a blank page appears with the words "fatal error" and nothing else.

I've tried to check on my database using phpMyAdmin, but there is this message:

"Error
SQL query: 

SELECT USER( ) ;

MySQL said: 

#1226 - User 'photogr1_wfs' has exceeded the 'max_questions' resource (current value: 50000) "


The left column of the page usually says "No database" - there is nothing there (no table names, etc.).

What this problem is, is really beyond me.

I would really appreciate it if somebody can explain and perhaps suggest how I can proceed to get it resolved.

Thanks.







Title: Re: Fatal error - please help
Post by: Nibbler on January 31, 2008, 01:15:17 PM
Your host has limited you to 50000 database queries per hour. When you hit the limit you get the message.
Title: Re: Fatal error - please help
Post by: eka on January 31, 2008, 03:07:39 PM
Thank you Nibbler for the explanation.

I'm just wondering whether it is possible to have 50,000 database queries per hour for my website since I don't really have many visitors, and the website is practically for my own personal use.  I access the website everyday but just a few clicks to see the photos.

Is 50,000 database queries per hour high by any standard ?

What could jack up the database queries - visits by robots ?

Title: Re: Fatal error - please help
Post by: Joachim Müller on February 01, 2008, 08:27:01 PM
Quote from: eka on January 31, 2008, 03:07:39 PM
What could jack up the database queries - visits by robots ?
Several queries are performed on each page, no matter if it a human (you) or a spider (search engine crawler) - this is how mysql-driven apps like coppermine work. So yes, this could be caused by search engine crawlers.

Quote from: eka on January 31, 2008, 03:07:39 PMIs 50,000 database queries per hour high by any standard ?
Not a standard, but a limitation deliberately imposed by your webhost. Probably written down in the fine print of your webhosting contract.