[04:54:41] <Ishidez>	 hola alvaro molina
[08:00:02] <sjoerddebruin>	 Why we need a better suggester. https://www.wikidata.org/w/index.php?title=Q27078358&oldid=383660087
[08:24:11] <hoo>	 +1
[11:49:23] <sjoerddebruin>	 Seems like Google is picking up our descriptions now. :) https://www.google.nl/search?q=steve+jobs+site%3Awikidata.org
[14:12:42] <hoo>	 sjoerddebruin: https://phabricator.wikimedia.org/T142986
[14:12:52] <hoo>	 Do you have any further hints on how to reproduce this?
[14:13:15] <sjoerddebruin>	 Not really. It happens at moments.
[14:14:21] <hoo>	 :/
[14:17:35] <sjoerddebruin>	 I don't see it so often anymore though.
[14:37:07] <hoo>	 hm… maybe we should close/ stall the bug for now :/
[15:57:55] <hoo>	 aude: Would be nice if you could review https://gerrit.wikimedia.org/r/313976
[15:58:04] <hoo>	 first step towards new parser function/ lua function
[17:16:56] <sjoerddebruin>	 SMalyshev: what about earlier deletions?
[17:17:14] <SMalyshev>	 sjoerddebruin: what about them?
[17:17:35] * SMalyshev missing context
[17:17:38] <sjoerddebruin>	 Regarding https://phabricator.wikimedia.org/T136393#2689231, will they stil show up?
[17:21:00] <SMalyshev>	 sjoerddebruin: yes they should. I've updated the deletes for a month back  (don't have the logs before that)
[17:22:43] <sjoerddebruin>	 I think I saw a deletion yesterday from May this year, so we should report them if they are older than one month ago?
[17:34:22] <SMalyshev>	 sjoerddebruin: yes
[17:34:40] <SMalyshev>	 old ones are from different bugs :)
[17:34:43] <sjoerddebruin>	 Okay, I know enough then. :)
[17:35:29] <Josve05a>	 Let's start using Flow on normal Item talkpages as well!
[17:35:58] <sjoerddebruin>	 If it only was in active development.
[17:36:08] <Josve05a>	 :/
[17:36:22] <Josve05a>	 Trizek: ^^
[17:36:50] <sjoerddebruin>	 I loved the mockup of Wikidata where there was a section of "Recent talk page discussions" on a item, so it was more prominent.
[17:39:21] <Josve05a>	 This is gonna take me forever to add these! http://tinyurl.com/zcj8dg5
[17:44:57] <Josve05a>	 sjoerddebruin: Do you know how to code and set up how a statement constraint (allowable values)?
[17:45:05] <sjoerddebruin>	 Yes.
[17:45:35] <Josve05a>	 Could you please help me?
[17:45:58] <Josve05a>	 [[Property:P3222]]: First letter must be a lower captial letter (or a number) AND Only allow letters (including e.g å, ä, ö), dashes ( - ), and numbers [0-9]
[17:45:59] <AsimovBot>	 10[4] 10https://www.wikidata.org/wiki/Property:P3222
[17:46:23] <Josve05a>	 (lower case*)
[17:46:43] <sjoerddebruin>	 Oh, that's something else that "allowable values". You're talking about regex.
[17:46:49] <Josve05a>	 oh
[17:46:58] <sjoerddebruin>	 I'm not great in regex.
[17:47:00] <Josve05a>	 in that case, I'm asking about regex
[17:47:05] <Josve05a>	 :/
[17:47:47] <WikidataFacts>	 what is a lower capital letter?
[17:49:20] <Josve05a>	 lower case letter*
[17:49:25] <WikidataFacts>	 oh, okay
[17:49:27] <Josve05a>	 a-z, not A-Z
[17:50:55] <WikidataFacts>	 in that case, that could be [\p{Ll}\p{Nd}][\p{L}\p{Nd}-]*
[17:51:07] <WikidataFacts>	 depending on the regex flavor – I think that one’s Java
[17:57:03] <nikki>	 based on the current values, [a-z0-9äöå][a-z0-9äöå()-]* would work, depends really whether you expect lots of unusual letters or if the non-ascii ones are fairly limited (in which case catching unlikely ones might be helpful)
[17:58:10] <Josve05a>	 no, I only belive that a-z+å-ö will be present (Swedish) (and numbers)...and according to http://regexr.com/ that ^seems to work nikki :D
[18:04:34] <Josve05a>	 Thanks!
[18:11:43] <nikki>	 :)
[18:20:51] <multichill>	 SMalyshev: Do deprecated results show up in SPARQL queries by default?
[18:21:01] <sjoerddebruin>	 Depends on your query.
[18:21:36] <SMalyshev>	 right :)
[18:21:51] <multichill>	 This beauty: http://tinyurl.com/znju9tr
[18:21:56] <WikidataFacts>	 wdt: never includes deprecated rank (and excludes normal rank too when preferred rank statements exist)
[18:22:57] <multichill>	 Right, so probably because I use the p:Pxxx in some of the unions, I get the deprecated stuff
[18:23:16] <multichill>	 Oh, right, that should have been wdt:
[18:23:59] <SMalyshev>	 multichill: p: gets deprecated, wdt: doesn't
[18:24:15] <SMalyshev>	 you can exclude deprecated manually from p: with FILTER of course
[18:24:25] <SMalyshev>	 or use BestRank
[18:24:39] <multichill>	 I just replaced the ?item p:P650 [] . with ?item wdt:P650 [] .
[18:24:45] <multichill>	 I didn't need the p: there.
[18:24:51] <multichill>	 Not sure how that got in there
[18:25:46] <multichill>	 https://www.wikidata.org/w/index.php?title=Property_talk%3AP650&action=historysubmit&type=revision&diff=383743669&oldid=382915295
[18:35:41] <multichill>	 I notice the whole research discussion SMalyshev. Did you already have a look at the user-agent log if it contained anything useful?
[18:36:55] <SMalyshev>	 multichill: depends on what you call "look". I check it sometimes but not systematically, but we have systematic research going on right now:  https://meta.wikimedia.org/wiki/Research:Understanding_Wikidata_Queries
[18:38:56] <multichill>	 WIth the analytics stack it should be almost trivial to get the top 10 user-agents. Did you pull that out SMalyshev?
[18:39:50] <SMalyshev>	 multichill: I didn't, but some time ago Mikhail did some analysis, let me see
[18:41:04] <multichill>	 leila is really fast with that!
[18:45:49] <SMalyshev>	 multichill: this: https://phabricator.wikimedia.org/F2682919 is from a year ago
[19:07:07] <multichill>	 nice, but that's before you implemented pywikibot support I think. Since then a lot of bots were switched over 
[19:33:56] <WikidataFacts>	 by the way sjoerddebruin, I’m now running that esperanto family labels bot again, and this time it seems to work without errors (finally)
[19:34:05] <sjoerddebruin>	 \o/
[19:43:30] <SMalyshev>	 multichill: see this also: https://commons.wikimedia.org/wiki/File:Exploration_on_the_Use_of_WDQS_-_Breakdown_by_Geography,_User_Agent_and_Referer_Class.pdf
[19:43:42] <SMalyshev>	 brand new
[20:17:31] <multichill>	 nice SMalyshev
[20:21:25] <sjoerddebruin>	 woah, the order of the qualifier suggestions for alma mater changed :O
[21:01:58] <paladox>	 hoo hi, for https://gerrit.wikimedia.org/r/#/c/314169/ a workaround is to copy it over to a new table choosing which tables to copy over
[21:02:06] <hoo>	 Sure
[21:02:17] <hoo>	 but the new table wont have the indices
[21:02:20] <paladox>	 Oh
[21:02:25] <paladox>	 What are indices?
[21:03:03] <hoo>	 You also drop the primary key
[21:03:08] <paladox>	 Oh
[21:05:00] <hoo>	 You want the new table to have the definition in client/sql/entity_usage.sql
[21:05:09] <paladox>	 hoo what about doing http://stackoverflow.com/questions/5938048/delete-column-from-sqlite-table (bottom but the one on top of the bottom)?
[21:05:15] <paladox>	 Create a new table directly with the following query:
[21:05:20] <paladox>	 Now insert the data into table_name from Existing_table with the following query:
[21:05:28] <paladox>	 Now drop the Existing_table by following query:
[21:05:34] <paladox>	 I guess i already do that now
[21:05:51] <hoo>	 yeah
[21:06:43] <paladox>	 But i thought that
[21:06:43] <paladox>	 INSERT INTO wbc_entity_usage_backup SELECT eu_row_id,eu_entity_id,eu_aspect,eu_page_id FROM wbc_entity_usage;
[21:06:54] <paladox>	 would copy it from old table to back up one
[21:06:56] <paladox>	 hoo ^^
[21:07:47] <hoo>	 the question is not whether the data is copied over
[21:07:52] <hoo>	 but the schema of the new table
[21:07:55] <paladox>	 OH
[21:08:15] <hoo>	 In MediaWiki maintenance/sqlite/archives/ you can find various examples of such SQLite workarounds
[21:08:41] <paladox>	 ok7
[21:08:43] <paladox>	 ok
[21:08:44] <paladox>	 thanks
[21:09:18] <paladox>	 Ah
[21:14:16] <paladox>	 hoo done :)
[21:16:38] <hoo>	 It would be nice if you could test the patch
[21:18:20] <paladox>	 Oh, i doint use sqlite
[21:18:23] <paladox>	 Only mysql
[21:18:33] <paladox>	 hoo anyways i fixed your comments
[21:19:42] <hoo>	 hm
[21:19:59] <hoo>	 I'll try to take time to test that in the next couple of days
[21:20:08] <paladox>	 Ok thanks
[21:20:09] <paladox>	 :)
[21:20:51] <paladox>	 Bye, i will be in the other wikimedia channels manly -releng
[23:36:07] <Dereckson>	 Filled https://phabricator.wikimedia.org/T147381 
[23:36:08] <Dereckson>	 Importing 20161003_Panel_LA_Case_Study_HD.webm...Fatal error: Call to a member function getNamespace() on a non-object in /srv/mediawiki/php-1.28.0-wmf.20/extensions/Wikidata/extensions/Wikibase/client/includes/Hooks/BeforePageDisplayHandler.php on line 41
[23:36:30] <Dereckson>	 (it's a maintenance script to import images)