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

  • Posts: 3
  • Thank you received: 0
  • Hikashop Business
3 weeks 2 days ago #367923

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

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

  • Posts: 84216
  • Thank you received: 13665
  • MODERATOR
3 weeks 2 days ago #367924

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.

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

Time to create page: 0.053 seconds
Powered by Kunena Forum