problem with comppermine database problem with comppermine database
 

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]

Main Menu

problem with comppermine database

Started by Oracle9, November 05, 2007, 12:45:25 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Oracle9

Hello
I use cpg1.4 since  6 months without any problems but only within the last week I start get heavy traffic and almost every 24 hours   I got a fatal error from the database :
SQL query:   
SELECT USER( ) ;
MySQL said: 
#1226 - User 'ADMIN_NAME' has exceeded the 'max_questions' resource (current value: 50000)


Only today I called my hosting provider to ask about this error (though it was from their sql server )
his respond was :
The reason you are receiving this error is due to the max_questions setting which is set to 50,000 per user, per hour.
This setting is in place to ensure that the MySQL database cannot be overloaded with to many query requests.
The queries will reset every hour and is kept by user; however every time the pages on your site are accessed you are still attempting to make queries to the database server. Because of this, even though you are getting errors your script is still accumulating the queries.
As a temporary fix for this issue you can delete and recreate your user, however, this error will still come back if you do not condense the amount of queries your script uses by optimizing your SQL usage.


Any help from which php file I could start check codes to find where is the problem ?
best Regards

Joachim Müller

Post a link to your gallery for a start.