[Skip to main content](#vessel-content) # An error has occurred. 1062 Duplicate entry '101-119' for key 'PRIMARY' ## - **[MSTACE](/forum/user/7448-mstace "View MSTACE's Profile")** - [![MSTACE's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar_2013-07-05.jpeg)](/forum/user/7448-mstace "View MSTACE's Profile") Topic Author - [ Away](/forum/user/7448-mstace) Less More- Posts: 301 - Thank you received: 10 - - 4 hours 13 minutes ago - 1 hour 5 minutes ago [\#100000340](#100000340) by [MSTACE](/forum/user/7448-mstace "View MSTACE's Profile") *[An error has occurred. 1062 Duplicate entry '101-119' for key 'PRIMARY'](/forum/32-content-creation/100000070-an-error-has-occurred-1062-duplicate-entry-101-119-for-key-primary#100000340 "-- url of the page with the problem -- : www.notable.au/ -- HikaShop version -- : 6.7.1  -- Joomla version -- : 6.2.0 -- PHP version -- : 8.5.12 -- Browser(s) name and version -- :  Chrome 155.0 -- Error-message(debug-mod must be tuned on) -- : An error has occurred. 1062 Duplicate entry '101-119' for key 'PRIMARY' When saving any Hikashop product, I get the error message " "Return to Dashboard". The same error occurs every time, no matter which product is tried. I ran phpMyAdmin. No database errors on check. Nothing looks suspicious.")* was created by *[MSTACE](/forum/user/7448-mstace "View MSTACE's Profile")* -- url of the page with the problem -- : [ www.notable.au/](https://www.notable.au/) -- HikaShop version -- : 6.7.1 -- Joomla version -- : 6.2.0 -- PHP version -- : 8.5.12 -- Browser(s) name and version -- : Chrome 155.0 -- Error-message(debug-mod must be tuned on) -- : An error has occurred. 1062 Duplicate entry '101-119' for key 'PRIMARY' When **saving** any Hikashop product, I get the error message "Duplicate entry '102-119' for key 'PRIMARY'" "Return to Dashboard". The same error occurs every time, no matter which product is tried. I ran phpMyAdmin. No database errors on check. Nothing looks suspicious. **106** Last edit: 1 hour 5 minutes ago by [MSTACE](/forum/user/7448-mstace "View MSTACE's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMyLWNvbnRlbnQtY3JlYXRpb24vMTAwMDAwMDcwLWFuLWVycm9yLWhhcy1vY2N1cnJlZC0xMDYyLWR1cGxpY2F0ZS1lbnRyeS0xMDEtMTE5LWZvci1rZXktcHJpbWFyeT90bXBsPW1hcmtkb3du) 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") - [ Away](/forum/user/63-nicolas) Less More- Posts: 86279 - Thank you received: 14262 - - 1 hour 12 minutes ago [\#100000343](#100000343) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[An error has occurred. 1062 Duplicate entry '101-119' for key 'PRIMARY'](/forum/32-content-creation/100000070-an-error-has-occurred-1062-duplicate-entry-101-119-for-key-primary#100000343 "-- url of the page with the problem -- : www.notable.au/ -- HikaShop version -- : 6.7.1  -- Joomla version -- : 6.2.0 -- PHP version -- : 8.5.12 -- Browser(s) name and version -- :  Chrome 155.0 -- Error-message(debug-mod must be tuned on) -- : An error has occurred. 1062 Duplicate entry '101-119' for key 'PRIMARY' When saving any Hikashop product, I get the error message " "Return to Dashboard". The same error occurs every time, no matter which product is tried. I ran phpMyAdmin. No database errors on check. Nothing looks suspicious.")* Hi, This error does not come from your products themselves but from the Joomla Smart Search index. When a product is saved, HikaShop's "Smart Search - HikaShop" plugin asks Joomla's Smart Search to index it again, and Joomla's indexer fails while writing the words of the product into its table #__finder_links_terms (the two numbers in the message are the index entry of the product and the id of a word, which is why only the first number changes from one product to the next). The product itself is saved before that step, so your changes are not lost: only the page ends on the error instead of coming back to the product. This happens when the Smart Search index tables are out of step, typically on a site that has been updated over many years or whose database collations were changed: the words table (#__finder_terms) then sees as identical two spellings that the indexer treats as different, for example with and without an accent, and the same word gets written twice for a product. To fix it, go to Content > Smart Search in your Joomla backend, click "Clear Index" (if you set up Smart Search content maps or filters, note them first, as clearing the index removes them), then click "Index" to rebuild it. Saving a product should then work again. If the error comes back after the index is rebuilt, check in phpMyAdmin that the "term", "stem" and "soundex" columns of the tables #__finder_terms, #__finder_tokens and #__finder_tokens_aggregate use the collation utf8mb4_bin, as Joomla creates them, and set them back to it if they don't. If you don't use the Joomla Smart Search on your site, you can instead simply disable the "Smart Search - HikaShop" plugin in System > Plugins: the error will go away as well. If none of this helps, please turn on "Debug System" in the Joomla Global Configuration, save a product again and send us the full error page with its call stack, so we can see exactly which query fails. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMyLWNvbnRlbnQtY3JlYXRpb24vMTAwMDAwMDcwLWFuLWVycm9yLWhhcy1vY2N1cnJlZC0xMDYyLWR1cGxpY2F0ZS1lbnRyeS0xMDEtMTE5LWZvci1rZXktcHJpbWFyeT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[MSTACE](/forum/user/7448-mstace "View MSTACE's Profile")** - [![MSTACE's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar_2013-07-05.jpeg)](/forum/user/7448-mstace "View MSTACE's Profile") Topic Author - [ Away](/forum/user/7448-mstace) Less More- Posts: 301 - Thank you received: 10 - - 1 hour 5 minutes ago [\#100000345](#100000345) by [MSTACE](/forum/user/7448-mstace "View MSTACE's Profile") Replied by *[MSTACE](/forum/user/7448-mstace "View MSTACE's Profile")* on topic *[An error has occurred. 1062 Duplicate entry '101-119' for key 'PRIMARY'](/forum/32-content-creation/100000070-an-error-has-occurred-1062-duplicate-entry-101-119-for-key-primary#100000345 "-- url of the page with the problem -- : www.notable.au/ -- HikaShop version -- : 6.7.1  -- Joomla version -- : 6.2.0 -- PHP version -- : 8.5.12 -- Browser(s) name and version -- :  Chrome 155.0 -- Error-message(debug-mod must be tuned on) -- : An error has occurred. 1062 Duplicate entry '101-119' for key 'PRIMARY' When saving any Hikashop product, I get the error message " "Return to Dashboard". The same error occurs every time, no matter which product is tried. I ran phpMyAdmin. No database errors on check. Nothing looks suspicious.")* Disabling the Hikashop Smart Search plugin has fixed the issue. We don't use Smart Search on any site. This must have been enabled in the last Hikashop update. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMyLWNvbnRlbnQtY3JlYXRpb24vMTAwMDAwMDcwLWFuLWVycm9yLWhhcy1vY2N1cnJlZC0xMDYyLWR1cGxpY2F0ZS1lbnRyeS0xMDEtMTE5LWZvci1rZXktcHJpbWFyeT90bXBsPW1hcmtkb3du) 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.152 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)