[Skip to main content](#vessel-content) # Error on "Check Database": Duplicate entry '0' for key 'user\_cms\_id' ## - **[UPL](/forum/user/83461-upl "View UPL's Profile")** - [![UPL's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/83461-upl "View UPL's Profile") Topic Author - [ Offline](/forum/user/83461-upl) Less More - Posts: 6 - Thank you received: 1 - - 1 year 3 months ago [\#367923](#367923) by [UPL](/forum/user/83461-upl "View UPL's Profile") *[Error on "Check Database": Duplicate entry '0' for key 'user\_cms\_id'](/forum/33-customers/909586-error-on-check-database-duplicate-entry-0-for-key-user-cms-id#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.")* was created by *[UPL](/forum/user/83461-upl "View UPL's Profile")* -- 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMzLWN1c3RvbWVycy85MDk1ODYtZXJyb3Itb24tY2hlY2stZGF0YWJhc2UtZHVwbGljYXRlLWVudHJ5LTAtZm9yLWtleS11c2VyLWNtcy1pZD90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86324 - Thank you received: 14286 - - 1 year 3 months ago [\#367924](#367924) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Error on "Check Database": Duplicate entry '0' for key 'user\_cms\_id'](/forum/33-customers/909586-error-on-check-database-duplicate-entry-0-for-key-user-cms-id#367924 "-- 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. The following user(s) said Thank You: [UPL](/forum/user/83461-upl "View UPL's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMzLWN1c3RvbWVycy85MDk1ODYtZXJyb3Itb24tY2hlY2stZGF0YWJhc2UtZHVwbGljYXRlLWVudHJ5LTAtZm9yLWtleS11c2VyLWNtcy1pZD90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.048 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)