Table doesnt excist

[ianm]

Good Day

 

After upgrading to 1.6.0.9 I got the following error message which I can not solve:

[PrestaShopDatabaseException]

Table 'atmorele_pres867.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.3at1moreleta.co.za' OR su.domain_ssl = 'www.3at1moreleta.co.za')						AND s.active = 1						AND s.deleted = 0					ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC

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

 

629. 			WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);630. 		}631. 		else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))632. 		{633. 			if ($sql)634. 				throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');635. 			throw new PrestaShopDatabaseException($this->getMsgError());636. 		}637. 	}638. 639. 	/**

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

  319. 		if ($sql instanceof DbQuery)320. 			$sql = $sql->build();321. 322. 		$this->result = $this->_query($sql);323. 		if (_PS_DEBUG_SQL_)324. 			$this->displayError($sql);325. 		return $this->result;326. 	}327. 328. 	/**329. 	 * 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.3at1moreleta.co.za' OR su.domain_ssl = 'www.3at1moreleta.co.za')						AND s.active = 1						AND s.deleted = 0					ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC

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

  495. 		{496. 			$this->last_cached = true;497. 			return $result;498. 		}499. 500. 		$this->result = $this->query($sql);501. 502. 		if (!$this->result)503. 			$result = false;504. 		else505. 		{

  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.3at1moreleta.co.za' OR su.domain_ssl = 'www.3at1moreleta.co.za')						AND s.active = 1						AND s.deleted = 0					ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC

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

  323. 					WHERE (su.domain = \''. pSQL($host).'\' OR su.domain_ssl = \''. pSQL($host).'\')324. 						AND s.active = 1325. 						AND s.deleted = 0326. 					ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC';327. 328. 			$result = Db::getInstance()->executeS($sql);329. 			foreach ($result as $row)330. 			{331. 				// An URL matching current shop was found332. 				if (preg_match('#^'.preg_quote($row['uri'], '#').'#i', $request_uri))333. 				{

  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.3at1moreleta.co.za' OR su.domain_ssl = 'www.3at1moreleta.co.za')						AND s.active = 1						AND s.deleted = 0					ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC

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

  88. $context = Context::getContext();89. 90. /* Initialize the current Shop */91. try 92. {93. 	$context->shop = Shop::initialize();94. 	$context->theme = new Theme((int)$context->shop->id_theme);95. 	if ((Tools::isEmpty($theme_name = $context->shop->getTheme()) || !Validate::isLoadedObject($context->theme)) && !defined('_PS_ADMIN_DIR_'))96. 		throw new PrestaShopException(Tools::displayError('Current theme unselected. Please check your theme configuration.'));97. }98. catch (PrestaShopException $e)

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

  21. *  @copyright  2007-2014 PrestaShop SA22. *  @license    http://opensource.org/licenses/osl-3.0.php  Open Software License (OSL 3.0)23. *  International Registered Trademark & Property of PrestaShop SA24. */25. 26. require(dirname(__FILE__).'/config/config.inc.php');27. Dispatcher::getInstance()->dispatch();

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