Error 500. PHP Warning: Invalid argument supplied for foreach(). en shop.php

[Menotis]

Buenas!

 

Estoy a punto de publicar mi web pero al subirla al hosting, me aparece el siguiente error (adjunto).

Estoy bastante desesperado porque no consigo resolver el problema y ya son un par de semanas con esto. No sé por donde salir...

 

Por favor, si alguien me puede ayudar!!!?????.

 

Tiene pinta de ser problema de la base de datos pues si en el directorio raíz en lugar del index.php de prestashop pongo un index.html simple (un hola mundo por ejemplo) si me funciona.

 

Alguna idea?

 

Gracias de antemano! 

[Menotis]

Acabo de activar el modo debug y me aparece lo siguiente:

 

Por cierto, la tienda la tengo hecha en prestashop 1.6.0.9 mientras que el prestashop que me ofrecia el hosting era el prestashop 1.6.0.11. Podría ser por eso el error?

 

Adjunto la info que me aparece tras activar el modo debug:

 

[PrestaShopDatabaseException]

Table 'prestatienda.psshop_url' doesn't exist
 

SELECT s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main					FROM psshop_url su					LEFT JOIN psshop s ON (s.id_shop = su.id_shop)					WHERE (su.domain = 'www.elaljibevlc.com' OR su.domain_ssl = 'www.elaljibevlc.com')						AND s.active = 1						AND s.deleted = 0					ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC

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

 

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

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

  328. 		if ($sql instanceof DbQuery)329. 			$sql = $sql->build();330. 331. 		$this->result = $this->_query($sql);332. 		if (_PS_DEBUG_SQL_)333. 			$this->displayError($sql);334. 		return $this->result;335. 	}336. 337. 	/**338. 	 * Execute an INSERT query

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

  504. 		{505. 			$this->last_cached = true;506. 			return $result;507. 		}508. 509. 		$this->result = $this->query($sql);510. 511. 		if (!$this->result)512. 			$result = false;513. 		else514. 		{

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

  324. 					WHERE (su.domain = \''. pSQL($host).'\' OR su.domain_ssl = \''. pSQL($host).'\')325. 						AND s.active = 1326. 						AND s.deleted = 0327. 					ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC';328. 329. 			$result = Db::getInstance()->executeS($sql);330. 331. 			$through = false;332. 			foreach ($result as $row)333. 			{334. 				// An URL matching current shop was found

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

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

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

  Argument [0]C:\Inetpub\vhosts\elaljibevlc.com\httpdocs\config\config.inc.php

Directory C:\Inetpub\vhosts\elaljibevlc.com\httpdocs/log is not writable