[12:54:48] <aliceisdinah>	 Hello, I experience some issue wiht my mediawiki installation, after the installation and creation of LocalSettings.php, that I moved in the /var/lib/mediawiki, i try to connect to my localhost: localhost/mediawiki, but nothing happens... Before the wiki works well...
[12:55:10] <aliceisdinah>	 so not really sure what happens...
[12:59:50] <aliceisdinah>	 can someone help me?
[12:59:50] <wm-bot>	 Hi aliceisdinah, just ask! There is no need to ask if you can ask, if you already asked the question please wait for someone to respond
[13:09:37] <dp>	 Hey y'all, I recently put up a site notice with a paypal button, on Mediawiki:Sitenotice. However, the button is not clickable when I am on the home page. If I click onto another page, then it work just fine. Does anyone know how to make it work on the homepage?
[14:47:34] <divadsn|afk>	 Hello, I have a problem with my vagrant setup, each time I try to access the devwiki, I get a 503 server error, but why?
[14:49:21] <divadsn>	 Ok nevermind, it works after a restart, I don't know why :D
[14:52:20] <Yvette>	 Hi dp.
[14:52:23] <Yvette>	 Sounds like a CSS issue.
[15:28:41] <divadsn>	 dp, how did you add the PayPal donate button? Using a image combined with a link? Or a post form?
[17:14:40] <hypergrove>	 getting a skin install error: Invalid callback Skinny\Skin::ResourceLoaderRegisterModules 
[20:40:18] <Krenair>	 !cms
[20:40:18] <wm-bot>	 Wikis are designed for openness, to be readable and editable by all. If you want a forum, a blog, a web authoring toolkit or corporate content management system, perhaps don't use wiki software. There is a nice overview of free tools available at <http://www.opensourcecms.com/> including the possibility to try each system. For ways to restrict access in MediaWiki, see !access.
[21:01:19] <Krenair>	 ^ thought about putting that in the "[Mediawiki-api] Disabling the API without disabling search suggestions?" thread
[21:46:19] <MTres19>	 Hi, how can I include a subquery in an INNER JOIN with the database abstraction layer?
[21:47:09] <bawolff>	 Can you tell me what the query would be in just normal SQL?
[21:48:19] <MTres19>	 bawolff: Sure: https://gist.github.com/MTres19/9efb0dfe41f6a98c16fbdd225170d4b5
[21:49:06] <MTres19>	 I can easily generate the subquery with selectSQLText() but I don't know how to include it as a subquery in the first SELECT.
[21:49:54] <bawolff>	 MTres19: Wouldn't that be the same as just selecting from the page_latest field in the page table?
[21:50:34] <MTres19>	 bawolff: No, this is selecting the latest revision at a specific point in history.
[21:51:01] <MTres19>	 It's part of a bigger query: https://gist.github.com/MTres19/f4b2477aac4ef9b69f4c150959439de9
[21:51:09] <bawolff>	 Oh, i missed the rev_id < 20 part of the condition
[21:51:23] <MTres19>	 20 is just a temporary value for testing.
[21:51:41] <bawolff>	 MTres19: To clarify, is this for a Wikimedia thing, or a third party extension?
[21:51:44] <MTres19>	 As is the page.page_namespace = 0
[21:51:48] <MTres19>	 Extension.
[21:52:11] <bawolff>	 ok. Just checking because it would probably be considered too slow for wikimedia
[21:52:38] <MTres19>	 bawolff: The entire extension is just designed for small wikis anyway.
[21:52:48] <bawolff>	 Ok, should be fine in that case
[21:55:32] <bawolff>	 Just a second, I have to look this up
[21:55:55] <MTres19>	 bawolff: No problem, thanks for your help.
[22:01:03] <Skizzerz>	 MTres19: it's a massive hack, but you can pass the raw SQL for the second table as the "table name" as long as it contains the word AS in it
[22:01:14] <Skizzerz>	 and the db abstraction layer will use it as-is instead of trying to transform it
[22:01:40] <Skizzerz>	 (could also contain DISTINCT, ON, or JOIN and will be passed as-is as well)
[22:02:27] <MTres19>	 Skizzerz: If I did that, I would leave out $join_conds, right?
[22:03:27] <Skizzerz>	 no
[22:04:00] <Skizzerz>	 basically you'd have $subtable = '(SELECT ...) AS revision'
[22:04:15] <Skizzerz>	 (probably generated with help of calling selectSQLText)
[22:04:51] <MTres19>	 Skizzerz: Oh, I see.
[22:05:27] <MTres19>	 Do you think there's a possibility that subqueries could be added as a feature to $join_conds?
[22:06:12] <Skizzerz>	 then call select( [ 'page', $subtable ], ..., ..., __METHOD__, ..., [ $subtable => [ 'INNER JOIN', '' ] ] )
[22:06:14] <Skizzerz>	 or something like that
[22:06:17] <Skizzerz>	 it's rather ugly
[22:06:57] <Skizzerz>	 and, I don't think sourcing a subquery as a table will likely be supported by the abstraction layer natively
[22:07:35] <Skizzerz>	 but you can open a task on phabriactor to get input on it
[22:08:35] <bawolff>	 hmm, I'm trying to construct this with aliases, but its not working
[22:08:37] <MTres19>	 Okay. Thank you.
[22:08:50] <Skizzerz>	 bawolff: using what I said? or some other method?
[22:08:56] <bawolff>	 Basically what you said
[22:08:59] <Skizzerz>	 hmm
[22:09:04] <Skizzerz>	 I didn't test it, I was just looking at master
[22:09:05] <bawolff>	 I probably am typing something wrong
[22:09:10] <bawolff>	 what you said should work
[22:09:32] <bawolff>	 MTres19: This query would probably be easier if you used a HAVING clause instead
[22:09:44] <Skizzerz>	 or if you just passed raw SQL to db->query() :P
[22:10:00] <Skizzerz>	 (don't do that)
[22:10:21] <Skizzerz>	 even if you don't care about portability between dbmses, it's nice to not have to deal with adding table prefixes and such yourself
[22:12:29] <bawolff>	 SELECT null AS ar_id, page.page_id, page.page_namespace, MAX(revision.rev_id) FROM page INNER JOIN revision on page_id = rev_page where rev_id <= 20 and page_namespace = 0 GROUP BY page_id, page_namespace;
[22:12:47] <bawolff>	 I think that query is equivalent, and should be much easier to use with the abstraction layer
[23:25:56] <marktraceur>	 !hss | cscott_away 
[23:25:56] <wm-bot>	 cscott_away: https://upload.wikimedia.org/wikipedia/mediawiki/6/69/Hesaidsemanticga2.jpg