juanmlg Posted October 10, 2019 Share Posted October 10, 2019 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 Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now