Check Database Errors

-- url of the page with the problem -- : shop.justducks.co.uk
-- HikaShop version -- : 3.5.0
-- Joomla version -- : 3.8 10
-- PHP version -- : latest
-- Browser(s) name and version -- : all

Can anyone provide a solution to the database errors, the text of which is here:

ERROR 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 'OR product_category_id =' at line 1

ERROR Duplicate entry '' for key 'PRIMARY'

ERROR Incorrect column specifier for column 'product_category_id'

We believe this might be problematic of a serious error in displaying a comprehensive of category menus on the site front end, where category links fail to open categories that have products within.

Any help or suggestions would be appreciated.

P.S. Checking, repairing, etc. of the MySQL database to no avail.

Hello,

Can you use the "Check database" option through the page "Hikashop->System->Configuration" and test it again ? Thank you.

Best regards,
Mohamed Thelji.

Checked it at 7 a.m. U.S. Eastern Time and the same errors are given as per original issue report.

Please advise.

Hi,

We'll need more information about the error to be able to understand where the issue comes form.
Please do that modification:
www.hikashop.com/support/forum/2-general...ror-1054.html#287524
And also activate the debug mode and error reporting settings of the Joomla configuration.
Then, display the page with the issue again and provide all the details available about the error on that page.