• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

SQL error on upgrade

#1
This may or may not be xenforo related, i'm quite new to all of this.
When upgrading xenforo 2 to a newer version (Beta 2/3)
i get the following error:

An exception occurred: [XF\Db\Exception] MySQL statement prepare error [2006]: MySQL server has gone away in /var/www/html/src/XF/Db/AbstractStatement.php on line 183

XF\Db\AbstractStatement->getException() in /var/www/html/src/XF/Db/Mysqli/Statement.php at line 34
XF\Db\Mysqli\Statement->prepare() in /var/www/html/src/XF/Db/Mysqli/Statement.php at line 44
XF\Db\Mysqli\Statement->execute() in /var/www/html/src/XF/Db/AbstractAdapter.php at line 67
XF\Db\AbstractAdapter->query() in /var/www/html/src/XF/Session/DbStorage.php at line 57
XF\Session\DbStorage->writeSession() in /var/www/html/src/XF/Session/Session.php at line 215
XF\Session\Session->save() in /var/www/html/src/XF/Install/App.php at line 140
XF\Install\App->complete() in /var/www/html/src/XF/App.php at line 1790
XF\App->run() in /var/www/html/src/XF.php at line 326
XF::runApp() in /var/www/html/install/index.php at line 14

restarting the web server and then running /install again fixes the issue

i'm hosting from digitalocean using their "one click apps" LAMP
 

Chris D

XenForo developer
Staff member
#2
This isn't something that has been reported specifically for the XF2 installation by others and generally such an error is mostly down to the MySQL server configuration.

The error is usually caused by the following values being exceeded

wait_timeout
max_allowed_packet

If you are still getting the issue, try again after increasing those values (usually in my.cnf but your host might have specific advice).