XF 1.1 An exception occurred: Mysqli prepare error: Unknown storage engine 'InnoDB'

[Vijay]

My site went offline moments ago with this error:

An exception occurred: Mysqli prepare error: Unknown storage engine 'InnoDB' in /home/myaccount/public_html/library/Zend/Db/Statement/Mysqli.php on line 77

Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 825
Zend_Db_Adapter_Abstract->fetchOne() in XenForo/Error.php at line 50
XenForo_Error::unexpectedException() in XenForo/Application.php at line 295
XenForo_Application::handleException()

Suggestions?

 

[Sadik B]

Vijay, 6 or 11 hops doesn't make that huge a difference unless you are dealing with real time data update. (Something like the stock markets perhaps). I am from India and sadly I am yet to find a competent host in India. My sites are hosted with softlayer but a dedicated host may not suit your budget at this time.

Among the larger players, liquidweb is a good company. Among the smaller ones, crocweb, MDD Hosting is a very nice company with universally positive reviews. If I were in your position I would have chosen crocweb. No. of hops doesn't make too big a difference, what is important is how fast your site renders to your visitor. Optimize your site, smush images, use caching, use a static domain, perhaps a cdn if one has an India node, etc...

 

[Sadik B]

And to add to that, backup your sites always at least once a week!