Table '.ps_shop_url' doesn't exist and 500 error

[butlerov]

Hi.Help plz cant undestand what to do.Today my site is suddenly stop working, got 500 error message.I cant login into admin panel, didnt update anything.Here logs of error, plz help. presta version 1.6.1.2

[PrestaShopDatabaseException]

Table 'databasename_sh.ps_shop_url' doesn't exist


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 = 'www.sitename.ru' OR su.domain_ssl = 'www.sitename.ru')
						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/users/b/directory/domains/sitename/config/config.inc.php

error.html

Edited April 22, 2016 by butlerov (see edit history)

[NemoPS]

It can't be happening all of a sudden, did you upgrade?
at any rate, you need to add the table http://screencast.com/t/SIRtDswkK

[butlerov]

It can't be happening all of a sudden, did you upgrade?

at any rate, you need to add the table http://screencast.com/t/SIRtDswkK

 no, didnt upgrade, just one day cant login to admin panel. Anyway thanks.

Today looking into phpadmin and didnt see any tables at all, that weird.

Edited April 23, 2016 by butlerov (see edit history)

[NemoPS]

No tables at all? Your site might have been hacked, hopefully you can restore a backup

[MEG Venture]

Your website had probably been restored and when the PHP execution was running during the restoration, the resources of your server were consumed. Therefore, the restoration of the tables was interrupted. You can count the number of tables you have to be sure about this assumption.

 

I would run the restoration from backup and switch to another hosting company immediately.