Error on "Check Database": Duplicate entry '0' for key 'user_cms_id'

-- HikaShop version -- : 6.0.0
-- Joomla version -- : 5.3.2
-- PHP version -- : 8.2.28
-- Error-message(debug-mod must be tuned on) -- : Error Duplicate entry '0' for key 'user_cms_id

Hello,

When I run "Check Database" in the HikaShop dashboard, I get this error:

Error: Duplicate entry '0' for key 'user_cms_id'

Could you please help me understand what causes this and how to fix it?

Thank you very much for your support.

Hi,

This indicates that you or someone else on your end has added a unique key to the user_cms_id column of the hikashop_user table when it should not be there.
Go in your PHPMyAdmin, open the hikashop_user table and remove the unique key on the user_cms_id column.
Then, you should not have that error anymore.