Jump to content
juanmlg

[PrestaShopDatabaseException] Unknown storage engine 'InnoDB' I need Help

Recommended Posts

Hello, this month I have get 2 times these error, the first time after contact with the hosting the said that they have changed some config on the server to solve it, but a week later here we are again. I havent done any changes on my files or config. What would be the cause? I receive error 500 and then after turn on the debug mode I see the following info:

 

[PrestaShopDatabaseException]
Unknown storage engine 'InnoDB'


SELECT s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
					FROM ps_shop_url su
					LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
					WHERE (su.domain = 'mitienda.com' OR su.domain_ssl = 'mitienda.com')
						AND s.active = 1
						AND s.deleted = 0
					ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC

at line 791 in file classes/db/Db.php
786.         if ($webservice_call && $errno) {
787.             $dbg = debug_backtrace();
788.             WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
789.         } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
790.             if ($sql) {
791.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
792.             }
793. 
794.             throw new PrestaShopDatabaseException($this->getMsgError());
795.         }
796.     }
DbCore->displayError - [line 425 - classes/db/Db.php] - [1 Arguments]
420.                 $this->result = $this->_query($sql);
421.             }
422.         }
423. 
424.         if (_PS_DEBUG_SQL_) {
425.             $this->displayError($sql);
426.         }
427. 
428.         return $this->result;
429.     }
430. 
DbCore->query - [line 643 - classes/db/Db.php] - [1 Arguments]
638.                 throw new PrestaShopDatabaseException('Db->executeS() must be used only with select, show, explain or describe queries');
639.             }
640.             return $this->execute($sql, $use_cache);
641.         }
642. 
643.         $this->result = $this->query($sql);
644. 
645.         if (!$this->result) {
646.             $result = false;
647.         } else {
648.             if (!$array) {
DbCore->executeS - [line 334 - classes/shop/Shop.php] - [1 Arguments]
329. 					WHERE (su.domain = \''.pSQL($host).'\' OR su.domain_ssl = \''.pSQL($host).'\')
330. 						AND s.active = 1
331. 						AND s.deleted = 0
332. 					ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC';
333. 
334.             $result = Db::getInstance()->executeS($sql);
335. 
336.             $through = false;
337.             foreach ($result as $row) {
338.                 // An URL matching current shop was found
339.                 if (preg_match('#^'.preg_quote($row['uri'], '#').'#i', $request_uri)) {
ShopCore::initialize - [line 114 - config/config.inc.php]
109. 
110. $context = Context::getContext();
111. 
112. /* Initialize the current Shop */
113. try {
114.     $context->shop = Shop::initialize();
115.     $context->theme = new Theme((int)$context->shop->id_theme);
116.     if ((Tools::isEmpty($theme_name = $context->shop->getTheme()) || !Validate::isLoadedObject($context->theme)) && !defined('_PS_ADMIN_DIR_')) {
117.         throw new PrestaShopException(Tools::displayError('Current theme unselected. Please check your theme configuration.'));
118.     }
119. } catch (PrestaShopException $e) {
require - [line 27 - index.php] - [1 Arguments]
Argument [0]
/home/server/public_html/mitienda/tienda/config/config.inc.php

 

Would be amazing to know if there is a hosting problem and if will be a good idea to move my shop to other hosting.

Thanks so much

Regards

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More