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

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

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.

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?

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.