[13:37:51] <godog>	 hi, I saw a bounce for Brooke's email on VO pages, I'm assuming it is safe to clean up the user/contact ?
[13:42:24] <godog>	 I'm talking about 'bstorm-email' specifically in icinga group 'sms'
[13:42:53] <dcaro>	 should be yes, though I'll let balloons confirm
[13:43:40] <godog>	 ack, thanks dcaro !
[13:46:21] <godog>	 https://gerrit.wikimedia.org/r/c/operations/puppet/+/742723 the minimal patch for production contactgroups
[13:48:49] <balloons>	 Yes definitely feel free to clean up any remnants of Brooke's wmf email. It's no longer valid
[13:48:59] <godog>	 ack, thanks balloons 
[13:49:06] <godog>	 and arturo for the review
[13:49:15] <wm-bb>	 <lucaswerkmeister> oh :(
[13:49:26] <arturo>	 anytime :-)
[15:35:26] <bd808>	 @lucaswerkmeister: yeah, :(( Brooke moved on to a position at DigitalOcean about 6 weeks ago
[15:36:26] <Lucas_WMDE>	 that’s sad to hear but good to know, thank you
[16:08:32] <rdrg109>	 [Q] I have written this query in Quarry: https://quarry.wmcloud.org/query/60254 . According to the results, the wikis with title PERUVIANTERRA and DGAC.PERU has length 5132 and 2144, respectively. However, when I visit those articles in Wikipedia Spanish, I see that those articles are empty: PERUVIANTERRA ( https://w.wiki/4Uae ) and DGAC.PERU ( https://w.wiki/4Uah ). Could anybody explain
[16:08:34] <rdrg109>	 what is happening?
[16:10:02] <wm-bb>	 <lucaswerkmeister> the first one is this page https://es.wikipedia.org/w/index.php?curid=8822753
[16:10:08] <majavah>	 can you add page_namespace to the results too?
[16:10:16] <wm-bb>	 <lucaswerkmeister> it’s actually a user talk page (you probably want to either filter by page_namespace or add it to the SELECT)
[16:15:37] <rdrg109>	 I should have tought on that (page_namespace). Thanks for the help!
[16:17:26] <rdrg109>	 thought*
[17:35:57] <rdrg109>	 [Q] Is there any graphic/image showing the database layout of the tables that can be queried at Quarry? I have found https://w.wiki/4BF5 , but apparently that graphic shows the databasse internally used by Quarry instead of the information I'm referring to.
[17:41:05] <rdrg109>	 I got it wrong. https://w.wiki/4BF5 shows what I'm asking but it is not complete. For example, wb_items_per_site is a table that exists in wikidatawiki_p, but it is not shown in that image.
[17:41:12] <wm-bb>	 <jeremy_b> rdg109: https://quarry.wmcloud.org/query/60269
[17:42:04] <rdrg109>	 jeremy_b: Thanks!
[17:42:31] <majavah>	 rdrg109: that picture is a bit old (it's from 2017), it also shows only tables from mediawiki core and not extensions like Wikibase (which creates wb_items_per_site)
[17:43:18] <wm-bb>	 <jeremy_b> mine should be always up to date :)
[17:43:42] <rdrg109>	 majavah: Ok! I think I'm good with what jeremy_b showed me: "SHOW TABLES"
[17:44:42] <wm-bb>	 <jeremy_b> I imagine you could automate generating the graphical version as a tool labs tool.
[17:45:14] <majavah>	 s/tool labs/toolforge/, thanks
[17:45:31] <wm-bb>	 <jeremy_b> you're dating me!
[17:45:36] <wm-bb>	 <jeremy_b> sorry :)
[17:46:02] <majavah>	 sorry :P
[17:47:12] <wm-bb>	 <jeremy_b> it's amazing to think labs is over 9 years old. (I'm just thinking it existed in DC. I don't remember for sure about Haifa)
[18:10:16] <bd808>	 @jeremy_b: The Cloud VPS project here started a bit over 10 years ago -- https://www.mediawiki.org/wiki/Wikimedia_Labs -- and Toolforge started in early 2013 as the logical successor to Toolserver which started in 2005 :)
[19:39:18] <Guest80>	 hi
[19:40:37] <wm-bb>	 <jeremy_b> if you have an actual question don't wait for someone to ask what it is
[20:54:45] <bd808>	 !log toolhub Updating demo server to 7dcdbc7
[20:54:47] <stashbot>	 Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Toolhub/SAL
[22:29:22] <rdrg109>	 [Q] I have written this query for listing wikis containing "Emacs" in their names: https://quarry.wmcloud.org/query/60263 . I have noticed that some articles have space replaced with "_" (apparently, they are URL encoded). Is there any way I canget the title of those wikis without them being encoded.
[22:30:55] <wm-bb>	 <lucaswerkmeister> *all* pages have their title with underscores instead of spaces in the database, as far as I’m aware
[22:31:50] <wm-bb>	 <lucaswerkmeister> if you want the version with spaces I assume you can do REPLACE(page_title, '_', ' ')
[22:32:08] <mutante>	 https://en.wikipedia.org/wiki/Wikipedia:Page_name#Spaces,_underscores,_and_character_encoding
[22:32:35] <mutante>	 rdrg109: ^ "In page names, a blank space is equivalent to an underscore. " what he said
[22:36:40] <mutante>	 rdrg109: curl https://quarry.wmcloud.org/run/597083/output/0/wikitable | cut -d\| -f6 | sed 's/_/ /g'
[23:14:08] <wm-bot>	 !log tools.pbbot <peterbowman> Unbreak <references> in pretty-ref
[23:14:11] <stashbot>	 Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.pbbot/SAL
[23:35:31] <rdrg109>	 I was asking because 
[23:41:31] <rdrg109>	 in wb_items_per_site (as can be seen here https://quarry.wmcloud.org/query/60263), the space is not replaced with "_" and I want to compare the values of the column "page_titles" from the table "page" from the "eswiki_p" database (space replaced with "_") with the values of the column "ips_site_page" of the table "wb_items_per_site" of the database "wikidatawiki_p" (spaces not replaced
[23:41:33] <rdrg109>	 with "_").
[23:43:13] <bd808>	 !log toolhub Updating demo server to 9866f91
[23:43:15] <stashbot>	 Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Toolhub/SAL
[23:45:08] <rdrg109>	 I guess before comparing "page_title" with "ips_site_page", I need to replace the underscore with spaces in "page_title". However, I wonder that's safe to do since there can be "page_title"s with underscores in them.
[23:45:59] <mutante>	 rdrg109: if you want to do the replace inside the SQL query you can do that too, with REPLACE(page_title, '_', ' ') or so.  https://www.mysqltutorial.org/mysql-string-replace-function.aspx
[23:48:24] <mutante>	 SELECT REPLACE ('page_title', '_', ' ') AS my_page_title, ...