Error when Upgrade

[Macdesign]

I have upgraded website with 1click upgrade and doesn't get either the BO or FO to work.

 

I get the following error when turning dubug on.

 

[PrestaShopDatabaseException]

Table '173637-shop.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.hudetc.se' OR su.domain_ssl = 'www.hudetc.se')						AND s.active = 1						AND s.deleted = 0					ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC

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

 

607. 			WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);608. 		}609. 		else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))610. 		{611. 			if ($sql)612. 				throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');613. 			throw new PrestaShopDatabaseException($this->getMsgError());614. 		}615. 	}616. 617. 	/**

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

  307. 		if ($sql instanceof DbQuery)308. 			$sql = $sql->build();309. 310. 		$this->result = $this->_query($sql);311. 		if (_PS_DEBUG_SQL_)312. 			$this->displayError($sql);313. 		return $this->result;314. 	}315. 316. 	/**317. 	 * Execute an INSERT query

  Argument [0]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.hudetc.se' OR su.domain_ssl = 'www.hudetc.se')						AND s.active = 1						AND s.deleted = 0					ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC

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

  482. 		{483. 			$this->last_cached = true;484. 			return $result;485. 		}486. 487. 		$this->result = $this->query($sql);488. 		if (!$this->result)489. 			return false;490. 491. 		$this->last_cached = false;492. 		if (!$array)

  Argument [0]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.hudetc.se' OR su.domain_ssl = 'www.hudetc.se')						AND s.active = 1						AND s.deleted = 0					ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC

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

  309. 310. 			$id_shop = '';311. 			$found_uri = '';312. 			$request_uri = rawurldecode($_SERVER['REQUEST_URI']);313. 			$is_main_uri = false;314. 			if ($results = Db::getInstance()->executeS($sql))315. 			{316. 				foreach ($results as $row)317. 				{318. 					// An URL matching current shop was found319. 					if (preg_match('#^'.preg_quote($row['uri'], '#').'#i', $request_uri))

  Argument [0]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.hudetc.se' OR su.domain_ssl = 'www.hudetc.se')						AND s.active = 1						AND s.deleted = 0					ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC

• ShopCore::initialize - [line 95 - config/config.inc.php] - [0 Argument]

  89. $context = Context::getContext();90. 91. /* Initialize the current Shop */92. try 93. {94. 	$context->shop = Shop::initialize();95. }96. catch (PrestaShopException $e)97. {98. 	$e->displayMessage();99. }

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

 

 

Thanks for any help!

 

Marcus

[tuk66]

I have seen many complaints against 1Click upgrade. I suggest to do a fresh install.

[NemoPS]

Alternatively, you can try adding that table manually, accessing phpmyadmin and creating it with the following structure (see attachment)

[Sphyncks]

Quel a été le verdict final, j'ai actuellement le même problème.  Je ne veux pas tout perdre et tout réinstaller.

 

Cordialement,