bug restauration data base and website prestashop 1.7.0

[Webmaster2020]

Hello,

I have this errors in my website and i don't no how to solved it can you help me please ?

it's occurend when i deleted database and i restaured it:

Warning: rename(/tmp/class_index.phpW4TOom,/home/digimexbwk/www/app/cache/dev/class_index.php): No such file or directory in /home/digimexbwk/www/classes/PrestaShopAutoload.php on line 254

Warning: rename(/tmp/class_stub.phpHHLjLq,/home/digimexbwk/www/app/cache/dev/class_stub.php): No such file or directory in /home/digimexbwk/www/classes/PrestaShopAutoload.php on line 254

Warning: rename(/tmp/namespaced_class_stub.phpmdR47u,/home/digimexbwk/www/app/cache/dev/namespaced_class_stub.php): No such file or directory in /home/digimexbwk/www/classes/PrestaShopAutoload.php on line 254

[PrestaShopDatabaseException]

Table 'ovh_prestashop.xch188shop_url' doesn't exist
 

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

at line 744 in file classes/db/Db.php

739. if ($webservice_call && $errno) { 740. $dbg = debug_backtrace(); 741. WebserviceRequest::getInstance()->setError(500, '

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 742. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) { 743. if ($sql) { 744. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 745. } 746. 747. throw new PrestaShopDatabaseException($this->getMsgError()); 748. } 749. }

 

DbCore->displayError - [line 378 - classes/db/Db.php] - [1 Arguments]

Argument [0] SELECT s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM xch188shop_url su LEFT JOIN xch188shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'digimex.be' OR su.domain_ssl = 'digimex.be') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC

 

DbCore->query - [line 596 - classes/db/Db.php] - [1 Arguments]

591. throw new PrestaShopDatabaseException('Db->executeS() must be used only with select, show, explain or describe queries'); 592. } 593. return $this->execute($sql, $use_cache); 594. } 595. 596. $this->result = $this->query($sql); 597. 598. if (!$this->result) { 599. $result = false; 600. } else { 601. if (!$array) {

 

DbCore->executeS - [line 351 - classes/shop/Shop.php] - [1 Arguments]

346. WHERE (su.domain = \''.pSQL($host).'\' OR su.domain_ssl = \''.pSQL($host).'\') 347. AND s.active = 1 348. AND s.deleted = 0 349. ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC'; 350. 351. $result = Db::getInstance()->executeS($sql); 352. 353. $through = false; 354. foreach ($result as $row) { 355. // An URL matching current shop was found 356. if (preg_match('#^'.preg_quote($row['uri'], '#').'#i', $request_uri)) {

 

ShopCore::initialize - [line 118 - config/config.inc.php]

113. 114. $context = Context::getContext(); 115. 116. /* Initialize the current Shop */ 117. try { 118. $context->shop = Shop::initialize(); 119. } catch (PrestaShopException $e) { 120. $e->displayMessage(); 121. } 122. define('_THEME_NAME_', $context->shop->theme->getName()); 123. define('_PARENT_THEME_NAME_', $context->shop->theme->get('parent') ?: '');

 

require - [line 27 - index.php] - [1 Arguments]

Argument [0] /home/digimexbwk/www/config/config.inc.php

 

 

[doekia]

Ton backup est incomplet ou plutot la restauration n'a pas completement abouti

[Webmaster2020]

d'accord je vais restaurer a nouveau. Merci

[Webmaster2020]

j'ai installer prestashop en local et j'ai copier les fichiers: module ,classe ,admin,theme ,img

le site c'est afficher mais le contenu du module bloc texte et diaporama et les page cms ainsi que le menu ne s'affiche pas .

pourriez vous m'aidé a trouver l'emplacement de ces fichiers svp?

Merci

 

Edited January 11, 2020 by Webmaster2020 (see edit history)