1064 error in SQL

Hi,
I'm not sure how this happened as no error was displaying last time I worked on the website.
Yesterday Faboba logged in to find the issues with its component, don't know what he really did in the administration and if what he did can be the cause of this error.
Today I cannot access hikashop in the administration and also had to unpublish the manufacturer slider module to get rid of the error in the front-end.

Administration:
1064 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 'AND category_type='status' LIMIT 1' at line 1 SQL=SELECT category_id FROM det_hikashop_category WHERE category_parent_id= AND category_type='status' LIMIT 1

Front-end:
1064 - 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 'AND category_type='manufacturer' LIMIT 1' at line 1 SQL=SELECT category_id FROM det_hikashop_category WHERE category_parent_id= AND category_type='manufacturer' LIMIT 1

What can I do ?

Regards

Faboba confirms he did not modify anything expect publishing a new menu module for his tests.

Please help, I do not understand and need to continue working...

Thank you in advance.
Regards

Hi,

Please see this post : www.hikashop.com/forum/install-update/86...-3-3-3-0.html#155181

Thank you Xavier, you saved me precious time.

I can't understand how it can be working for so long and then go wrong at once?
Nevertheless it is solved.

Thank you again!

Oups... it created wrong administration link

clicking on product -> brands
leads to empty "explorer" in the cat tree and root in the listing

As explained in the other thread, this happens because there is a problem with the root category of your website. This category should never be changed (and actually cannot be changed via the interface of HikaShop).
The fix Jerome provided only avoid the query to crash, but that query should never crash since the system should always find the root category in the hikashop_category table. A proper fix in your case is to restore the root category to how it was before, after the installation of HikaShop, so taht all the bits which use it in HikaShop can use it and function properly.