1062 Duplicate entry 'il2-*' for key 'nabo_finder_terms.idx_term_language'

  • Posts: 17
  • Thank you received: 1
  • Hikamarket Multivendor Hikashop Style
9 months 1 week ago #359811

-- url of the page with the problem -- : nanobodylife.net/en/product-center-en/na...lass/product/88-il-2
-- HikaShop version -- : 5.0.3
-- Joomla version -- : 5.0.3
-- PHP version -- : 8.3.3
-- Browser(s) name and version -- : Safari,17.2.1
-- Error-message(debug-mod must be tuned on) -- : 1062 Duplicate entry 'il2-*' for key 'nabo_finder_terms.idx_term_language'

Hi,
Joomla's backend is throwing an error '1062 Duplicate entry 'il2-*' for key 'nabo_finder_terms.idx_term_language' every time I modify a product in HikaShop.

However, after disabling the 'Smart Search - HikaShop Products' plugin, no error is found.



Could you advise on how to fix this issue, please?

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

  • Posts: 83022
  • Thank you received: 13403
  • MODERATOR
9 months 1 week ago #359812

Hi,

Open the table finder_terms via your PHPMyAdmin and look for an entry with the value "il2" in the "term" column, and the value "*" in the "language" column. Delete it.
That should hopefully help.

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

  • Posts: 17
  • Thank you received: 1
  • Hikamarket Multivendor Hikashop Style
9 months 6 days ago #359825

Hi,
I ran the query:
SELECT *
FROM nblst.nabo_finder_terms
WHERE term = 'il2' AND language = '*';

in the database, but it did not return any results.

I tried also to run:
SELECT *
FROM nblst.nabo_finder_terms
WHERE TRIM(term) = 'il2' AND TRIM(language) = '*';


The problem persists. "An error has occurred.
1062 Duplicate entry 'il2-*' for key 'nabo_finder_terms.idx_term_language'"

What further steps do you advise to resolve this issue?

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

  • Posts: 83022
  • Thank you received: 13403
  • MODERATOR
9 months 4 days ago #359840

Hi,

Then, go in the Smart Search Index page, and use the Maintenance -> clear index button to remove the whole index.
Then, on that same page, click on the "index" button to completely recreate the whole index.
It should hopefully help.

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

Time to create page: 0.056 seconds
Powered by Kunena Forum