Introduction and error message

[rhondab]

Hi everyone! I inherited a Magento site and I admit, I am not extremely familiar with Magento. I am a website designer in Lexington, KY.

The error is on https://bigassdiesel.com which you can see if you go there, but here is what is showing on the home page:

There has been an error processing your request

SQLSTATE[42000]: Syntax error or access violation: 1286 Unknown storage engine 'InnoDB', query was: SELECT `main_table`.* FROM `mg_core_store` AS `main_table` ORDER BY CASE WHEN main_table.store_id = 0 THEN 0 ELSE 1 END ASC, main_table.sort_order ASC, main_table.name ASC

Trace:
#0 /home/cgs728/public_html/bigassdiesel.com/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/cgs728/public_html/bigassdiesel.com/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home/cgs728/public_html/bigassdiesel.com/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /home/cgs728/public_html/bigassdiesel.com/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `main_ta...', Array)
#4 /home/cgs728/public_html/bigassdiesel.com/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `main_ta...', Array)
#5 /home/cgs728/public_html/bigassdiesel.com/lib/Zend/Db/Adapter/Abstract.php(737): Varien_Db_Adapter_Pdo_Mysql->query('SELECT `main_ta...', Array)
#6 /home/cgs728/public_html/bigassdiesel.com/lib/Varien/Data/Collection/Db.php(736): Zend_Db_Adapter_Abstract->fetchAll('SELECT `main_ta...', Array)
#7 /home/cgs728/public_html/bigassdiesel.com/app/code/core/Mage/Core/Model/Resource/Db/Collection/Abstract.php(521): Varien_Data_Collection_Db->_fetchAll('SELECT `main_ta...', Array)
#8 /home/cgs728/public_html/bigassdiesel.com/lib/Varien/Data/Collection/Db.php(572): Mage_Core_Model_Resource_Db_Collection_Abstract->getData()
#9 /home/cgs728/public_html/bigassdiesel.com/app/code/core/Mage/Core/Model/Resource/Store/Collection.php(174): Varien_Data_Collection_Db->load(false, false)
#10 /home/cgs728/public_html/bigassdiesel.com/lib/Varien/Data/Collection.php(752): Mage_Core_Model_Resource_Store_Collection->load()
#11 /home/cgs728/public_html/bigassdiesel.com/app/code/core/Mage/Core/Model/App.php(635): Varien_Data_Collection->count()
#12 /home/cgs728/public_html/bigassdiesel.com/app/code/core/Mage/Core/Model/App.php(477): Mage_Core_Model_App->_initStores()
#13 /home/cgs728/public_html/bigassdiesel.com/app/code/core/Mage/Core/Model/App.php(360): Mage_Core_Model_App->_initCurrentStore('', 'store')
#14 /home/cgs728/public_html/bigassdiesel.com/app/Mage.php(684): Mage_Core_Model_App->run(Array)
#15 /home/cgs728/public_html/bigassdiesel.com/index.php(83): Mage::run('', 'store')
#16 {main}

If anyone can help me, I would surely appreciate it!

Thanks,
Rhonda

[rhondab]

Same error on client's other Magento store at cformsolutions.net:

There has been an error processing your request

SQLSTATE[42000]: Syntax error or access violation: 1286 Unknown storage engine 'InnoDB'

Trace:
#0 /home/cgs728/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/cgs728/public_html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home/cgs728/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /home/cgs728/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `main_ta...', Array)
#4 /home/cgs728/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `main_ta...', Array)
#5 /home/cgs728/public_html/lib/Zend/Db/Adapter/Abstract.php(734): Varien_Db_Adapter_Pdo_Mysql->query('SELECT `main_ta...', Array)
#6 /home/cgs728/public_html/lib/Varien/Data/Collection/Db.php(730): Zend_Db_Adapter_Abstract->fetchAll('SELECT `main_ta...', Array)
#7 /home/cgs728/public_html/app/code/core/Mage/Core/Model/Resource/Db/Collection/Abstract.php(521): Varien_Data_Collection_Db->_fetchAll('SELECT `main_ta...', Array)
#8 /home/cgs728/public_html/lib/Varien/Data/Collection/Db.php(566): Mage_Core_Model_Resource_Db_Collection_Abstract->getData()
#9 /home/cgs728/public_html/app/code/core/Mage/Core/Model/Resource/Store/Collection.php(174): Varien_Data_Collection_Db->load(false, false)
#10 /home/cgs728/public_html/lib/Varien/Data/Collection.php(752): Mage_Core_Model_Resource_Store_Collection->load()
#11 /home/cgs728/public_html/app/code/core/Mage/Core/Model/App.php(624): Varien_Data_Collection->count()
#12 /home/cgs728/public_html/app/code/core/Mage/Core/Model/App.php(466): Mage_Core_Model_App->_initStores()
#13 /home/cgs728/public_html/app/code/core/Mage/Core/Model/App.php(349): Mage_Core_Model_App->_initCurrentStore('', 'website')
#14 /home/cgs728/public_html/app/Mage.php(684): Mage_Core_Model_App->run(Array)
#15 /home/cgs728/public_html/index.php(87): Mage::run('', 'website')
#16 {main}

[Damian Culotta]

Hi @rhondab,

It seems there is an error with your mysql server.

Did you changed some paramenter of your DB server configuration?

[rhondab]

Damian, on bigassdiesel.com, we have converted it to WordPress (WooCommerce) but cformsolutions.net still has that same error message.

The weird thing is that I have touched nothing with the MySql database. I don't know if the host changed something or what (Hostgator).

Rhonda

[Damian Culotta · Accepted solution]

Hi @rhondab,

Sorry but I'm out of ideas.

If I were you I will be checking the database engine more than the application. I can't explain why but I suspect the the problem is there.

[rhondab · Accepted solution]

Thanks so much! Hostgator actually fixed the problem!



Rhonda

[sabina24]

Did they specify what was wrong and how to fix this. I have an identical problem with Magento 1.9. site https://fresheetmusic.com and have been trying to fix this for a week now.

Any info would be more then helpful. Thanks.

[Damian Culotta]

Hi @sabina24,

Which error?

It seems your store is working properly.

Can you share more details about the error, a log, a screenshot or an URL?