MySQL Server Gone Away Errors

Problem

You see the following error:

MySQL server has gone away

Cause

This error indicates that the MySQL® server is closing the connection that WHMCS is using for the current task.

You may see this when upgrading WHMCS due to the large number of MySQL queries that upgrading performs. In most cases, this occurs because the timeout value is too low to allow all the upgrade tasks to finish.

Solution

To resolve this, work with your system administrator or hosting provider to increase the wait_timeout and max_allowed_packet values in the MySQL configuration.

If you were performing an upgrade, make certain to restore the database backups from before the upgrade before running the upgrade script again.

Last modified: September 23, 2024