Totti Posted June 28, 2013 Share Posted June 28, 2013 Today after using the program pscleaner gets me off this error. Fatal error: Uncaught 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 ')) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`' at line 6<br /><br /><pre>SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `ps_module` m INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE ((SELECT COUNT(*) FROM ps_module_shop ms WHERE ms.id_module = m.id_module AND ms.id_shop IN (1)) = 1) AND (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.`id_group` IN ()) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position` </pre> thrown in /data/vhosts/XXXXXX.com/XXXXXX/classes/db/Db.php on line 607 Link to comment Share on other sites More sharing options...
afi1 Posted June 28, 2015 Share Posted June 28, 2015 Hi, I'm having the same issue, just now, did you find a way to solve it? Tks! Link to comment Share on other sites More sharing options...
tuk66 Posted June 29, 2015 Share Posted June 29, 2015 What is your PrestaShop version? Link to comment Share on other sites More sharing options...
Totti Posted June 30, 2015 Author Share Posted June 30, 2015 1.6.0.14 Link to comment Share on other sites More sharing options...
tuk66 Posted June 30, 2015 Share Posted June 30, 2015 It is in the Module::getPaymentModules method. This part is the error: AND (mg.`id_group` IN ()) It means you have a problem with groups. But where... ? Link to comment Share on other sites More sharing options...
Recommended Posts