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

XF 1.3 MySQL errors during installation

AlM

New member
#1
Hello, I've tried to install XenForo 1.3.0 and got these messages:

Server Error
Mysqli prepare error: MySQL server has gone away

  1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
  2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
  3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
  4. Zend_Db_Adapter_Abstract->query() in XenForo/Model/Deferred.php at line 111
  5. XenForo_Model_Deferred->defer() in XenForo/Application.php at line 1367
  6. XenForo_Application::defer() in XenForo/Model/Deferred.php at line 272
  7. XenForo_Model_Deferred->runDeferred() in XenForo/Model/Deferred.php at line 390
  8. XenForo_Model_Deferred->_runInternal() in XenForo/Model/Deferred.php at line 316
  9. XenForo_Model_Deferred->runByUniqueKey() in XenForo/Install/Controller/Abstract.php at line 34
  10. XenForo_Install_Controller_Abstract->_manualDeferredRunner() in XenForo/Install/Controller/Install.php at line 236
  11. XenForo_Install_Controller_Install->actionRunDeferred() in XenForo/FrontController.php at line 347
  12. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  13. XenForo_FrontController->run() in /home/u32134/xn--90aifdweiqhwi2g.xn--p1ai/www/f/install/index.php at line 18
I wonder, why is this happening and how to fix it?
 

AlM

New member
#2
BTW, my hosting provider says that I get these messages, because I have just 256 Mb of RAM on my Linux VDS account. Is this truth that 256 Mb is not enough for XenForo? Or my provider just wants to sell me more expensive VDS service?

PS: I've installed XenForo from the 4th try, but now I get same error as posted above or 500 server error when I'm trying to import language file.
 

Brogan

XenForo moderator
Staff member
#3
That may not be enough RAM when doing installs and upgrades due to the amount of processing which occurs.
 

Mike

XenForo developer
Staff member
#4
256MB is really nothing for a whole OS, a web server, PHP processes and a MySQL database. This is an error indicating that MySQL is closing the connection. There may be more information in MySQL's error log.
 

Tracy Perry

Well-known member
#5
BTW, my hosting provider says that I get these messages, because I have just 256 Mb of RAM on my Linux VDS account. Is this truth that 256 Mb is not enough for XenForo? Or my provider just wants to sell me more expensive VDS service?
Minimal I personally would use would be 512MB. More confortable would be a 1GB one. On all my VPS's that I have created I have a variable amount defined of a minimum of 512MB up to a max (on my "more important" forum) of 4GB.