error

[luminita]

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]

[tuk66]

That SQL query is wrong. You need to fix it in that module. JOIN is extra.

 

FROM ps_cat_restriction p JOIN
INNER JOIN ps_manufacturer m ON (m.id_manufacturer = p.id_manufacturer)