Hi Folks
We have been working on a store for over two months. We were running tests and noticed we could not create accounts if the country is not the local country. If you choose any country other than India in our case we end up with an error message. We have tried searching for the issue in bugs, forums etc and are clueless what is causing this.
We also tried disabling all the external modules we had added. We also disabled the module Block Categories and the account creation still bombs out.
There is nothing in the errror log or anything for us to look at.
Can anyone help us out???
Our site is sweetcherry.in
The error message is below.
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 id_category ORDER BY `level_depth` ASC, c.`position` ASC' at line 7
SELECT c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1)
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE (c.`active` = 1 OR c.`id_category` = 1)
AND `level_depth` <= 3
AND cg.`id_group` IN ()
GROUP BY id_category
ORDER BY `level_depth` ASC, c.`position` ASC
Thanks
MI