Hi Mark,
I think we have the instance of the rogue matches we had a couple of weeks ago. I have only one instance of Australia playing India in a T20 international at the SCG but it is appearing twice in the stats.
It is CA match ID 861767, but showing as CS matches 454263 and 473112. 473112 looks like it is from my database but not sure where 454263 is coming from. It is affecting other matches as well I believe.
Could it be picking up matches from two different databases again like the previous issue we had.
Looks great now, thanks for the help.
OK all done. Can you check your player stats and confirm they look perfect again now?
Actually, it looks like it is just exactly the same as last time but it happened before I fixed the problem with the import.
So given this other user's old database is abandoned, I am just going to blow it away completely. It should then remove all their matches (which erroneously have some matches that contain YOUR players).
I will let you know when it is done and get you to check your data afterwards. Standby (I need breakfast first).
Thanks for the detail. Don't do anything with these for a moment while I investigate.
I definitely closed off this problem last time so it will be matches that were imported prior to this getting closed.
My theory - it is the opposite effect to what you had last time. But let me verify and then we can fix.