[01:39:40] hi [01:39:54] How do i add html to mediawiki pages [01:40:18] likeif i wanted to add a tag to the html header of all articles? [01:46:55] you need to find a extension that can handle that [01:53:04] so if I wanted to completely change the html layout of a page, mediawiki must have something that allows it to be defined [01:54:36] !skins | Dysklyver [01:54:36] Dysklyver: General skin help: http://www.mediawiki.org/wiki/Manual:Skins / List of available skins: https://www.mediawiki.org/wiki/Category:All_skins / Creating a new skin: see !skinning [01:54:43] !skinning | Dysklyver [01:54:43] Dysklyver: From scratch: https://www.mediawiki.org/wiki/Manual:Skinning/Tutorial / Based on another skin: http://blog.redwerks.org/2012/02/28/mediawiki-subskin-tutorial/ / See also !skins for general help and list of available skins [01:54:58] Ivy, I don't want to change the look [01:55:02] But maybe you should try asking your actual question. [01:55:06] What's your actual question? [01:55:09] i want to change all the html tags [01:55:27] That's not a question. [01:55:52] how do i make mediawiki fit https://www.ampproject.org/docs/reference/spec ? [01:56:22] Probably a skin or extension. [01:57:26] https://www.mediawiki.org/wiki/Requests_for_comment/Accelerated_Mobile_Pages was an effort in that direction, but it died. [01:58:20] o thanks [01:58:22] https://www.mediawiki.org/wiki/Extension:Amp [01:58:26] Yeah, https://phabricator.wikimedia.org/T124243#3780325 [08:03:44] So I need to ban linking to loginteacher.org coz that what this XEvil equipped bot is liking to post with multiple socks [08:03:54] AbuseFilter ? [08:19:15] jubo2: SpamBlacklist [08:29:02] I'm looking at https://www.mediawiki.org/wiki/Extension:SpamBlacklist [08:29:29] How do I set locally the rule to stop the bot from posting its spam? [08:31:12] ahh i c now [08:35:43] I set the spammer bot's favourite URL to MediaWiki:Spam-blacklist [08:36:01] \b is for word boundary right? [08:36:21] and \. is naturally an escaped dot [08:36:39] Learning some perl has its upsides [08:52:10] jubo2: yep [09:49:42] No clues on how to use a template without Mediawiki knowing the template has been used? Lol. Trying to avoid export when "include templates" is checked on Special:Export. [09:50:07] If only there were a Template Documentation namespace, sigh [14:42:15] Henstepl: What? [15:23:55] hello guys [15:46:19] hi [15:46:45] hi Dysklyver [17:56:07] hello [17:56:38] can i expect a reply from the team [17:56:49] which team? [17:59:31] hello [18:00:38] Getting "Error: 1 no such table" when trying to setup two wikis with shared database (just for user info) [18:01:09] I do not believe I deviated from standard setup for sqlite database [18:01:22] the second wiki gets that error [18:05:34] shared database with sqlite... looks challenging ;) [18:07:10] ressected: don't use sqlite [18:07:31] it's there for local dev/test installs where you are the only user, not production wikis [18:07:51] Skizz, that's not what the docs say [18:07:57] Skizzerz [18:08:28] sqlite locks the entire db during a write, so you can't have more than 1 person doing something at once with it [18:08:53] (such as two people loading a page at the same time, since reading a page updates the stats counters) [18:09:24] Skizzerz, the shared database page says sqlite should work [18:09:37] I'm saying that sqlite in general is a terrible idea for a production wiki [18:09:41] I understand it's not the best solution [18:09:46] I don't care what the docs say, it's ill-suited for a multi-user environment [18:09:59] but unfortunately right now I don't have a choice unless I scrap and start over [18:10:21] I just need it to work [18:10:27] well, stats counters were removed from core several versions ago, so that's not a problem, but the wiki can still perform some updates internally like running the job queue [18:11:10] This is for a low traffic wiki [18:11:26] collisions between users should be rare [18:11:55] but I need to segregate access to some info, so I need another private wiki that shares the same user db [18:12:33] about the specific problem, I guess you're using table prefixes since both wikis are on the same database [18:13:24] in that case, you'll need to specify the https://www.mediawiki.org/wiki/Manual:$wgSharedPrefix for the shared tables [18:13:27] are they separate db files or in the same db file? [18:14:37] Separate db files [18:15:39] I tried $wgSharedPrefix, but I don't think I ever originally specified a prefix [18:16:58] I wonder if shared database can be used with 2 different sqlite databases... [18:17:16] well wouldn't sharing more than user tables screw it up? [18:19:17] well the wiki pages on this are vague, but what I gathered is this (I'm probably wrong) ... [18:19:48] I'm pretty sure that won't work, since the idea of shared database is that SQL queries can be constructed from tables from both databases at once. You can't access 2 different databases on the same query with sqlite (I'll be surprised otherwise) [18:19:57] Have existing wiki, then install new wiki with new databse and admin user, then enable shared database user tables in the new wiki's LocalSettings.php [18:20:15] Vulpix, okay [18:21:00] Vulpix, maybe when I'm done I'll update the wiki pages for these variables [18:21:02] the only way this would work for sqlite is by using the same database, and setting different table prefixes on each wiki (so tables don't overlap) [18:21:55] Vulpix, I thought the wiki's use their respective wiki names for the prefixes, by default? [18:22:38] I'm running this on a small portable VM I'm trying to avoid SQL if I can [18:22:57] mysql* [18:22:58] no, the prefix is defined by https://www.mediawiki.org/wiki/Manual:$wgDBprefix and it's blank by default [18:23:50] so the error I'm getting "Error: 1 no such table: wiki1.user" [18:23:59] the wiki1 is the name of the wiki [18:24:52] is it assuming the wiki name is the prefix when it really isn't? [18:25:13] no [18:25:22] it's assuming that the other db was attached using the name wiki1 [18:25:56] well it's pointing to that db as the "shared" sb [18:26:01] db* [18:26:24] are both dbs in the same directory? [18:26:39] wiki1 may have been set in https://www.mediawiki.org/wiki/Manual:$wgSharedDB but of course sqlite doesn't use database names as such [18:26:46] e.g. if you have wiki1.sqlite and wiki2.sqlite, are they both in the same dir? [18:26:52] or are they in different dirs? [18:27:07] wiki2 has $wgSharedDB = /path/to/wiki1.sqlite in its localsettings [18:27:12] Skizzers, yes they are [18:27:16] SharedDB can't be a path [18:27:22] Skizzers, everything is default [18:27:32] just make it $wgSharedDB = 'wiki1'; [18:27:35] Skizzers, sorry it's just the name [18:27:47] Skizzers, not a path [18:27:56] "everything is default" doesn't answer my question [18:28:08] are the two files wiki1.sqlite and wiki2.sqlite physically in the same location in the filesystem [18:28:32] still, I'm pretty sure that won't work. I doubt you can do "select * from A, B" where A and B are different sqlite files [18:28:38] Skizzerz, they are both in /var/www/data [18:28:45] *tables in different sqlite files [18:28:48] Vulpix: it's supported [18:29:02] oh, nice [18:29:24] I think the new wiki would just reference the first wiki's sqlite user info [18:30:38] there's 200 layers of abstraction in the db so it's hard to figure out what's going on here [18:30:41] it's attempting to, I mean it appears it's accessing the wiki1 sqlite db, it's just not asking for the right tables [18:30:57] in wiki1, did you use a prefix? [18:31:13] try connecting to wiki1 via cli `sqlite3 wiki1.sqlite` and executing the .tables command [18:31:19] no I did not, and I was about to say maybe I should re-do them with unique prefixes [18:31:26] shouldn't matter [18:32:44] okay I did that and got a list [18:33:09] the wiki1.user table it was looking for is not there [18:33:11] just user [18:33:50] no, that's correct [18:34:19] can you please pastebin the bits of LocalSettings which concern your db setup? [18:34:25] on the wiki experiencing the issues [18:34:29] yes [18:34:31] *from the wiki [18:34:46] The first wiki should be left alone right? Only the new one needs references to the shared db? [18:34:52] yes [18:34:59] I'd like to see what you have there [18:35:10] (don't paste it in here, use a pastebin like https://dpaste.de ) [18:36:37] got it, one moment [18:38:23] https://pastebin.com/P9EsB0Dv [18:38:48] Skizzerz, not sure if it matters but I changed the names of the real wikis to generic wiki1 and wiki2 [18:38:59] the real ones have more unique names [18:40:28] well, by changing them you introduce the possibility that you typoed something but we can't catch it due to you changing stuff [18:40:41] (or you typo something that we see as incorrect, but was due to the typo and not the actual config) [18:40:58] Skizzerz, I'm confident there are no typos [18:41:07] I've checked over and over [18:41:12] I'm here as a last resort [18:41:41] and that is everything db-related in your LocalSettings? Nothing further down? [18:41:42] okay respecting your wisdom I will post the raw data [18:41:47] nah, it's fine [18:42:41] $wgShowExceptionDetails = true; [18:42:41] $wgShowDBErrorBacktrace = true; [18:42:48] ok [18:42:49] I have those so I can see the errors [18:45:20] temporarily, set $wgDebugToolbar = true; in your LocalSettings, then reload the page showing the db error [18:45:35] it will add a toolbar to the bottom of your browser, click on "Queries" to expand it [18:45:58] https://pastebin.com/txzn5tVK [18:46:06] theres the error if that helps [18:46:20] ok [18:47:54] it did not do that [18:48:09] no wiki pages load at all, just that error [18:48:15] hmm [18:48:17] bleh [18:48:27] that's way easier than setting up query logging :( [18:48:39] well why would it be asking for a table that doesn't exist? [18:48:55] it's assuming the user table is wikiname.user instead of just user [18:49:06] so what SHOULD be happening is that early on in the mw lifecycle, it runs the query ATTACH /path/to/wiki1.sqlite AS wiki1 [18:49:19] later, it can refer to tables in wiki1.sqlite by prefixing the table name with wiki1. [18:49:21] e.g. wiki1.user [18:49:35] oh I see [18:49:35] so the query is correct [18:49:39] that makes sense [18:49:40] the attach doesn't seem to be happening [18:50:08] so I wanted to grab the query log to see if that attach query was there [18:51:15] what about setting the sharedtables variable [18:51:31] or does it not matter [18:52:36] no, keep the default there [18:52:44] ok remove $wgDebugToolbar [18:53:29] could any extensions be screwing it up? [18:53:35] I don't know how [18:54:04] and add $wgDebugLogGroups['DBQuery'] = '/var/log/mediawiki/query.log'; (or wherever you want to put the log file) [18:54:09] it could be extension-related [18:54:16] hopefully the query log will shed more light on it [18:54:38] then refresh the page, and that logfile should appear [18:54:57] if it doesn't appear, make sure the webserver user is able to write there [18:55:04] there's only one wikicache.sqlite files in /var/www/data [18:55:57] that shouldn't be a problem [18:56:28] although you can change your object cache config on one of the wikis just to be sure [18:58:44] query.log says this three times: [18:58:47] SQL ERROR: no such table: [18:58:57] SQL ERROR: no such table: wiki1.user [18:58:59] SQL ERROR: no such table: wiki1.user [18:59:00] SQL ERROR: no such table: wiki1.user [18:59:14] does it have other lines in it? [18:59:19] if so, can you pastebin the entire file? [19:03:57] yep [19:04:11] 2017-12-29 18:58:03 mind admin_wiki: SQL ERROR: no such table: ETQW_stuff_wiki.user [19:04:11] 2017-12-29 18:58:03 mind admin_wiki: SQL ERROR: no such table: ETQW_stuff_wiki.user [19:04:11] 2017-12-29 18:58:03 mind admin_wiki: SQL ERROR: no such table: ETQW_stuff_wiki.user [19:04:14] thats the whole thing [19:04:18] hmm [19:04:21] that is the first wiki [19:05:15] ah [19:05:24] the default logging level is probably "warning" [19:07:29] ressected: set $wgDebugDumpSql = true; as well [19:07:33] Does it matter if the two wikis started with the same admin account? [19:07:35] (in addition to DebugLogGroups) [19:07:36] no [19:07:54] when you flip on shared user database, the local user database is completely ignored [19:08:56] okay that dumped a lot [19:08:59] there we go :) [19:09:20] do you see ATTACH in there at all? [19:11:04] no ATTACH but greping lowercase I get this: [19:11:20] 2017-12-29 19:08:17 mind admin_wiki: admin_wiki INSERT /* LCStoreDB::finishWrite/multi-row */ INTO l10n_cache (lc_lang,lc_key,lc_value) VALUES ('en','messages:apihelp-query+allusers-param-attachedwiki',x'733a3131343a2257697468203c6b62643e243170726f703d63656e7472616c6964733c2f6b62643e2c20616c736f20696e64696361746520776865746865722074686520757365722069732061747461636865642077697468207468652077696b69206964656e7469666965642062792074686 [19:11:20] 9732049442e223b') [19:11:56] hmm ok [19:11:58] that's very odd [19:12:10] (what you pasted is fine, just some caching stuff. What's odd is the lack of ATTACH) [19:12:15] all-uppercase [19:14:55] what about using $wgSharedTables [19:15:49] the default is correct [19:16:27] LEFT JOIN ETQW_stuff_wiki.user ON ((rev_user != 0) AND (user_id = rev_user)) WHERE page_namespace = '8' AND page_title = 'Gadgets-definition' AND (rev_id=page_latest) LIMIT 1 [19:16:28] 2017-12-29 19:08:17 mind admin_wiki: SQL ERROR: no such table: ETQW_stuff_wiki.user [19:16:42] is that a reference so the gadgets extension? [19:17:00] yes [19:17:04] because I enabled it on the install of the new wiki but not the old one [19:17:06] well [19:17:07] maybe [19:17:24] were you browsing the page MediaWiki:Gadgets-definition at the time actively? If no, then that was the ext [19:17:31] so maybe disables it? [19:17:32] no [19:17:39] the wiki simply doesnt load at all [19:17:54] remove shared database, it loads just fine [19:18:30] k, you can disable query logging for the time being (set DebugDumpSql to false) [19:18:56] what version of mediawiki are you using? [19:19:18] 1.29.1 [19:19:22] ok [19:19:23] I used the same for both [19:19:35] would bootstrap on the original one do anything? [19:19:40] no [19:19:44] give me a bit [19:19:47] okay [19:19:50] thanks for your help [19:19:55] (where by "a bit" I mean like half an hour, so maybe take a break :P) [19:22:24] okay [19:23:11] I set my alerts [19:40:03] ressected: replace the file includes/libs/rdbms/database/DatabaseSqlite.php with http://termbin.com/cf7q [19:40:28] I'll work on getting it patched in core [19:40:39] Skizzers, you got it, one moment [19:40:47] you can get rid of the debug logging stuff too [19:40:56] ok [19:44:35] ressected: in the meantime, don't upgrade to 1.30 or a future version as it will roll back that fix. Follow https://phabricator.wikimedia.org/T181962 for more details on when the fix makes it into core (likely 1.31) [19:47:00] Skizzers, ok great thank you [19:51:55] Skizzers, it did work, by the way [19:52:10] :) [19:57:08] Skizzerz, now to get cookies to pass to prevent second login prompt [20:00:43] logging into one cause it to log out of the other [20:09:36] nevermind I got it [20:19:29] Skizzers, again thanks for your help. I have a game mod project going with people fro mall corners of the world and this helps us move forward in collaborating [21:54:09] Приветствую всех. Не могу понять как в своей вики создать категорию. Просто добавить в конце странице шаблон категории и она(категория) сама будет создана? [22:02:40] Справку читал. Но все равно не могу понять как бы. [22:40:24] таки вроде разобрался. [22:43:55] sorry Spiker01, i think nobody here speaks russian :( [23:00:19] I could not create a category. But after a while, then I understood.