MySQL error

[sahostking]

Hi

 

Getting this error:

 

Fatal error: Uncaught exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[HY000]: General error: 2006 MySQL server has gone away (SQL: select * from `tblemailtemplates` where `id` = 1 limit 1) (SQL: select * from `tblemailtemplates` where `id` = 1 limit 1)' in /home/domain/public_html/my/includes/classes/WHMCS/Terminus.php:0 Stack trace: #0 /home/domain/public_html/my/includes/classes/WHMCS/Terminus.php(0): WHMCS\Terminus::whmcsExceptionHandler() #1 [internal function]: WHMCS\Terminus->whmcsExceptionHandler(Object(Illuminate\Database\QueryException)) #2 {main} thrown in /home/domain/public_html/my/includes/classes/WHMCS/Terminus.php on line 0

 

We have increased wait_timeout to 600 from 60s and mysql_allowed_packet is set to 256MB already.

 

Any ideas?

[sentq]

when or in what page do you get this error?

[ghh]

I'm getting the same error every time I try to search for a domain (domainchecker.php) even using the default unmodified WHMCS six theme. Everything freezes up for a minute then this error is returned.

 

I don't know if its related but if I look up google.com the System Activity Log shows a lookup against every google.XXX TLD in the database which is not what wanted and could maybe why the query is timing out? (assuming that's what this error actually means)

[ghh]

Actually I've solved my own issue.

The Domain Lookup in the General Settings in WHMCS had every TLD selected which was probably timing out the system. I unselected them all and the results are returned super fast now.

[sentq]

I saw the same error message many times in different installations, something isn't completely correct!