After re-organizing our categories, we were surprized to find a large number of duplicates that could not be discovered by the Check Duplicates function.

We soon realized that the duplicates were not in the Links table but in CatLinks -- most links having multiple identical records. It was easy to fix using raw MySQL, but we think it would be better if a Control Panel fix could be built into the next release.

Hi,

By duplicates do you mean a link being in one or more categories? Do you just want to see a summary of all links that are in multiple categories?

Cheers,

Alex
--
Gossamer Threads Inc.

No - I mean an unduplicated link (ie: just one record in the links table) appearing more than once in the same category.

No - I would like to remove duplicates (ie: identical rows) in the CatLinks table. Of course, a summary would be useful in many ways.

Here is how you know something has gone wrong:
* You are in Admin > Browse
* You see the same link repeated within a single category
* You use Database > Check Duplicates to remove the surplus links
* Check Duplicates returns with "Your search returned 0 links"

Maybe there should be some internal check that each row of table CatLinks is unique.
We expect this ...
19 123
19 128
19 261
... etc

We don't expect this ...
19 123
19 123
19 123
19 123
... but it's what we got.