Help with error 1062

Hi,
i get an error when i try to open a few CP menus from the backend, (6 out of 9 cp menus. Could you please point me to the right direction on how to resolve this? Thank you

1062 Duplicate entry 'index.php?option=com_customproperties&view=search&tagId=4&bind_t' for key 'PRIMARY' SQL=INSERT INTO kho5r_betterpreview_sefs (`url`) VALUES ('index.php?option=com_customproperties&view=search&tagId=4&bind_to_category[0]=content:11&bind_to_category[1]=content:28&bind_to_category[2]=content:50&bind_to_category[3]=content:56&bind_to_category[4]=content:63&bind_to_category[5]=content:68&bind_to_category[6]=content:73&bind_to_category[7]=content:74&bind_to_category[8]=content:81&bind_to_category[9]=content:85&bind_to_category[10]=content:89&bind_to_category[11]=content:96&bind_to_category[12]=content:100&bind_to_category[13]=content:106&bind_to_category[14]=content:110&bind_to_category[15]=content:114&bind_to_category[16]=content:121&bind_to_category[17]=content:128&bind_to_category[18]=content:135&bind_to_category[19]=content:139&bind_to_category[20]=content:143&bind_to_category[21]=content:148&Itemid=559'),('')

The SQL error is thrown by betterpreview_sefs. I can't tell why that's happening. I can only *guess* that there are some identical menu items and that betterpreview does not like it. But that's just my speculation.

Thank you for replying

All my menus have different alias.

What exactly is the betterpreview_sef? Is it the pluggin that makes the urls search engine friendly?

I think i will check all entries at the database in the betterpreview_sef to check for duplicates. Thank you for the help

"betterpreview" is unrelated to Custom Properties. The error shows the issue is not with menu alias, but with the actual URL the menu item is pointing to.

Assuming that betterpreview is indeed the first Joomla extension listed in Google results when searching with that term, the "sef" part could be relative to its 'Extra url info' feature.

Solution

The problem was the "Bind to categories" selections i had made in menus CP layout.

Some articles were tagged with the specific menu tag but were in other categories which i did't include in the list of "bind to categories" in the CP menu.

Deleted the menus, made new ones without addind categories to "bind to categories" and no problem now.

Thank you very much for the help.

Glad you solved the problem and even more so that you found the time to post the solution on this forum.

As a side note: most of the times category binding is not required at all. It's only justified when you have exactly the same tags assigned to items belonging to different categories, and you want to keep the relevant search modules separated.