Lost connection to MySQL server

[Corentin]

Hello guys,

 

I'm trying to install WHMCS since this morning but I lose the connection to my database (OVH) every time.

 

Here some of the errors I got:

 

SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query (SQL: select * from `tblproducts` where `downloads` != and `downloads` != N;)

 

SQLSTATE[HY000]: General error: 2006 MySQL server has gone away (SQL: select count(*) as aggregate from `tblconfiguration` where `setting` = Version)

 

SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query (SQL: select column_name from information_schema.columns where table_schema = africatihost and table_name = tblproducts)

 

 

Any advices?

 

Thank you in advance.

[Corentin]

Problem solved.

[Corentin]

But now my sql server is going away (and I don't how to get it back).

So I tried to upgrade but when I try to go to /admin it ask me to update my license so I did it 15 times and it's still asking so I guess Ihave to reinstall?

[brian!]

https://forum.whmcs.com/showthread.php?116698-Server-has-gone-Away&p=471622#post471622

 

This error means that your MySQL Server is closing the connection WHMCS is using. This is usually due to the timeout value being set too low to allow all the tasks to be completed.

You'd need to work with your server admin/hosting provider to increase the wait_timeout and perhaps also the max_allowed_packet values in the MySQL Configuration. Other values that might be causing this are the connectiontimeout in Apache or connTimeout in Litespeed.

[Rogger007]

It seems to be server end issue , you need to cross check server settings of mysql. you can check issue in mysql log file

 

/var/log/mysql/mysql.log or /var/lib/mysql/server.hostname.err for whm server