Jump to content

Pantalla blanca al confirmar pedido (SOLUCIONADO)


miguelfs14

Recommended Posts

Hola, al hacer unas pruebas en Front Office, he detectado que al confirmar un carrito y avanzar en el pedido, cuando llega al apartado de transportistas, se queda la pantalla en blanco.

No he actualizado, los únicos cambios son meter nuevos productos y hace un par de días unos módulos.

No fallan más cosas, no sabría decir desde cuándo está el fallo.

La versión es la 1.5.4.1 y la página está en funcionamiento. No tengo ni idea de lo que ocurre, me salen estos errores:

Warning: Function addCSS() is deprecated in /var/www/vhosts/rcmachines.es/httpdocs/modules/blockrestock/blockrestock.php on line 216
in /var/www/vhosts/rcmachines.es/httpdocs/classes/Tools.php on line 1845 Warning: Function addCSS() is deprecated in /var/www/vhosts/rcmachines.es/httpdocs/modules/blockhtml/blockhtml.php on line 614
in /var/www/vhosts/rcmachines.es/httpdocs/classes/Tools.php on line 1845
[PrestaShopDatabaseException]

Unknown column 'a.id_product' in 'field list'


			SELECT a.`id_product`, pl.`link_rewrite`, pl.`name`, CONCAT(GROUP_CONCAT(IFNULL(al.name, ''), '')) attribute, i.`id_image`, il.`legend`, cl.`link_rewrite` AS category, a.`date_add`
			FROM prstshp_stock_mvt a
			LEFT JOIN `prstshp_product` p ON ( a.id_product = p.id_product )
			LEFT JOIN `prstshp_product_lang` pl ON ( a.id_product = pl.id_product AND pl.id_lang = 4 )
			LEFT JOIN `prstshp_image` i ON (i.`id_product` = a.`id_product` AND i.`cover` = 1)
			LEFT JOIN `prstshp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 4)			
			LEFT JOIN `prstshp_category_lang` cl ON (cl.`id_category` = p.`id_category_default` AND cl.`id_lang` = 4)
			LEFT JOIN `prstshp_stock_mvt_reason_lang` mrl ON ( a.id_stock_mvt_reason = mrl.id_stock_mvt_reason AND mrl.id_lang =4 ) 
			LEFT JOIN `prstshp_product_attribute_combination` pac ON ( pac.id_product_attribute = a.id_product_attribute ) 
			LEFT JOIN `prstshp_attribute_lang` al ON ( al.id_attribute = pac.id_attribute AND al.id_lang = 4 ) 
			WHERE a.id_stock_mvt_reason = 1
			AND p.`active` = 1
			
			
			AND p.`id_product` IN (
				SELECT cp.`id_product`
				FROM `prstshp_category_group` cg
				LEFT JOIN `prstshp_category_product` cp ON (cp.`id_category` = cg.`id_category`)
				WHERE cg.`id_group` IN (SELECT id_group FROM prstshp_customer_group WHERE id_customer = 58)
			)
			GROUP BY a.id_stock_mvt
			ORDER BY a.date_add DESC 
			LIMIT 0, 5

at line 607 in file classes/db/Db.php
601. 			WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
602. 		}
603. 		else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
604. 		{
605. 			if ($sql)
606. 				throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
607. 			throw new PrestaShopDatabaseException($this->getMsgError());
608. 		}
609. 	}
610. 
611. 	/**
DbCore->displayError - [line 307 - classes/db/Db.php] - [1 Arguments]
DbCore->query - [line 482 - classes/db/Db.php] - [1 Arguments]
DbCore->executeS - [line 148 - modules/blockrestock/blockrestock.php] - [1 Arguments]
BlockReStock->getBestRated - [line 173 - modules/blockrestock/blockrestock.php] - [4 Arguments]
BlockReStock->hookRightColumn - [line 423 - classes/Hook.php] - [1 Arguments]
HookCore::exec - [line 428 - classes/controller/FrontController.php] - [2 Arguments]
FrontControllerCore->initContent - [line 99 - controllers/front/OrderController.php] - [0 Argument]
OrderControllerCore->initContent - [line 167 - classes/controller/Controller.php] - [0 Argument]
ControllerCore->run - [line 349 - classes/Dispatcher.php] - [0 Argument]
DispatcherCore->dispatch - [line 28 - index.php] - [0 Argument]

He reiniciado los módulos blockrestock y blockhtml pero sigue igual.

 

Por favor, necesito ayuda, muchas gracias

Edited by miguelfs14 (see edit history)
Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
×
×
  • Create New...