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