Weird issue with account creation--- gurus please help

[iyengarm]

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 extewrnal modules we had added.

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

[alexsci7]

Hi,have you resolved the problem?

 

I have had the same experience,without solving..

 

please let me know

thank you