Background:

Laura San Giacomo is credited for Stephen King's The Stand as first name "Laura," middle name "San," last name, "Giacomo."

Obviously, her last name is "San Giacomo" and that's how she's credited everywhere else I can find (Sex, Lies, and Videotape; Pretty Woman; Suicide Kings, etc.), meaning I have two records for the same actor, one correct, one incorrect.

The name is obviously spelled the same in both records, just with San in the middle name for one, and as part of the last name for the other.

So I updated the profile, replacing the incorrect profile with the correct one. When I try to submit the corrected profile, the database says that it has not detected any changes. (Note, I refreshed the profile before I modified it, so the most current profile for this title has the wrong actor record). Apparently, the contribution system can't tell the difference between:

Laura San Giacomo

...and...

Laura  San  Giacomo

Quoting Addicted2DVD:

Quote:
This is something to just fix in your local as the online won't see the difference.

It can tell the difference when I refresh the profile. DVDP replaces the correct profile with the incorrect one.

However, after I ran the database cleaner and remove any unused cast profiles, this doesn't happen, so it's only a problem if both cast records are still in your local database.

So I guess the trick is to clean your data periodically.