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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

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