[01:06:37] meta question: is this the channel for bot discussions or is there a better one? [01:09:22] or API discussions? [01:48:54] audiodude, It's a good enough place to start [01:51:05] #mediawiki is also a good place for API-related discussion [02:02:37] cool then on to my actual question: What is the login timeout for BotPassword sessions (https://www.mediawiki.org/wiki/Manual:Bot_passwords) [02:02:50] on english Wikipedia [02:03:49] also in the time since I was motivated to ask my meta question, I've kind of given up on my idea of a "long running" session and maybe have given in to just restarting my workers when the cron job runs [03:29:11] Anyone around that can disable https://phabricator.wikimedia.org/p/marilerr/ for vandalism? [03:38:19] It has been done, JJMC89[m] [03:38:23] (not by me :P) [03:38:51] I see [03:39:01] Thanks to whoever took care of it [03:39:42] ;) [15:59:07] where in the database can I find the title of a page when it was created? [15:59:16] or the title before a particular move [18:03:42] ksft: For that, you have to query logging table, to find how (if) was page moved [18:39:09] Urbanecm: where can I find the old title? [18:52:55] ksft: encoded in log_params [18:53:00] let me create an exampl [18:53:26] https://www.irccloud.com/pastebin/urBaJASz/ [18:54:47] in this example, I moved page "Testing page" (log_title) to "Testing page 2" (parameter target encoded in log_params) [18:55:34] oh, so the old title is right in logging.log_title? [18:55:50] ah, old title, yes, that's in logging.log_title [19:02:13] JJMC89[m]: I've added you to acl*userdisable, which means you can disable Phabricator users via https://tools.wmflabs.org/phab-ban/ yourself ;) [19:03:08] Thanks Urbanecm! [19:03:23] you're welcome! [19:32:23] and where's the new namespace? [22:23:14] ksft: you can find the current namespace (usually, new one, but not necessarily if page is moved multiple times) when joining logging and page on page_id=log_page [23:03:07] ah, of course [23:03:57] er, actually, the target title might be more useful for me than the current title [23:27:32] on Quarry, my query says "Query status: running" but below that "Hmm... Is the SQL actually running?!" [23:28:24] ksft: seems to be working, https://quarry.wmflabs.org/query/38556 [23:29:05] might asl in -cloud tho about that error when you hit explain [23:38:22] oh, so it did! [23:38:28] just took a while, I guess