User talk:SQL/AIVAnalysis

Renames

 * Bot does not follow renames. SQL Query me!  22:37, 5 December 2017 (UTC)
 * - And now it does! SQL Query me!  03:02, 6 December 2017 (UTC)
 * This has returned with the webtool. Queries against logging_userindex are relatively expensive timewise. I may need to write a caching function so at least we only have to experience them once. SQL Query me!  23:56, 23 December 2017 (UTC)

Oversighted log entries

 * Users with oversighted block log entries show up as not blocked. There is no way that I am aware of to get around this. SQL Query me!  22:27, 5 December 2017 (UTC)
 * I have an ugly / hackish workaround for this. Screen-scraping "https://en.wikipedia.org/w/index.php?title=Special:Contributions/" . $username . "&offset=&&limit=1" for "This account is currently blocked" seems to work. These blocks do not show up in API:Blocks, Special:IPBlocklist, nor the Block log - so this was a truly last resort. Running a test case (72's had a few of these) now to confirm. SQL Query me!  01:23, 6 December 2017 (UTC)
 * - guess it wasn't a can'tfix after all! SQL Query me!  01:54, 6 December 2017 (UTC)
 * This issue has returned with the webtool. I probably need to check the ipblocks table in addition to logging. SQL Query me!  23:56, 23 December 2017 (UTC)

Rangeblocks

 * Bot should check to see if the IP is under a rangeblock. SQL Query me!  22:37, 5 December 2017 (UTC)
 * Anyone have a good way to check for this via the API or maybe a screen scrape? SQL Query me!  01:30, 6 December 2017 (UTC)

Typos

 * This report contained a typo; it was corrected a moment later by me, and the account was blocked a few minutes later. It's understandable why your tool didn't pick it up, but maybe a check against case sensitivity if the account tagged at AIV isn't registered?
 * This one shows as a never been blocked, but was again a typo. The actual account name was corrected by another editor. This time, I inadvertently left the "e" on the end of "username" in when I selected "usernam" (minus the trailing 'e') for replacing the username. No idea how to account for a typo like that :/ Leave it to a human to really mess things up.
 * This one is a special case; I made this request when that account was already blocked; I was asking for a change in the block settings. The bot immediately removed the request, so I then made this request with an intentionally wrong username (adding 'NNN' to the end) so the bot wouldn't immediately remove it. The change in block settings I requested was done.

Undefined Index

 * Occasional "Undefined Index: Compare" on line 53. Need to add a trap to that and see why. SQL Query me!  01:26, 6 December 2017 (UTC)
 * with the webtool. SQL Query me!  23:56, 23 December 2017 (UTC)

Default username

 * This one was just a typo done by accidentally copy/pasting per the instructions and not changing "username". Maybe it could ignore "username" as an account name as that is obviously in error. This request immediately preceded the above request, and was done in error. The same text for a request appeared in the next AIV report I made, albeit with the proper username put in.
 * Bot now discards the username "username". SQL Query me!  21:44, 5 December 2017 (UTC)

1= bug

 * This report resulted in a block of the account. I don't know why your tool didn't pick it up.
 * This report resulted in this block. Again, I don't know why your tool didn't pick it up. There was a global lock too; maybe that threw it?
 * This report resulted in block. I don't know why your tool didn't find it.
 * The template was used with the 1= parameter - I did not think to check for this.  SQL Query me!  21:54, 5 December 2017 (UTC)
 * SQL Query me! 21:59, 5 December 2017 (UTC)

Block timing

 * At the moment, the script does not check to see WHEN the block happened, just IF it did. At some point, I will probably refactor it to see if the user was blocked within 24 hours of the AIV report. SQL Query me!  22:40, 5 December 2017 (UTC)
 * Now that we've moved to a web-based tool, this seems to be  SQL Query me!  23:56, 23 December 2017 (UTC)

Adding reports from other users

 * If a user re-adds a report from another user (accidentally removed / etc), it does count against that user. For the moment this can't be fixed because doing so would not count edits made by renamed users. SQL <sup style="font-size: 5pt;color:#999">Query me!  22:36, 5 December 2017 (UTC)

Keywords

 * Count certain keywords used in reports. I was thinking possibly (feedback would be greatly appreciated!):
 * sock, sockpuppet
 * block evaision
 * promotional
 * username
 * edit warring
 * vandalism
 * Not sure what other phrases should be counted, or even if they should be. SQL <sup style="font-size: 5pt;color:#999">Query me!  22:44, 5 December 2017 (UTC)
 * Per feedback on my talkpage - when used as a webapp, allowing user-configurable (maybe regex, maybe substr-ish) fields for keywords would be the way to go SQL <sup style="font-size: 5pt;color:#999">Query me!  23:37, 5 December 2017 (UTC)

0MQ

 * Use 0MQ to spawn 5-10 worker clients to speed up the queries, respecting maxlag=3 or possibly lower. Currently, maxlag is set to 4. SQL <sup style="font-size: 5pt;color:#999">Query me!  01:24, 6 December 2017 (UTC)
 * 90 lines of code in so far. SQL <sup style="font-size: 5pt;color:#999">Query me!  03:49, 7 December 2017 (UTC)
 * - no longer needed. SQL <sup style="font-size: 5pt;color:#999">Query me!  23:56, 23 December 2017 (UTC)