Jump to content
KAYSIANA

[TEP STOP]

Recommended Posts

when I go to my admin page I get the following at the bottom of the screen

2006 - MySQL server has gone away

select r.reviews_id, r.date_added, pd.products_name, r.customers_name, r.reviews_rating, r.reviews_status from reviews r, products_description pd where pd.products_id = r.products_id and pd.language_id = '1' order by r.date_added desc limit 6

[TEP STOP]


2006 - MySQL server has gone away

select 1 from sessions where sesskey = 'dgek7k191r04v4bcnfdarmihu3'

[TEP STOP]

Can someone please tell me what this means and how to remove it?

Share this post


Link to post
Share on other sites

That is either due to the maximum number of connections requests being made to your database or the sessions table is corrupted. If you wait a few minutes, refresh the page and it fails the same way, it is probably the table. In that case you can run a repair on it in phpmyadmin in your accounts control panel. You may want to try this first in either case since it is the easiest fix.

If the page reloads after a while, then it is probably due to too many connections. Your host can raise that setting but if it is a shared server the may not do that. But if they tell you you need to upgrade to a VPS or Dedicated server, don't believe them since that is almost never needed. What you need to do is review your access log and block IP's that are hitting the site too much. The easy way to do this is by installing View Counter but you can also load the raw access log from your account into a spreadsheet program. The latter will not be as easy but you can figure out the heavy hitters with it. Once found, those should be blocked.

 

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×