Topic on User talk:Hjfocs

[soweego 1] Twitter

Please clean up the dozens of constraint violations shown up on Wikidata:Database reports/Complex constraint violations/P2002. I spent hours to clean up the previous ones and I’m really unhappy when a bot comes and ruins my work.

Hey @Tacsipacsi, thanks a lot for your feedback and apologies for the trouble, I didn't mean to interfere with your work at all! FYI, the edits you mention come from a QuickStatements batch upload, which seems to silently ignore potential duplicate statements differing only in case. I'm gonna fix this very soon.

Thanks! I might have been a bit more upset than you deserve, because this is not the first such case (I mean overall, I don’t remember names from previous cases). It seems logical for me that QS doesn’t check for such semi-duplicates, as most things are case-sensitive, Twitter user names being an exception (and not the standard): external identifiers, image names, work titles and so on are usually case-sensitive.

Soweego bot (talk • contribs • logs) is on its way to delete the whole Twitter batch holding these errors. It will then put them back in a case-insensitive fashion.

I hope it will finish soon, as sometimes the two runs managed to remove pre-existing Twitter user names, e.g. here. Next time probably it will be better to use EditGroups’s revert feature.

I didn't know that tool, so I opted for a bot deletion. I've now stopped the bot. Thanks a lot for pointing that out!

Sorry, but the current database state is the worst, as inconsistent as possible. Some items (like the above-cited) have all statements removed without replacement, while others (e.g. Q29315) still have doubled ones. As far as I see, now the only option is to finish the removal and than re-add the correct statements.

I totally agree, but Jura1 (talk • contribs • logs) decided to ask for a bot block, which was later reverted, although I didn't get the notification by e-mail. See Wikidata:Administrators'_noticeboard#Bot_running_amok?. I'll do my best to take care of this very soon.