[03:26:13] <gstupp>	 Hello all, I'm trying to set up my own local instance of wikibase repository and WDQS. I've managed to get everything all running, however, when I try to load data from my wikidata instance into wdqs I'm having issues, and I'm wondering if anyone could help?
[03:26:54] <gstupp>	 When I run the munge.sh script with my rdf dump, I get the following error: 'Expected only sitelinks and subjects starting with http://www.wikidata.org/wiki/Special:EntityData/ and http://www.wikidata.org/entity/"
[03:27:19] <gstupp>	 I think I'm supposed to change "wikibaseHost" (according to https://www.mediawiki.org/wiki/Wikidata_query_service/User_Manual#Standalone_service) but I have no idea where to change it
[11:06:35] <Hintswen>	 Anyone have any experience moving from SQLite to MySQL?
[15:49:02] <Isarra>	 Is there a chart somewhere of what mw versions are compatible with what php versions?
[15:49:19] <Reedy>	 yes, ish
[15:49:26] <MatmaRex>	 Isarra: https://www.mediawiki.org/wiki/Compatibility#PHP
[15:49:27] <Reedy>	 https://www.mediawiki.org/wiki/Compatibility#PHP
[15:50:13] <Isarra>	 Hmm.
[15:50:22] <Isarra>	 Thanks.
[15:50:24] <Isarra>	 Er.
[15:50:40] <Isarra>	 Do either of you lovely people know how to downgrade php? >.>
[15:51:29] <MatmaRex>	 D:
[15:53:38] <Reedy>	 Depends on your OS
[15:54:09] <Reedy>	 What version are you needing to downgrade from?
[15:57:18] <Isarra>	 It's ubuntu, and 7.0, apparently.
[15:58:00] <Reedy>	 why do you need to downgrade?
[15:58:34] <Isarra>	 Because we're on mw 1.23, and legoktm is the only one who knows how to run the db updates because the db is too big to use the usual scripts. >.>
[16:04:41] <Isarra>	 Also something something DPL.
[16:06:22] <Reedy>	 Wikia are making MW 1.19 PHP 7.1 compliant
[16:06:24] * Reedy facepalsm
[16:06:28] * Reedy facepalms too
[16:06:52] <Reedy>	 Isarra: I guess reinstalling the OS isn't an option?
[16:08:12] <Isarra>	 Snrrrk.
[16:08:39] <Isarra>	 Not any time soon.
[16:08:47] <Isarra>	 Man, I just wanted to get ssl working.
[16:10:53] <Reedy>	 You need to either find a PPA for PHP 5.6 or similar for your version of ubuntu
[16:11:06] <Reedy>	 Or try and force install the old php packages from the last php 5 version of ubuntu
[16:12:20] <Isarra>	 Oh, it's all *there*. It's just everything got renamed. How do I make all the other stuff actually use it?
[16:12:35] <Reedy>	 Everything got renamed?
[16:12:54] <Isarra>	 Paths and such are totally different.
[16:13:30] <Isarra>	 Egh, wait... I don't even know what I'm talking about.
[16:14:47] <Isarra>	 ...yeah. It actually already is installed. >.>
[16:14:56] <Isarra>	 I just don't know how to make things use it.
[16:16:42] <Reedy>	 things?
[16:16:42] <Reedy>	 it?
[16:16:46] <Reedy>	 much technical
[16:17:02] <Isarra>	 I don't know!
[16:17:08] <Isarra>	 I'm not a real sysadmin!
[16:17:36] <Reedy>	 Chances are you just need to change the version of PHP the webserver is using
[16:17:42] <Isarra>	 Uh, apache is using php7. Do I just edit some config to tell it to use php5 instead?
[16:18:02] <Isarra>	 > I have MediaWiki version 1.16.0.0 running on Ubuntu 16.04 with PHP7.0.
[16:18:04] <Isarra>	 ...and I thought I was being bad. >.>
[16:18:30] <Reedy>	 Do you have the php5 version of libapache2-mod-php7.0 installed?
[16:18:37] <Reedy>	 libapache2-mod-php5 or libapache2-mod-php or something
[16:20:50] <Isarra>	 Do now.
[16:21:19] <Reedy>	 Do you need PHP7 support in apache still?
[16:21:39] <Isarra>	 Nope.
[16:22:58] <Reedy>	 I'd probably suggest uninstalling libapache2-mod-php7.0 then
[16:23:04] <Reedy>	 A restart of apache...
[16:23:10] <Reedy>	 And it should just automagically use php5 again
[16:24:25] <Isarra>	 Oh.
[16:24:39] <Isarra>	 Apparently this apache just wants php7.
[16:24:50] <Reedy>	 just wants?
[16:25:06] <Isarra>	 libapache2-mod-php requires libapache2-mod-php7.0.
[16:25:31] <Reedy>	 https://packages.ubuntu.com/zesty/libapache2-mod-php
[16:25:32] <Reedy>	 Yeah
[16:25:42] <Reedy>	 You need to find the php 5 version... Possibly from wherever your php5 came from
[16:45:24] <Isarra>	 Okay, what happens if you do try to use the usual maintenance scripts with a too big database?
[16:45:31] <Isarra>	 Does it just take forever?
[16:46:12] <Reedy>	 update.php?
[16:46:18] <Isarra>	 Yeah.
[16:46:45] <Reedy>	 It'll take a long time, yeah
[16:46:58] <Reedy>	 And possibly cause db issues
[16:47:15] <Isarra>	 Myes...
[16:56:25] <Isarra>	 Okay! I have successfully restored our previous state of broke!
[16:56:33] <Isarra>	 Reedy: Thank you for all your wonderful help.
[16:56:38] <Isarra>	 I give up.
[16:57:40] <Isarra>	 (But at least it doesn't appear to be any more broken than it was, now. >.>)
[17:19:26] <saper>	 Isarra: how old is your own MediaWiki ?
[17:20:06] <Isarra>	 saper: We're on 1.23! It's old!
[17:22:49] <Zppix>	 Isarra: eeck time to update mate
[17:23:13] <Zppix>	 We dont even support 1.23
[17:23:28] <Isarra>	 Zppix: So how're the third-party support scripts coming along for that?
[17:23:38] <Isarra>	 For the projects that are just way too big to use update.php.
[17:24:17] <Reedy>	 Do like WMF does
[17:24:18] <Zppix>	 Isarra: afaik the only way besides fresh reinstall is update.php
[17:24:21] <Reedy>	 DBAs!
[17:24:23] <Zppix>	 Or dbas
[17:24:39] <Reedy>	 You basically just run the update sql files manually
[17:25:19] <Reedy>	 Usually, updating slaves first
[17:26:06] <Vulpix>	 how large is that wiki? I'm not sure how to measure that
[17:26:09] <Zppix>	 However i would be careful with usercss and js since 1.29 drops support majorily compared to .23
[17:28:56] <Reedy>	 Support doesn't change. Just a few global renames/splits
[17:29:05] <Zppix>	 ^
[17:29:09] <Zppix>	 Thats what i meant
[17:29:20] <Vulpix>	 also, a large wiki using apache-mod-php? maybe you want to use php-fpm
[17:30:54] <Isarra>	 In all seriousness, I think we can do that. It's just a bigger task than I'm up for at the moment.
[17:31:05] <Isarra>	 Which pretty much sums up why it's taken us so long in general. 
[17:31:45] <Isarra>	 Because yeah, what Reedy said. It's straight-forward enough.
[17:32:12] <Reedy>	 You've got 40-50 sql patches to apply :/
[17:33:06] <Vulpix>	 if wiki editing is not available during... 2-3h? (it should be a very large wiki for that I guess) that may take the update.php script I think it shouldn't be so bad...
[17:33:26] <Reedy>	 DB changes can take weeks on WMF wikis :P
[17:33:31] <Vulpix>	 be sure to disable the binary_log in mysql so writes are faster
[17:35:02] <Vulpix>	 you could hire a cloud/vps with enough ram to mount the entire database in ram for doing the upgrade. Transfer the wiki there, mount the database in a ramdisk, upgrade, dump the sql and put it back on your original server
[17:35:45] <Vulpix>	 a vps hired for a few hours wouldn't cost you much even if it requires lots of RAM
[17:39:22] <Vulpix>	 I grabbed 1.083.000 revisions from a wikia wiki (18GB of uncompressed text, transferred to a server through api calls) in 6h15m
[17:57:18] <Isarra>	 Hey, that's about the size of one of our small wikis!
[17:57:20] <Isarra>	 Wait.
[17:57:21] <Isarra>	 Crap.
[17:57:28] <Isarra>	 That's the size of the SMALL wiki. O_o
[17:58:25] <Reedy>	 Of course, that's also part of your problem
[17:58:31] <Reedy>	 it's not just one wiki, it's many ;)
[17:58:42] <Isarra>	 ...yes.
[17:58:45] <Isarra>	 This is why we have legoktm.
[17:58:48] * Isarra nods sagely.
[19:32:15] <awight>	 Has anyone here needed a schema with a generic link to more than one type of MediaWiki entity?
[19:32:42] <awight>	 We’re planning to link to revisions, articles, and then maybe fancy stuff like log entries…  https://etherpad.wikimedia.org/p/meta_ores_schema
[19:54:16] <awight>	 </attempt to have other people do my homework> ;-)
[19:56:49] <Vulpix>	 [[Special:Redirect]]?