Error then we Force canonical URLs on listings at Use canonical URL and ..

-- HikaShop version -- : 4.4.1
-- Joomla version -- : 3.9.24
-- PHP version -- : 7.4.2
-- Browser(s) name and version -- : chrome 88.0.4324.96
-- Error-message(debug-mod must be tuned on) -- : 1062
Duplicate entry '33-50628' for key 'PRIMARY'

Hello,
Then we change the value from the to Force canonical URLs on listings
to Use canonical URL and generate it if missing
we get
1062
Duplicate entry '34-50628' for key 'PRIMARY'

do you know how i can fix it because i want the canonicals for the products
Thanks in advance

Hi,

I don't know. I'll need more information about the error to be able to answer.
First, please do this modification:
www.hikashop.com/support/forum/install-u...ror-1064.html#326783
And then activate the "error reporting" and "debug mode" settings of the Joomla configuration.
Finally, access that page with the error again and do a screenshot of the error area with the call stack and the MySQL query.
That will allow us to understand what's going on and provide an answer.

Thanks for Your help
i find the problem is the sytem plugin Smart Search - HikaShop Products with type of finder then the plugin is unpublished evrythink works fine

Hi,

This looks like a bug in the smart search system of Joomla.
It's trying to add an entry to the finder_links_terms0 table while that enrty already exists and the table structure forbids this.
There should either be a check in com_finder to not do the insert if the entry is already there, or change the "INSERT INTO" to a "INSERT IGNORE INTO" so that the MySQL query would not fail if the data would already be there.

Of course disabling the HikaShop finder plugin will "solve" the problem since it's this plugin which asks com_finder to reindex the product data. So when you disable it, there is no reindexing and thus no error.
Now I'm not familiar enough with the finder system to be able to say what should be done. But I think we can't do anything in HikaShop to avoid that error.

What you can try is to delete the entry with the link_id 37 and with the term_id 50628 in the table finder_links_terms0 via your phpmyadmin. That way, that query won't fail and hopefully it should work fine.