[Skip to main content](#vessel-content) # 1062 Duplicate entry 'XYWZ' for key 'group\_key' only in control panel ## - **[trik84](/forum/user/15695-trik84 "View trik84's Profile")** - [![trik84's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/15695-trik84 "View trik84's Profile") Topic Author - [ Offline](/forum/user/15695-trik84) Less More - Posts: 56 - Thank you received: 1 - - 6 years 6 months ago [\#317204](#317204) by [trik84](/forum/user/15695-trik84 "View trik84's Profile") *[1062 Duplicate entry 'XYWZ' for key 'group\_key' only in control panel](/forum/25-install-update/899485-1062-duplicate-entry-xywz-for-key-group-key-only-in-control-panel#317204 "-- HikaShop version -- : 3.4.1 -- Joomla version -- : 3.9.10 -- PHP version -- : 5.6.6 -- Error-message(debug-mod must be tuned on) -- : 1062 Duplicate entry 'XYWZ' for key 'group_key' Hi, I know I have an old php and hikashop version but I'm still waiting to update php on my hosting to update all. With this configuration, it works everything's well for 1 year until some days ago. All hikashop works perfectly only in the control panel appear this error: 1062 Duplicate entry 'XYWZ' for key 'group_key' the number XYWZ change at any login. I search this value in all DB but without a result. How can i resolve the problem ? Many thanks and best regards. Luca")* was created by *[trik84](/forum/user/15695-trik84 "View trik84's Profile")* -- HikaShop version -- : 3.4.1 -- Joomla version -- : 3.9.10 -- PHP version -- : 5.6.6 -- Error-message(debug-mod must be tuned on) -- : 1062 Duplicate entry 'XYWZ' for key 'group_key' Hi, I know I have an old php and hikashop version but I'm still waiting to update php on my hosting to update all. With this configuration, it works everything's well for 1 year until some days ago. All hikashop works perfectly only in the control panel appear this error: 1062 Duplicate entry 'XYWZ' for key 'group_key' the number XYWZ change at any login. I search this value in all DB but without a result. How can i resolve the problem ? Many thanks and best regards. Luca Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5OTQ4NS0xMDYyLWR1cGxpY2F0ZS1lbnRyeS14eXd6LWZvci1rZXktZ3JvdXAta2V5LW9ubHktaW4tY29udHJvbC1wYW5lbD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 6 years 6 months ago [\#317208](#317208) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[1062 Duplicate entry 'XYWZ' for key 'group\_key' only in control panel](/forum/25-install-update/899485-1062-duplicate-entry-xywz-for-key-group-key-only-in-control-panel#317208 "-- HikaShop version -- : 3.4.1 -- Joomla version -- : 3.9.10 -- PHP version -- : 5.6.6 -- Error-message(debug-mod must be tuned on) -- : 1062 Duplicate entry 'XYWZ' for key 'group_key' Hi, I know I have an old php and hikashop version but I'm still waiting to update php on my hosting to update all. With this configuration, it works everything's well for 1 year until some days ago. All hikashop works perfectly only in the control panel appear this error: 1062 Duplicate entry 'XYWZ' for key 'group_key' the number XYWZ change at any login. I search this value in all DB but without a result. How can i resolve the problem ? Many thanks and best regards. Luca")* hi, It's likely an issue with Joomla: [ forum.joomla.org/viewtopic.php?t=858744](https://forum.joomla.org/viewtopic.php?t=858744) I would recommend to first activate the debug mode and error reporting settings of the Joomla configuration. Also, do this change: [ www.hikashop.com/support/forum/product-c...eld-list.html#304882](https://www.hikashop.com/support/forum/product-category-display/897111-1054-unknown-column-b-product-volume-in-field-list.html#304882) That way, when you reproduce the problem, you should see the MySQL query linked to that error and that will tell you better where the problem comes from. If the error doesn't involve hikashop tables, then it's likely not related to your HikaShop. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5OTQ4NS0xMDYyLWR1cGxpY2F0ZS1lbnRyeS14eXd6LWZvci1rZXktZ3JvdXAta2V5LW9ubHktaW4tY29udHJvbC1wYW5lbD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[trik84](/forum/user/15695-trik84 "View trik84's Profile")** - [![trik84's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/15695-trik84 "View trik84's Profile") Topic Author - [ Offline](/forum/user/15695-trik84) Less More - Posts: 56 - Thank you received: 1 - - 6 years 6 months ago [\#317229](#317229) by [trik84](/forum/user/15695-trik84 "View trik84's Profile") Replied by *[trik84](/forum/user/15695-trik84 "View trik84's Profile")* on topic *[1062 Duplicate entry 'XYWZ' for key 'group\_key' only in control panel](/forum/25-install-update/899485-1062-duplicate-entry-xywz-for-key-group-key-only-in-control-panel#317229 "-- HikaShop version -- : 3.4.1 -- Joomla version -- : 3.9.10 -- PHP version -- : 5.6.6 -- Error-message(debug-mod must be tuned on) -- : 1062 Duplicate entry 'XYWZ' for key 'group_key' Hi, I know I have an old php and hikashop version but I'm still waiting to update php on my hosting to update all. With this configuration, it works everything's well for 1 year until some days ago. All hikashop works perfectly only in the control panel appear this error: 1062 Duplicate entry 'XYWZ' for key 'group_key' the number XYWZ change at any login. I search this value in all DB but without a result. How can i resolve the problem ? Many thanks and best regards. Luca")* Hi Nicolas, the trick of modify /libraries/joomla/database/exception/executing.php to print the query is very useful, trying this the query is: Code: SELECT *, SUM( case when o.order_currency_id = '1' then o.order_full_price end ) AS Total, COUNT(o.order_id) AS order_number FROM k4x6e_hikashop_order as o LEFT JOIN k4x6e_hikashop_user as a ON o.order_user_id=a.user_id LEFT JOIN k4x6e_users as u ON u.id=a.user_cms_id LEFT JOIN k4x6e_users AS b ON a.user_cms_id=b.id WHERE a.user_partner_activated=0 AND o.order_status IN ('shipped') AND a.user_id IS NOT NULL AND o.order_type='sale' GROUP BY a.user_id ORDER BY Total DESC LIMIT 10 If I try to execute this query in PhpMyAdmin I get #1062 - Duplicate entry error. How is it possible in a SELECT ? Where is the problem ? Many thanks Luca Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5OTQ4NS0xMDYyLWR1cGxpY2F0ZS1lbnRyeS14eXd6LWZvci1rZXktZ3JvdXAta2V5LW9ubHktaW4tY29udHJvbC1wYW5lbD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 6 years 6 months ago [\#317230](#317230) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[1062 Duplicate entry 'XYWZ' for key 'group\_key' only in control panel](/forum/25-install-update/899485-1062-duplicate-entry-xywz-for-key-group-key-only-in-control-panel#317230 "-- HikaShop version -- : 3.4.1 -- Joomla version -- : 3.9.10 -- PHP version -- : 5.6.6 -- Error-message(debug-mod must be tuned on) -- : 1062 Duplicate entry 'XYWZ' for key 'group_key' Hi, I know I have an old php and hikashop version but I'm still waiting to update php on my hosting to update all. With this configuration, it works everything's well for 1 year until some days ago. All hikashop works perfectly only in the control panel appear this error: 1062 Duplicate entry 'XYWZ' for key 'group_key' the number XYWZ change at any login. I search this value in all DB but without a result. How can i resolve the problem ? Many thanks and best regards. Luca")* Hi, Apparently, this means that you're running out of disk space and / or the processing of that query requires more memory than allowed in the settings of your MySQL server. Here are some links regarding this: [ stackoverflow.com/questions/26725772/dup...ry-for-key-group-key](https://stackoverflow.com/questions/26725772/duplicate-entry-for-key-group-key) [ bugs.mysql.com/bug.php?id=58081](https://bugs.mysql.com/bug.php?id=58081) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5OTQ4NS0xMDYyLWR1cGxpY2F0ZS1lbnRyeS14eXd6LWZvci1rZXktZ3JvdXAta2V5LW9ubHktaW4tY29udHJvbC1wYW5lbD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) 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.166 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)