[02:44:26] Maybe I’ll have better luck here. Tech support? [02:46:52] ShadowReine, How can we help? [02:47:39] Okay. I am attempting to load a mediawiki database on a new system while simultaneously updating from 1.16.2 to 1.30 [02:47:58] I HAVE tried running update.php. If I use my old Localsettings.php file, I get connection refused. [02:48:21] If I attempt to reconfigure from scratch loading the same database, it informs me my database username and/or password is incorrect. [02:50:05] IOW...help. [02:51:19] Using MAMP, incidentally, most recent version on a Mac. [02:54:18] Starting to worry I’m stumping everyone. [02:55:37] It's a Friday night, which is generally a time of lower participation. If you haven't also asked in #mediawiki, I'd suggest you ask there too. [02:56:05] I tried there first. [02:56:30] So, are you stumped? I’m starting to get kinda desperate. I don’t sleep well when I have a knotty tech problem I can’t unravel :/. [02:57:09] Installing and configuration troubles aren't my area of expertise, unfortunately [02:58:53] *nodnods* Not your fault. [02:59:10] Hrm. I wonder. [03:01:13] Okay, that didn’t work. [03:07:20] Hrm. I’m definitely out of things to try. I figure if it won’t update on this comp it isn’t worth trying the update on the older one and then backing up again? [05:37:52] It’s fixed. So, if anyone else ever comes up against weird database connection errors, apparently MediaWiki has this habit of…not sure when it happened…adding a database prefix if you never set one. [09:11:23] https://nextcloud.com/blog/introducing-a-full-self-hosted-audiovideo-and-chat-communication-platform-nextcloud-talk/ [10:22:36] Okay why is my query failing to recognise? [10:22:37] https://quarry.wmflabs.org/query/24095 [10:22:48] Its saying there's a syntax error [10:22:55] I've checked and can't see one [10:24:55] Anyone? [10:26:28] ShakespeareFan00, why such complication as « AND t.tl_title IN ( 'IPNI' )»? [10:26:46] maybe just an ordinary comparison? [10:27:15] qq[IRC] city is doesn't like it with a straightforwad = 'IPNI' either [10:27:32] Where's the error? [10:27:59] because I am incresingly frustrated at the inablity of quarry to actually tell you where the REAL error is [10:28:05] instead of giving cryptic messages [10:28:31] I am trying to find pages I edited which uses a specfic template [10:28:43] This should have been a reasonably straightforwad qu3ery [10:29:29] isn’t this Web site only a wrapper over SQL interface? [10:29:45] But for some reason Quarry seems to being Pedantic about precisely what type of SQL it needs [10:29:52] So I will ask again [10:30:04] What is the error in my query? [10:34:02] qq[IrcCity], Yes quarry is wrapper over SQL [10:34:17] But it should be providing information as to WHY a query is wrong [10:34:23] Otherwise it's useless [10:36:00] it’s useful as a Web interface to SQL. probably no more, but no less indeed. are SQL ports of Wikimedia open for queries from the world? [10:56:06] ShakespeareFan00: in order to write a query in any query language, you need to understand the underlying data model. Quarry offers direct access to a copy of the mediawiki sql database, using mediawiki's data model. That model was not designed with Wikidata in mind, and some parts of it have grown over a decade, and are rather strange. [10:56:44] DanielK_WMDE: The glitch appeard to be stray punctation [10:56:57] For queries dealing with structured data content, a SPARQL query on WDQS may be better suited. But again, you have to understand the RDF mapping that is used to represent Wikidata content, you cannot write a query without that knowledge [10:57:02] Other SQL servers have been kind enough to tell me that [10:57:09] punctation is wrong [10:57:35] Perhaps this is something that can be raised as a concern on Phabricator? [10:57:49] The query is know working beautifully [10:57:54] I havn't really used quarry myself, I tend to use mysql directly on toolforge. I'd expect quarry to report whatever error mysql returns. [10:57:57] does it not do that? [10:58:00] Even if I am seeing the ocassional duplicates [10:58:23] DanielK_WMDE: The error message from MySQL doesn't note the punctation is wrong [10:58:37] So maybe I need to raise this on their bug tracker? [10:59:18] Something that would be rather useful, but probably beyond the scope of Quarry [10:59:22] ShakespeareFan00: when i submit a malformed query to quarry, i get something like "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1.' at line 1" [10:59:41] Yes.. [11:00:11] It doesn't say something like "A spurious punctation charecter was detected at..." [11:00:18] so your complaint is that mysql (resp MariaDB) doesn't provide better error messages? you'll have to raise that issue with them, then. [11:00:27] DanielK_WMDE: My apologies [11:00:29] there is nothing the author of quarry can do about that [11:00:51] I am a bit "sharp" this morning :( [11:01:21] DanielK_WMDE: As I said above, I will have to raise this with the MySql developers [11:01:26] ShakespeareFan00: the underlying prolem is really that a parser often cannot tell what is wrong. just that something is wrong. that's because it can't tell what you meant to do. [11:01:30] On something else entirely [11:01:48] Is there are an easy to search for malformed template calls? [11:01:59] based on data held internally by Mediawiki [11:02:14] no, for the same reason: if it's maleformed, mediawiki does not know that it's supposed to be a template call. [11:02:28] In my use case this morning, its searching for template calls using [11:02:32] as a parameter [11:03:02] The template call itself is fine... [11:03:07] the brackets match up [11:03:17] but the presence of in the call, genrates nonsense [11:03:41] Is there a way to search for uses of the template, that call it with or blank as a parameter? [11:04:09] should work fine... if it does not, that's probably a problem with the template itself [11:04:23] mediawiki can tell you where the template is used, but not with what parameters. that is not indexed in the database [11:04:41] So it's a case of having to grep indvidual pages? [11:04:43] there's a thing called "template tiger" that has this info. but i'm not sure how up-to-date that is [11:04:44] https://tools.wmflabs.org/templatetiger/ [11:05:34] ShakespeareFan00: maybe the better approach would be to find out why is causing a mess. it shouldn't cause a mess. maybe the template can just be fixed, instead of fixing all calls [11:06:00] DanielK_WMDE: The template is {{IPNI}} on Wikispecies [11:06:16] It uses one of it's paramaters to generate a url [11:06:25] If is used instead of blank [11:06:47] It generates a search= in the URL which is clearly gibberish [11:07:09] https://species.wikimedia.org/wiki/Template:IPNI [11:07:34] Hence the need to avoid using for that parameter [11:07:46] Typically it's the 4th Parameter [11:07:53] That causes the problem [11:08:13] There are some other issues with other parameters... [11:08:14] param 4 is supposed to be a page name [11:08:17] Yes [11:08:31] and for some reason is mis-read [11:08:32] passing there is clearly wrong [11:08:36] Quite [11:08:47] Hence the desire to eliminate mis-calls [11:09:31] I can check my own edits... [11:09:51] but can't (easily) at present find malformation of that kind quickly [11:10:05] Unless you know otherwise [11:10:17] Or know of a way to do it from the dumps? [11:10:37] nihlus does that sort of thing [11:10:50] he uses a bot, and programs it with certain regex [11:11:07] however that is not instant, and needs permits [11:12:14] Also not sure why this fix worked - https://species.wikimedia.org/w/index.php?title=Yosemitea&diff=prev&oldid=3592483 [11:12:52] https://en.wikipedia.org/wiki/User:NihlusBOT [11:14:58] because examing the template logic it shouldn't have mattered [11:16:03] Dysklyver: Do you know anything about regexp? [11:16:43] no but my point is that there is an automated program that can fix the issue you are talking about, and perhaps some similar problems [11:17:24] Nihlus hates my guts btw, so you would need to ask him yourself :P [11:19:56] Okay [11:24:27] Dysklyver: As you aren't blocked on Wikispeices : can I tempt you to review the entires here? https://quarry.wmflabs.org/query/24095 [11:24:37] Looking for malformed template calls? [11:26:01] 441 entries ? [11:33:33] Hello, I need to help with mapframe. Why do not this map work? https://cs.wikipedia.org/wiki/Wikipedie:Popi%C5%A1_pam%C3%A1tku/Mapy/CZ-533 [11:33:36] Thanks again a lot! [11:48:08] try copying https://www.wikidata.org/wiki/Q14395215 to your wiki and using that [13:42:17] bd808: Yes, I did. [18:11:32] Hi anyone here like to explain why span is misnested here? https://species.wikimedia.org/w/index.php?title=Template:User_Bureaucrat/hu&action=edit&lintid=43247 [18:11:40] Or what Small should be replaced with? [18:21:26] Anyone? [18:22:52] Patience? [18:37:39] ShakespeareFan00: im not a expert of templates but i suppose I can atleast make an attempt [18:37:57] https://species.wikimedia.org/wiki/Template:User_Bureaucrat/hu [18:38:22] was an attempt to resolve it but apparently no gives a stripped tag error [18:38:27] So What's gone wrong [18:38:30] Please? [18:38:52] This needs someone that can ACTUALLY fix it instead of making an attempt [18:40:24] ShakespeareFan00: then you will have to be patient like Andre suggested [18:40:35] He offered to help but you are not helping [18:40:52] by panicking over something small [18:41:04] Wiki13: I'm not panicking [18:41:25] It's that it's a head-scratch [18:41:31] well, the way I read it its close to that [18:41:37] as to why it's giving problems [18:41:51] When I can't actually find any mismatched tags [18:42:03] and I used Special:ExpandTemplates to check as well [18:42:08] what exactly is the problem here? [18:42:23] does it show up in some maitenance category? [18:42:48] Yes [18:42:55] which one [18:42:58] https://species.wikimedia.org/w/index.php?title=Special:LintErrors/stripped-tag&dir=prev [18:43:27] It also does not help that because of some questionable UI design [18:43:35] It's not possible to directly revert it [18:43:52] or edit the source withotu going via a "Translation" tool [18:44:10] Quite why this particular version is problematic while other translation aren't [18:44:16] Is currently beyond me [18:44:53] Other translations show up here - https://species.wikimedia.org/wiki/Special:LintErrors/misnested-tag [18:45:11] Like https://species.wikimedia.org/w/index.php?title=Template:User_Bureaucrat/nl&action=edit&lintid=3231 [18:45:25] For some reason small and plainlinks don't like each other [18:45:46] but I'm having a hard time figuring out what the CORRECT fix is [18:46:30] It's shame there isn't a version of ExpandTemplates that analyses code against the new parse [18:46:36] using Lint vs Tidy [18:47:00] Tidy is long gone iirc [18:47:32] Not quite yet [18:47:57] So.. why does https://species.wikimedia.org/wiki/Template:User_Bureaucrat generate no error? [18:48:12] whereas the translation which should be near identical structrally do so? [18:49:03] To me it looks fine [18:49:10] The small just isnt working [18:49:27] I don't know why all that parser stuff is in there in the first place, anyway [18:49:50] you can make it so that only text gets translated, I mean look at the translations at Meta [18:57:01] Zppix: Then it still is broken :( [18:57:05] (Sigh) [18:57:07] No progress [18:58:09] I didnt do anything nor will I considering I dont feel safe editing in a lang i dont know in templates i dont fully know [18:58:47] I know you hadn;t edited [18:58:57] No progress towards a stable fix from anyone. [18:59:00] (sigh) [19:00:16] I have trying using the page on Mediawiki.org but so far I still cant see whats wrong [19:08:47] ShakespeareFan02: there was a span error on that bureucrat template of language HU right? [19:09:52] okay [19:10:08] ShakespeareFan02: I think I have figured out how to fix those [19:10:42] add a space after the first use of small [19:10:50] and one before the closing one [19:11:08] then the error will disappear of that page [19:12:13] https://species.wikimedia.org/w/index.php?title=Template:User_Bureaucrat/ru&diff=prev&oldid=3592852 example [19:13:01] the problem is that someone marked the old translation as "ignore changes", hence the translatable source has not been 'bumped' to include the changes which removed the tags in the original. I.e. http://storage4.static.itmages.com/i/18/0113/h_1515870557_5490906_b66f23edc3.jpeg [19:13:05] which expands to http://storage6.static.itmages.com/i/18/0113/h_1515870718_3249198_40a87ff294.jpeg [19:14:55] Wiki13, your change is just nudging the results onto page 2 of Special:LintErrors [19:15:01] oh [19:15:02] . [19:15:39] to resolve, we need a wikispecies translationadmin, to remark that block as needing translation. Possibly via a dummyedit or similar. [19:16:02] ill just revert it then [19:16:06] my edits [19:17:04] https://species.wikimedia.org/wiki/Special:ListUsers/translationadmin [19:19:57] I just noticed then my edit was essentially a null edit cause the small errors on that special page are gone [19:20:06] only the span errors remain it seems [19:28:30] quiddity: thanks [19:28:43] now to wake up someone to fix it fully [19:32:48] quiddty: https://species.wikimedia.org/w/index.php?title=Template:TalkX&action=edit&lintid=33673 [19:33:01] Most of the other templates are mismatched DIV's [19:33:08] Any thoughts on how to solve? [19:44:32] Okay [19:44:34] thoughts? [19:49:33] ShakespeareFan02, in IRC, if you type the first 2 or 3 letters, and then press [tab], it will autocomplete the rest of the nickname. That way you can avoid misspellings of names which don't ping anyone. ;) [19:49:35] Re: the problem with Template:TalkX - it would be helpful if you give more context (and not expect me/others to dig) - what is the error? It's not on the Special:LintErrors/misnested-tag page. [19:49:45] Because I fixed it [19:49:58] https://species.wikimedia.org/wiki/Template:TalkX [19:49:59] I hope [19:50:11] A question of tag balancing [19:50:57] The current list of misnestings is here - https://species.wikimedia.org/wiki/Special:LintErrors/misnested-tag?namespace=10 [19:51:04] Most are translations [19:52:44] And [19:52:52] https://species.wikimedia.org/wiki/Special:LintErrors/html5-misnesting [19:55:22] Ans puzzled why this worked at all - https://species.wikimedia.org/w/index.php?title=User:Angus_Guilherme&diff=prev&oldid=3592907 [19:55:25] *And [19:56:42] It shouldn't work at all [19:56:50] DIV inside SPAN is bad [19:58:08] And finally one that gave me a headache - https://species.wikimedia.org/w/index.php?title=User:BRPever&action=edit&lintid=39871 [19:58:25] The error is trying to put a block level element inside a spam [19:58:28] *span [19:58:32] Not sure how to fix it [19:59:01] : is a block level element (as it starts a list, meaning the span gets interrupted [20:02:44] fixed [20:03:17] mm, maybe not [20:06:15] fixed [20:14:05] Thanks [20:14:22] The remainder of the high priority errors are on protected pages [20:14:24] :( [20:14:35] And look to be One or two obvious templates [20:15:12] The two village pump ones are rather comples [20:15:22] and probably need to be examined in more depth [20:20:44] quiddity: https://species.wikimedia.org/w/index.php?title=User:Ferdous&action=edit&lintid=39877 [20:20:56] Here I am again not seeing an obvious tag imblance. [20:21:20] So I am strongly thinking 'class=plainlinks' is involved [20:28:49] fixed. and now I'm out for the day.