Errors wehen start the database check form the Hikashop configuration

  • Posts: 52
  • Thank you received: 4
  • Hikashop Multisite
4 years 4 weeks ago #325080

-- HikaShop version -- : HikaShop Business 4.3.0 [2007271529]
-- Joomla version -- : 3.9.22
-- PHP version -- : 7.3.23
-- Browser(s) name and version -- : Microsoft New Edge

When I'm in the backend of Hikashop, the go to Configuration and start the database check I see the following three errors:



How can I solve this issue?

Best regards,

Arjen

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

  • Posts: 82864
  • Thank you received: 13372
  • MODERATOR
4 years 4 weeks ago #325095

Hi,

There are no errors in your message so I'm not sure what to tell you.
Could you provide the errors you have ?

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

  • Posts: 52
  • Thank you received: 4
  • Hikashop Multisite
4 years 4 weeks ago #325098

Hello Nicolas,

See: vimeo.com/472551182/e860732e78 I made there a small movie where de DB Error excist.

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

  • Posts: 82864
  • Thank you received: 13372
  • MODERATOR
4 years 4 weeks ago #325105

Hi,

The issue is that the primary key of the table hikashop_product_related has been removed in your database for some reason.
And since that was done, you added twice the same product as a related product of the product with the id "2".
Because of that, MySQL cannot add back the primary key to that table.

Now you might have other duplicate entries in there and this might just be the first entry.

If you don't have a lot of products, I would recommend just emptying the hikashop_product_related table via your phpmyadmin, running again the check database process, and then you can add back the related products and options in your products manually.

If you have a lot of products, that will be time consuming to do what I propose above, so I would recommend to just ignore that error as it doesn't seem to create any problem for you.
The worst thing it could do would be that you would have twice the product listed in the related products listing of a product.

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

  • Posts: 52
  • Thank you received: 4
  • Hikashop Multisite
4 years 4 weeks ago #325159

Hello Nicalos,

I emttying the hikashop_product_related and did the check again. Problem solved. we will make the relation between the products manualy.

Thanks for your help.

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

Time to create page: 0.064 seconds
Powered by Kunena Forum