[03:12:05] is there a way to see what terms people are searching in our wiki (from the search box)? [03:32:46] cpg: Your Web server probably has access logs. [03:42:46] For some reason, I can’t edit or create new pages on my wiki. What’s wrong? http://phoenix.wolfie-sims.com/wiki/index.php?title=Main_Page. I just moved it over from it’s old location and the files are still there grabbing the info from the same SQL database. [03:54:20] Help [03:54:57] http://enciclosaez.vzpla.net/index.php/P%C3%A1gina_principal Database error... [03:57:35] After installing Echo, WikiEditor, Check User, ConfirmEdit [04:00:23] I just uninstalled them [04:00:26] in LocalSettings.php [04:00:31] Thanks anyways [04:21:32] I’m still getting a blank screen when trying to edit, can anyone help, please? [04:27:03] Emily2: It's working fine for me. [04:27:33] When you login and try to edit it gives a blank white page. [04:57:35] !blankpage [04:57:35] A blank page or HTTP 500 error usually indicates a fatal PHP error. For information on debugging (including viewing errors), see . [04:57:38] Emily2: ^ [04:58:04] thank you [09:36:07] hi all, how do I get something like https://en.wikipedia.org/wiki/Special:Version in my mediawiki installation ? [09:36:22] do I need to install some extension or something to view that ? [09:37:37] if your wiki is up, it already has a Special:Version page [09:47:47] RobotsOnDrugs: umm... where it would be ? http://wiki.hamaralinux.org/mediawiki/index.php/Main_Page [09:48:20] http://wiki.hamaralinux.org/mediawiki/index.php/Special:Version [09:48:54] cool thanx. [12:34:25] https://www.digitalocean.com/community/tutorials/how-to-install-mediawiki-on-ubuntu-14-04 <-- "Change the first highlighted variable to your chosen database name, the second variable to the username you want to use, and the last to a secure password." ... So this is a different password from the one I needed to type in when I did `mysql -u root -p` ? [12:39:31] Cancel that, sorry [12:40:49] http://pbrd.co/1IHC5u8 <-- I've got a 'Binary/UTF' decision well setting up my wiki. Not sure what to choose here. [12:41:41] I'm going to be importing a mediawiki into this, so I'm not sure if I need to look at whether that uses binary or UTF8 [12:41:49] I'd go for UTF, but I suppose it's your call [12:41:55] UTF8 sounds like a more sensible option, I don't see why it isn't the default [12:46:09] Sorry, I wasn't reading the '?' next to the fields. I've been wishing forms would provide those '?' for so long that I don't even notice when occasionally they do. [13:59:14] pi-: Did the setup go fine? :) [15:49:39] Hi MWikians! I am trying to create tables automatically for an extension after it is installed. For this I have added the code in the home page of my extension to create tables . [15:50:15] I have also added the code for foreign keys but that gives error if the page is refreshed. [15:50:59] I mean the code for foreign keys should be run only once. How can I do that? Any ideas? [15:52:22] Use include_once? [15:52:34] (If this is PHP) [15:52:53] yes this. [15:53:12] Alright thanks! Let me see if that works. [16:04:03] Hello. I have a calculation problem [16:04:27] Normaly I can calculate with + - / * but it is not possible with % [16:04:30] Grain grows in 20 hours In a greenery it grows 15% less How do I calculate that with mediawiki [16:05:26] {{#expr:20*0.85}} [16:05:52] Ok thanks [16:06:20] Np :) [16:15:29] Hey! I tried installing a couple extensions on a Windows MediaWiki installation (namely, I couldn't make ConfirmAccount and the Language Bundle work), but failed. I was thinking of buying a DigitalOcean account. [16:15:49] Is there anyone around with experience with DigitalOcean? [16:20:40] What error messages do you get when you attempt to install the extensions? [16:20:48] @alimula [16:21:11] Caliburn, the ConfirmAccount one [16:21:27] returns error 500 when sending the request account form [16:21:48] That's strange [16:22:06] Have you run update.php? [16:22:09] Yes [16:22:12] It went okay [16:23:58] Caliburn, I tried to use the IIS logs, but I couldn't find any error in there [16:24:05] the whole Windows thing is confusing :-P [16:24:14] Have you defined the file store variables? [16:24:35] +What editor are you using to edit the files? [16:25:03] Notepad++ [16:25:13] Yes, I did define them [16:25:29] I could give you Remote Desktop Access, if you want [16:25:37] Is it a publically available wiki? [16:25:42] Yes [16:26:20] Can you link in PM? (so I can see if it works for me) [16:33:40] Caliburn: I used include_once but my requirement is a bit different. [16:34:15] Are you including an external PHP file? [16:34:17] I want some code to execute just once throughout lifetime. [16:34:22] Ahhh [16:34:43] I mean suppose I access my home page [16:34:53] so the tables will be created [16:35:10] but when I again visit homepage I get error [16:35:18] table already exist. [16:35:48] Caliburn: Any wayout? [16:36:20] Have you deleted the include_one from your file? [16:36:36] no [16:36:52] albert_coder: if the extension should set up something on the database only once in the lifetime of the wiki, it must be done during install [16:37:19] yes Vulpix I am trying to do exactly the same. [16:37:20] you should use one of the hooks provided for the installation process [16:37:52] !hook [16:37:52] https://www.mediawiki.org/wiki/Manual:Hooks/ [16:37:58] !hooks [16:37:59] Hooks allow you to run functions at various points in the main MediaWiki code. For more information about using hooks in MediaWiki, see . [16:38:55] Alright thanks :) but is there any other way to run some code only the first time a page is visited other than using hooks? [16:39:17] Actually I havent used hooks before but want this done within a few minutes. [16:39:27] Kind of emergency. [16:39:43] albert_coder: https://www.mediawiki.org/wiki/Manual:Hooks/LoadExtensionSchemaUpdates [16:41:29] well, the only way to do that without a hook would be to read something on the database to see if your modification is already done, and if not, do it and update the value so the next check doesn't attempt to run it again [16:43:37] yes, trying to do the same but unsuccesful. [16:44:29] Let me find some way. Anyway thanks :) [16:45:24] albert_coder: in this case I'd say that doing the things /right/ will be faster than trying to avoid a hook ;) [16:46:20] point :P Alright I will try using it. [17:29:46] How do I make MediaWiki to create a new page by url, instead of returning me a 404 error? [17:31:37] alimula: what do you mean with "create by url"? [17:31:40] alimula: It should allow you to create that page. Maybe the url you typed was invalid? [17:32:09] alimula: copy the url of an existing page and change only the last part after / -character. [17:32:31] Nemo_bis, ie. if I were to type mywiki.com/wiki/Test, I'd like it to start a new article with that title [17:32:48] alimula: just by opening the URL? [17:32:52] yea [17:32:58] It's odd. On some installations I did, this worked [17:33:02] On others, it didn't [17:33:06] GET is not supposed to modify the databse [17:33:38] just click the "create" link on that page [17:36:08] Nemo_bis, I was not saying that. It's just that, on some MediaWiki installations, instead of redirecting to ~/index.php?title=Test&action=edit&redlink=1 [17:36:14] it would just show up a 404 error [17:42:28] I'm not aware of any installation doing that redirect automatically [17:48:41] Vulpix: Using a hook was great! :) [17:49:01] :) [17:50:01] I have been able to create tables using hook but the .sql file also contained code for foreign keys but I guess that did not work. [17:52:30] What should be done to link foreign keys? [17:53:30] albertcoder: the updater->addExtension* methods check in the database if a table/field/index exists, and if not, it executes the specified sql. That sql file may contain additional modifications not being checked [17:54:37] Does this mean that everything we need to change with the database needs to be coded in the sql file? [17:54:40] the test is done assuming you would add patches incrementally. So if you add 5 new fields in one patch, you can add them in a single sql file and test only for the existence of the first field, since you could assume that if it exist, all others will exist as well [17:55:31] if you added fields in 2 different patches, then you need to maintain them separate [17:56:08] https://bpaste.net/show/0fea299283aa [17:56:17] I wish to make these changes. [17:56:50] and you may see the foreign keys in the end [17:59:49] albertcoder: a key with the same name is added also in the create table statement [18:02:44] Hi guys. I have a problem to solve. I want to write a wiki that will be my app's manual. But I don't want it to be public. I want to create a link on my app that will connect and authenticate to my wiki. How can I do that? [18:03:10] Vulpix: Did not understand. You might have understood what I want to do. Please tell me how to proceed. Am I doing something wrong in the sql file? [18:04:33] albertcoder: when you said "but I guess that did not work", could you please elaborate? From my understanding, the way the hook works, it should work. If you got a sql error it was probably a fault on the sql file [18:05:18] Okay, I meant that the hook did not link the foreign keys. [18:05:26] The tables are still unlinked. [18:07:00] albertcoder: in the create table statement you create an index called FKdensity, then you add at the end of the file a new constraint named FKdensity, but that name is already used for a key. My guess is that the add constraing will fail because there's already an existing key with the same name [18:09:21] Alright. Thanks for the catch. I think I should do some home work on this and then come back if still unsolved. :) [18:09:50] if the hook created the tables, at least it seems it works [18:10:01] yeah :) [18:10:34] Someone? [18:11:34] racquad: I don't think that would be feasible [18:12:56] Vulpix, why? [18:13:15] racquad: what user account would be used for authentication? a fixed account? a login requires user and password. That would mean you would hardcode those credentials on your app, and anyone could sniff the traffic and see the password, effectively compromising that account [18:14:25] what if I use htaccess to control my visitors? [18:14:55] So anyone from exampledomain.com would have access to my wiki. Everyone else would by blocked with a classic "Forbidden access" message [18:15:40] what kind of app is it? a mobile app? [18:15:49] racquad: what's the point? referrer can be easily faked [18:16:01] Vulpix: is a web app [18:16:20] Nemo_bis: yes, it can... that's why I was looking for something coded inside mediawiki [18:17:12] I was thinking about exchanging tokens, somewhat like oauth [18:18:09] racquad: well, assuming the communication is done in the server (and not in the client), you could use credentials to access it and they won't be compromised... Or better, use SSL and a client-server certificate [18:19:05] Vulpix: I don't have SSL yet.... unfortunately. The communication will be between servers only [18:19:41] If a user clicks on the wiki link inside the app, it will send and authentication token to mediawiki. It will validade that token and will allow (or forbid) access. [18:19:57] Is that possible? Is there any extension that could do that? [18:22:00] racquad: I was thinking: app use the wiki's api to retrieve the HTML contents, and the app displays it (adding additional formatting). The client never access the wiki directly. You can allow access to the wiki only from the app server, then [18:22:14] !api [18:22:14] The MediaWiki API provides direct, high-level access to the data contained in the MediaWiki databases. Client programs should be able to use the API to login, get data, and post changes. Find out more at < https://www.mediawiki.org/wiki/API >. For client libraries in various languages, see < https://www.mediawiki.org/wiki/API:Client_Code >. [18:23:01] Vulpix: that would be fantastic. I will see the docs. [18:23:15] I'm sorry, i'm kind new on mediawiki. Does the API allow searches also? [18:23:28] yes [18:24:32] Vulpix: Perfect! [18:33:41] Caliburn: yep, now for the fun part (transferring wiki across) [18:37:57] I need to convert time to: 1 hour = 60 minutes; 20 hours = 1200 minutes; 15% of 20 hours = 180; 1200-180=1020! But I can not make this in Wiki. I got the code: {{#expr:20*0.85}} but this only takes the percentage of a number, not time. So what am I doing wrong [18:40:43] Rodejong: https://www.mediawiki.org/wiki/Help:Extension:ParserFunctions#.23time [18:41:16] When something grows 15% faster then 15 minutes, it should show 12m40 [18:41:23] Ok, I'll look [18:43:24] Vulpix: This only shows how to format time and date. Not how to calculate with it [18:44:17] you'll need to join concepts. Format time --> do calculations --> format time back into your desired display format [18:44:47] that won't be easy, though [18:46:20] Yeah,,I figgured :D Have been on this the whole afternoon. I'm not that great at math hahaha [18:46:58] So how do I do the format from number to time, so I can calculate with it? [18:47:57] well, actually I think that the time functions won't be helpful here, since you aren't calculating timestamps [18:49:32] http://www.wiskundeleraar.nl/page3.asp?nummer=8175 [18:49:44] (It is in Dutch) [18:50:06] But I would like to know, if I can make this work in Wiki [18:51:53] you should do all calculations using the expr parser function [18:53:08] Can you give one example as to how I should do that? [18:53:22] I would like to make a template out of it [18:54:43] !not [18:54:43] Templates are not for programming. [18:55:35] hi - a question about the visual editor - i notice annotations are to be addressed (I see it in VE code) -- has a decision about RDFa vs Microdata been made yet? thanks [18:57:00] !not [18:57:00] Templates are not for programming. [18:57:07] why is that? [18:57:25] To vunerable [18:57:42] too vulnerable to...? [18:59:45] Extension for playing mp3 files within the File: page? [18:59:48] using templates for programming is like running a Turing machine [18:59:50] Is there such a thing? [19:01:29] alimula: https://www.mediawiki.org/wiki/Extension:Mp3Handler [19:01:42] don't blame me if it doesn't work on your wiki :) [19:03:21] ok - back to VE - am I wrong to think VE is aiming to support annotations either via RDFa or Microdata? [19:04:06] hmm [19:04:25] Vulpix, are you sure loading something like File:Song.mp3 would load the player? [19:05:04] alimula: I don't really know. I've just searched for a mp3 player extension and found that [19:05:30] Mehehe [19:05:32] Did that too [19:05:37] But couldn't find one that does this [19:23:48] I'm trying to locate mediawiki on my ubuntu VM's filesystem. However I can't find the terminal commands I used to install it: http://hastebin.com/uhazonases.avrasm [19:24:01] Where is it likely to be located? [19:28:27] pi-: you have: nano /var/www/html/LocalSettings.php [19:30:45] thats it! thanks [19:36:47] found that parsoid is doing rdfa not microdata [19:50:34] I've done something like `mysqldump -u user --password=password --xml database_name > file.xml` -- I can't remember the exact syntax but I have the .xml. How do I import it into my new wiki database? [19:52:10] Hi! So I just installed Debian 8 and am building a brand new wiki, but navigating to ip/mediawiki just brings me a 404. [19:53:01] crhylove: if you're using the Debian package, please contain whoever maintains it. it's not us. :) [19:53:04] !debian [19:53:04] While there is a MediaWiki package in the Debian/Ubuntu repositories, you should probably not install it. It's very out of date, and we can't necessarily help you with it. Please see https://www.mediawiki.org/wiki/Debian/Ubuntu for how to get MediaWiki running on your machine. [19:53:22] contact* [19:53:48] ok. Thnx. [20:07:07] Looking through http://www.mediawiki.org/wiki/Manual:Restoring_a_wiki_from_backup -- `mysql -u wikidb_user -p wikidb < dump_of_wikidb.sql` -- should I be using wikidb_user=root? [20:08:23] How do I get my wiki to display the side navigation regularly without the hidden categories and the carrot dropdowns to the regular side navigation? http://phoenix.wolfie-sims.com/wiki/index.php?title=Main_Page [20:16:43] Emily2: from tonight you're making the question [20:17:55] What? [21:43:37] Heya - is there a way to view users who are not blocked? [22:30:22] Hey - I'm using recapatcha now but 10 bots managed to register today, it seems to be working (I see a capatcha) require_once "$IP/extensions/ConfirmEdit/ConfirmEdit.php"; <-- I've left this line in the config file, does this allow the non-capatcha way to still work? [23:50:50] Hello guys, my question is: How can I force the rerendering of a math formula inside ...? Reason for my question: I write a math textbook in German where I need some non ASCII-characters in formulas (something like "ä" or "ß"). It works fine now, but there are some old formulas which are cached. [23:52:19] For example https://upload.wikimedia.org/math/d/8/2/d828b862f5a00be0c4d4bee7406a325b.png is well rendered formula whereas in https://upload.wikimedia.org/math/5/c/8/5c837597114cdbfeef8602390c3d5eac.png some non ASCII-characters are missing [23:54:38] I know, one can use action=purge for pages. Is there something similar for cached formulas?!