can anywone help me with this error? It came on menu and breadcrumbs. [PrestaShopDatabaseException]
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INNER JOIN ps_manufacturer m ON (m.id_manufacturer = p.id_manufacturer) W' at line 4
SELECT m.name, 0 nbr, m.id_manufacturer
FROM ps_cat_restriction p JOIN
INNER JOIN ps_manufacturer m ON (m.id_manufacturer = p.id_manufacturer)
WHERE 1
GROUP BY p.id_manufacturer ORDER BY m.name
at line 646 in file classes/db/Db.php
641. WebserviceRequest::getInstance()->setError(500, '
'.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);642. } 643. elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) 644. { 645. if ($sql) 646. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 647. throw new PrestaShopDatabaseException($this->getMsgError()); 648. } 649. } 650. 651. /**
DbCore->displayError - [line 340 - classes/db/Db.php] - [1 Arguments]
DbCore->query - [line 516 - classes/db/Db.php] - [1 Arguments]
DbCore->executeS - [line 2377 - modules/blocklayered/blocklayered.php] - [1 Arguments]
BlockLayered->getFilterBlock - [line 687 - modules/blocklayered/blocklayered.php] - [1 Arguments]
BlockLayered->hookHeader - [line 512 - classes/Hook.php] - [1 Arguments]
HookCore::exec - [line 456 - classes/controller/FrontController.php] - [1 Arguments]
FrontControllerCore->initContent - [line 104 - controllers/front/CategoryController.php]
CategoryControllerCore->initContent - [line 180 - classes/controller/Controller.php]
ControllerCore->run - [line 373 - classes/Dispatcher.php]
DispatcherCore->dispatch - [line 28 - index.php]