[05:10:32] Hi [11:17:56] hello anyone here ? [11:27:51] hello [15:30:49] I'm getting this error: https://www.mediawiki.org/wiki/Topic:V36q7ftqbs8a117v [15:30:53] but I don't quite understand the solution [15:31:06] "changing your password so it uses the new format, might be enough to fix the problem" [15:31:20] I literally just installed mysql and created the user and set the password, how is changing my password going to help [15:32:22] Somewhere on the wiki there is a template that uses either {{REVISIONID}} or {{REVISIONTIMESTAMP}} to display a page differently in edit/preview than in view. Does anyone here know where I can find that, please? [15:49:38] https://en.wikipedia.org/wiki/Module:If_preview this thing? [16:01:02] i fixed it, changed password type to mysql_native_password in mysql settings [16:39:43] Skizzerz: ping [18:13:37] Hello, I would like all Logged Out Users to immediately be taken to a Login page upon visiting my wiki...I don't want themt o be able to read/view or edit anything [18:13:40] Is this possible? [18:17:43] you can make it impossible for them to read/view/edit, by setting the rights appropriately: https://www.mediawiki.org/wiki/Manual:Preventing_access#Simple_private_wiki [18:17:55] I don't know that it will redirect them [18:18:04] but it will at least revent them viewing the contents etc [18:51:10] How do i edit the css of the vector skin? I do not see a css file in the skins folder any more [18:56:29] I also even as a sysop do not have permission to edit my Common.css [19:12:37] kevindank: https://www.mediawiki.org/wiki/MediaWiki_1.32/interface-admin [19:13:01] tl;dr there's a new interface-admin group required to be able to edit on-wiki css/js pages [19:13:07] regular admins lost that ability [19:17:40] Skizzerz: so i'm at the part where i am manually editing the MSSQL queries to convert them to MySQL queries and I've come across some binary columns [19:17:58] Skizzerz: so am i just supposed to take the 0x12239847538527349 and put quotes around it ? [19:33:43] Skizzers: I'm not seeing how i add myself to that? [19:34:37] I don't understand the logic of adding that barrier. [19:38:41] And how do i edit the css for the vector theme while logged out? [19:39:08] Example, the page Special:UserLogin, im trying to change the appearence of it but changes made to Mediawiki:Common.css don't reflect on that page [20:53:43] i am having an issue with a 1.33 mediawiki install that was upgraded recently. The login, user buttons etc do not appear at the top of the page unless a user is logged in. [20:54:13] i am using the apex skin, the upgrade was from php 5.x and a older version of mediawiki to 1.33 and php 7.x at the same time. [20:54:37] i was wondering what system messages page affects the top login bar. [21:06:06] maybe the theme hides it/doesnt show it [22:33:39] @apergos: that uses Module:, the thing I'm thinking of was pure wiki magic words/parser functions. [22:33:54] oh... huh. dunno then [22:34:38] Something like {{#ifeq:{{REVISIONID}}||}} [22:35:39] ShoeMaker: I think REVISIONID will be empty in preview [22:35:53] per the docs at https://www.mediawiki.org/wiki/Help:Magic_words [22:37:06] Yeah, I just don't remember exactly how it was set up in the templates/MediaWiki interface message/whatever it was that I saw it being used. [22:37:35] well, that ifeq looks quite good [22:38:56] don't need ifeq if you're just testing empty/not empty -- regular if will do [22:40:09] true [22:40:18] Skizzerz: ping [22:41:51] stiv2k: yes? [22:42:02] Skizzerz: so i'm at the part where i am manually editing the MSSQL queries to convert them to MySQL queries and I've come across some binary columns [22:42:08] Skizzerz: so am i just supposed to take the 0x12239847538527349 and put quotes around it ? [22:42:13] no [22:42:32] convert that to its string representation [22:42:44] eh? [22:43:01] every two characters is (in hex) a byte [22:43:09] right [22:43:15] convert that to the actual bytes, it'll form a readable string [22:43:36] then put THAT string (with surrounding quotes) into mysql [22:43:41] like the ascii representation? [22:43:52] utf-8 iirc [22:44:02] okay, got it [22:44:26] next question, i've identified 6 tables with mismatched schema compared to the older mediawiki version [22:44:33] not sure how to handle those [22:45:11] archive, externallinks, logging, recentchanges, site_stats, and user_groups [22:45:30] oh shit [22:45:32] do your best in converting it over to what mysql expects [22:45:36] i did it wrong [22:45:45] i was supposed to reinstall the same version not the newer version [22:45:49] yes [22:45:53] ahhhhhh fack [22:45:54] okay [22:46:18] minimize the amount of changes you need to manually do [22:46:35] (there may still be schema differences even with the same version) [22:46:46] oh also [22:46:56] the MSSQL queries precede all the strings with N [22:47:00] like N'sometext' [22:47:05] should i leave that there? [22:53:05] Skizzerz: should i choose binary or utf-8 for the character set (in the installation script) [22:53:42] i think it should be binary as it seems thats what i had before [23:38:00] stiv2k: sorry was afk [23:38:03] choose "binary" for the installer [23:38:07] and remove all of the N prefixes [23:41:26] (going afk again)