Error Query mysql

[Totti]

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

[NemoPS]

Hi,

that IN() is empty, there should be something there actually. Where do you get this error? I strongly discourage the user of pscleaner for these reasons.

[Totti]

I had not cleared properly solved the customer table.

[Kimi]

Hi

I got the same error and it was because i didnt generate secure_key for customer table

i didnt import rows to _customer_group table

Edited July 9, 2013 by Kimi (see edit history)

[Kimi]

I did this:

 

INSERT INTO `ps_customer_group` (id_customer,id_group) SELECT id_customer,3 FROM ps_customer WHERE id_customer NOT IN (SELECT id_customer FROM `ps_customer_group`)