Check Database Errors

  • Posts: 76
  • Thank you received: 0
  • Hikashop Business
1 month 1 day ago #295602

-- 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.

Please Log in or Create an account to join the conversation.

  • Posts: 11722
  • Thank you received: 1626
  • MODERATOR
1 month 22 hours ago #295612

Hello,

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

Best regards,
Mohamed Thelji.

Please Log in or Create an account to join the conversation.

  • Posts: 76
  • Thank you received: 0
  • Hikashop Business
1 month 20 hours ago #295635

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

Please advise.

Please Log in or Create an account to join the conversation.

  • Posts: 63027
  • Thank you received: 9058
  • MODERATOR
1 month 15 hours ago #295640

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.

Please Log in or Create an account to join the conversation.

Time to create page: 0.076 seconds
Powered by Kunena Forum