Problem with module 1 Click Upgrade.

[santana]

Hello, Good afternoon, I updated Prestashop 1.7.x to the latest version available with the 1 Click Upgrade module, upon completion, the checkout did not work and I tried to restore the backup copy with the same module, during the process it was interrupted with the following error:

https://www.italianaspa.com/

[PrestaShopDatabaseException]

Table '[email protected]_shop_url' doesn't exist<br /><br /><pre>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.italianaspa.com' OR su.domain_ssl = 'www.italianaspa.com') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC</pre>
at line 769 in file classes/db/Db.php

764. if ($webservice_call && $errno) { 765. $dbg = debug_backtrace(); 766. WebserviceRequest::getInstance()->setError(500, '[SQL Error] ' . $this->getMsgError() . '. From ' . (isset($dbg[3]['class']) ? $dbg[3]['class'] : '') . '->' . $dbg[3]['function'] . '() Query was : ' . $sql, 97); 767. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) { 768. if ($sql) { 769. throw new PrestaShopDatabaseException($this->getMsgError() . '<br /><br /><pre>' . $sql . '</pre>'); 770. } 771. 772. throw new PrestaShopDatabaseException($this->getMsgError()); 773. } 774. }

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

380. $this->result = $this->_query($sql); 381. } 382. } 383. 384. if (_PS_DEBUG_SQL_) { 385. $this->displayError($sql); 386. } 387. 388. return $this->result; 389. } 390.

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

608. } 609. 610. return $this->execute($sql, $use_cache); 611. } 612. 613. $this->result = $this->query($sql); 614. 615. if (!$this->result) { 616. $result = false; 617. } else { 618. if (!$array) {

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

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

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

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

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

Argument [0] /home/italianaspa2024/public_html/config/config.inc.php

Note, I have read some possible solutions in the forum, but apparently they are all different from my case and I cannot solve it. Any possible idea or suggestion? Something like this happened to someone with this module?

Greetings thank you

Santana