[06:37:48] Hello! Can someone tell me where I can find the sources for the `mediawiki-jobrunner` docker image (e.g. https://docker-registry.wikimedia.org/dev/buster-php80-jobrunner/tags/) [11:49:31] getting back to my questions yesterday, I can't get the files to appear in bulk. A manual purge works, but that is unhandy [11:49:49] waiting a day didn't help [13:31:28] Good news! I have identified the problem I came here about earlier this week. I even know how to fix it! Just genuinely hoping there's an easy way to find the users that need fixing. Is there any easy way to filter users to show usernames that don't follow the MW standardized capitalization? I've got a large number of users and I really would much [13:31:28] rather not attempt to combine regex and SQL [13:56:05] Ulfr: something like select * from user where user_name <> concat(upper(substring(user_name, 1, 1), substring(user_name, 2)) [13:58:19] Vulpix: I got some results from this, but I feel like it's not nearly enough: select cast(user_name as CHAR) from user where `user_email` REGEXP BINARY '[A-Z]'; [13:59:31] user_name and user_email are synonymous [14:00:12] you might have to convert the character type for non-ascii characters [14:00:35] I suspect by default the case conversion in sql is not unicode aware (Just a guess, i don't actually know if that's true) [14:01:16] at least not unless you case to utf8mb4 [14:01:19] *cast [14:01:33] probably same thing with substring() if its working on a binary field [14:04:19] The only way I've managed to get results this far is checking the binary and then casting what gets returned so I can read it. I didn't think non-ASCII characters were allowed in email addresses [14:06:41] So they are allowed, however its relatively new, so many email providers do not allow them [14:07:09] I guess in practise if you are using email addresses, then its unlikely unicode is much of an issue since that is so rare [14:07:48] At this point I would consider 90% resolution rate close enough for a Friday [14:28:43] OK! Close enough. Thank you very much Vulpix and bawolff! [15:45:32] ok, to come back to my import problems, I managed to solve it by disabling caching till ready with the setup