Site
Home / Forum / General Discussion / duplicated players

duplicated players


Posted: 22 Jun 2023 14:38
smudgie

Posts: 365
Joined: 2020

Been randomly looking through some of the various soccer leagues, the Featured Leagues seem to be ok but a lot of the lower leagues seem to be well out of date, players ,managers etc, and another problem seems to be duplicated players.
Example CD Nacional de Madeira, this seems to be one of the worst.
Any idea's why this is happening.

zag
Posted: 22 Jun 2023 16:17
curswine


Posts: 938
Joined: 2020

Probably a combination of people not searching before using the auto import, and adding players without their Ids.

And I imagine its especially bad with Portuguese/Spanish teams because the importer doesn't handle their naming conventions well, and also the use of nicknames.

Ovokx, smudgie
Posted: 22 Jun 2023 17:45
smudgie

Posts: 365
Joined: 2020

Taking CD Nacional de Madeira example, Abdullahi Alhassan appears 3 times, all with the exact same ids, so it seems something is not working correctly.

curswine, zag
Posted: 22 Jun 2023 18:51
curswine


Posts: 938
Joined: 2020

Oh wow, you're right, something has really gone wrong there.

All of them have the same date of birth too... https://www.thesportsdb.com/api/v1/json/3/searchplayers.php?p=Abdullahi%20Alhassan

I've no explanation for that at all. I would've expected the duplicate checked to have picked those up before being allowed to add them.

Posted: 22 Jun 2023 19:32
smudgie

Posts: 365
Joined: 2020

cheers Curswine, afraid its beyond me, maybe Zag will get to the bottom of it.

Posted: 23 Jun 2023 13:11

zag


Posts: 3,515
Joined: 2020

Yes i've seen this before, it happens when someone syncs the entire team, before I wrote some logic dupe checks.

I will check the code, but in the mean time its fine to delete any dupes. I did a load in MLS as well and they have not come back.

EDIT: Just did a whole DB search and there are about 250 player dupes on the entire site. Actually not too bad

Posted: 23 Jun 2023 14:13

zag


Posts: 3,515
Joined: 2020

I've just done a clean up of 250 player dupes. Most in the Portuguese league as that's what I must have tested with when I first wrote the importers.

If you find any more, please delete as they shouldn't come back now we have proper import checking.


Who is Online?

In total there are 68 users online :: 3 registered, 0 hidden and 65 guests (based on users active over the past 5 minutes) Most users ever online was 424 on Fri Nov 10, 2017 9:02 pm

About Us

Discussion forum for TheSportsDB.com site and related topics

Rules

- Be Polite
- Respect other users
- Always post log files with issues
- Try to be helpful
- No Piracy discussion

Showing 0 to 7 (Total: 7)