Hi Mark,
Weird one. Three matches that are importing but won't allow the match report to be shown.
Match IDs - 305595, 434897, 492342
No other matches affected as I have tried matches before and after the IDs
When importing it shows when trying to show the match report
All matches are at Rajiv Gandhi International Stadium, Uppal, Hyderabad.
The matches are Tests, don't show up on overall Test Runs Reports, but do show up on the individual report when filtered for just Tests.
Are you sure these are your matches?
OK I think I worked out the problem.
Can you re-import them again now and try it? (Expect a different match ID to appear)
Sorry the Match IDs refer to the CA Match ID.
They import ok, but when I try and find them in the list of matches, they also don't appear for some reason.
The match ID is 462162 for CA492342 match
OK re-import it now anyway.
When you say they "show up on the individual report when filtered for just Tests"
Is this the player pages?
Yes it is, the player pages. It imports fine now, comes up as a new match, previously had come up as importing an existing match.
The matches now come up on the overall
But looking at Tendulkar, he now comes up with three extra matches (which would have been the three which I imported just now). No difference in the filters, etc
I will get this cleaned up. Standby
OK Can you look at that player report again and confirm it is all fixed?
And while we wait for you to verify, I will explain what happened.
Some time back I put in that extra code to allow you to import two matches played on the same day. This involved storing the CA Match ID in a hidden field for each match imported.
The checking routine was looking for the CA Match ID field but neglected to check that it was also the same database ID.
Coincidently, another user with another database had previously imported these 3 matches from CA. So when you went and did it, the system thought it had found a match and proceeded to import your players/teams/grounds/grades but then over-wrote the match that already existed in the system (in the other user's database). This was why you were getting a match ID from someone else's database.
Fortunately this other database had expired so no real harm done there.
I then fixed this problem, you re-imported the match and it finally dropped the match in to your database - but the player pages weren't doing a database check as such to limit matches tagged to your database. Hence it was double counting these three matches.
So I fixed this by deleting the 3 matches in the other, abandoned database.
Thanks Mark. It all works now. I only noticed when doing a cross check on Tendulkar's career. It took some investigative work to find out which matches they were but eventually found them.
Great and sorry that you wasted some time chasing this one. It was a really strange one.
I am glad that it was only 3 matches.