MYSQL Issues

[Shawn Hall]

Can someone give me some pointers on how to fix this error? It shows up on the front end often, but I am also having issues once I get into the admin panel. I have already tried modifying the my.cnf SQL settings which allows the site to come up, but it's EXTREMELY SLOW...

MYSQL ERROR
Error: MySQL server has gone away
Query: SELECT `Code`, IF(`Code` = "en", 1, 0) AS `Order`,`Key`,`Direction`,`Date_format`,`Status` FROM `fl_languages` WHERE (`Status` = 'active') ORDER BY `Order` DESC
Function: getAll
Class: rlDb
File: /home/plentylt/public_html/includes/classes/rlDb.class.php (line# 318)

Any help would be appreciated. Running 4.1. Thanks!

[Steffen Buschkemper]

Hello Shawn,

Just as it looks, you have timeout problems with your connection to the database.
The problem can contain multiple scenarios. Please read about it here - Link

Best regards
Steffen

[Shawn Hall]

Thanks Steffen. I have other sites using PHP/MySQL that are working fine, perhaps there are PHP settings I need to modify or I should attempt to upgrade PHP? I'm on 5.3.22.

My PHP Info

[Steffen Buschkemper]

check the mysql.connect_timeout in your php.ini.
Your value is 60
For test you can use 120.
Whether it helps something or the problem lies somewhere else i can not say...

Best regards
Steffen

[Steffen Buschkemper]

I still have a presumption.
Install the IP Geolocation Database Plugin (ipgeo).
Then test again.

[Shawn Hall]

I got busy and just got back to this...

Thanks again Steffen, installing the ipgeo plugin worked! The site loads and is now 1,000x faster.