[00:00:20] also: http://test.wikipedia.org/wiki/Special:AllPages/%E2%80%AD that one shows up as "THIS" in some cases, with the RTL override thingy [00:00:40] special:activeusers will look a lot cleaner [00:01:15] new special page planned? [00:01:36] ok, i'm gonna run out for the evenin' [00:01:41] see y'all [00:01:48] cya [00:02:14] bye [00:07:48] can someone update http://en.wikipedia.org/wiki/MediaWiki:Listusers-summary ? [00:24:19] Hrm. I am contemplating an extension that can remap a whole bunch of redirects whenever a table is edited on a specific page. Maybe a script could do this? [00:25:06] I have an category page: wiki/index.php/Category:Filesystem_Plugins. When I go there and click on histoy, I get: http://127.0.0.1/?title=Category:Filesystem_Plugins&action=history and my browser complains it cannot connect to server 127.0.0.1 [00:25:06] Anyone seen this problem before? [00:25:11] I have a need to redistribute a bunch of redirects on a fairly regular basis. Ideas if an extension is the way to go? A script maybe? [00:26:14] Plop5: what browser? [00:26:36] Firefox or IE no difference.. other users have the same problem [00:26:43] wierd [00:26:51] certainly [00:26:58] just a few or near everyone? [00:27:06] everyone [00:27:50] set $wgServer [00:28:08] is that for me? [00:28:13] assumedly [00:29:03] shall investicate, later [00:30:28] wb aaron [00:44:10] 03tstarling * r34486 10/trunk/extensions/CentralAuth/ (11 files in 2 dirs): Revert revert plus Werdna's fix as per wikitech-l [00:49:45] 03(mod) Request for New User Group to be created, to create account Requests. - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=13498 (10cometstyles) [01:04:54] 03tstarling * r34487 10/trunk/extensions/CentralAuth/CentralAuthUser.php: Forgot to actually patch it... [01:13:37] 35 .flaggedrevs_preview Value Error : color darkred is not a color value : darkred [01:13:41] *AaronSchulz sighs [01:18:59] 03aaron * r34488 10/trunk/extensions/FlaggedRevs/flaggedrevs.css: Lame w3c errors [02:04:30] *Charitwo waves [02:04:57] 03river * r34489 10/trunk/imgserv/imgserv-server/ (5 files in 4 dirs): [02:04:57] - add mkdist script [02:04:57] - allow binding to a specific port/address [02:19:33] 03(mod) SpecialUserlogin. php only save settings if there is a change in rememberpassword - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=13963 (10stronk7) [02:50:50] 03(NEW) Consistency of used tabs - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=14054 15enhancement; normal; MediaWiki extensions: FlaggedRevs; (Wiki.Melancholie) [02:57:02] 03(WONTFIX) Consistency of used tabs - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=14054 +comment (10JSchulz_4587) [03:09:48] 03(NEW) Show #mw-revisiontag-edit box only if necessary - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=14055 15enhancement; normal; MediaWiki extensions: FlaggedRevs; (Wiki.Melancholie) [03:21:10] is there a reason i cant use both from= and until= on the same category? [03:38:45] 03river * r34490 10/trunk/imgserv/imgserv-client/imgserv.cxx: should be possible to guess file type from extension [04:12:34] 03nad * r34491 10/trunk/phase3/config/index.php: Fix JS, can't access properties of non-existent objects [04:26:42] how does MW put the final output out and how is it managed at run time? i'm not an MW hacker but want to know about it for my code... [04:27:37] do you use DOM to do that? [04:28:07] ????? [04:40:22] is this a graveyard i've just joined????? [04:41:55] msless: there are on times and off times [04:43:43] so what is the on time? [05:06:55] ^_^ When you hit the light switch... [05:07:04] Ack... left [05:07:20] *DanielFriesen wanted to make a zombie comment... T_T [05:34:30] Is there a way to revert all of the changes in a MW wiki after a certain date? [05:34:37] I have a wiki I'd like to send back to April 16, 2007. [05:35:38] Hm, not really. [05:35:51] There are extensions that can aid in wiping things off. [05:35:54] !e Nuke [05:35:54] --mwbot-- http://www.mediawiki.org/wiki/Extension:Nuke [05:37:15] 03nad * r34492 10/trunk/phase3/config/index.php: Preparing for MSSQL database support coming soon [05:39:24] O_O [05:39:35] bleh... already [05:45:42] 03(FIXED) Support for global groups - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=13773 +comment (10Andrew) [05:47:24] when i enable $wgCustomConvertCommand without redirecting output to /dev/null, i get fastcgi protocol errors when an image is scaled [05:47:33] is it not capturing output properly? [05:57:25] 03vasilievvv * r34493 10/trunk/extensions/CentralAuth/migrateStewards.php: Add migrateStewards.php to copy stewards to global groups table [06:03:19] flyingparchment, Try passing the output to stderr instead of stdout. [06:06:05] 03(NEW) -tag inserted into unstable revision - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=14056 normal; normal; MediaWiki extensions: FlaggedRevs; (rfj) [06:12:12] 03werdna * r34494 10/trunk/extensions/CentralAuth/migrateStewards.php: Fix patch - needs to invalidate the cache of stewards added to the group. [06:18:10] 03werdna * r34495 10/trunk/extensions/CentralAuth/migrateStewards.php: Doesn't need this [07:11:51] <_wooz> lo [07:26:02] can anyone explain this to me: [Fri May 09 01:23:27 2008] [error] [client 207.44.147.74] Request exceeded the limit of 10 internal redirects due to probable configuration error. Use 'LimitInternalRecursion' to increase the limit if necessary. Use 'LogLevel debug' to get a backtrace. [07:26:28] is that on accessing index.php? [07:26:57] that's in my error logs [07:27:21] on my wiki i can't access pages that have many uses of the tag's [07:28:09] hmmm I dunno about I thought maybe a friendly urls/rewrite rules thing... [07:30:27] how can I go about downgrading from the alpha to 1.12 [07:30:30] safely [07:34:30] There isn't really anything made for downgrading [07:35:14] what will happen if i replace the installation with 1.12 and re-run the installer [07:35:16] or update.php [07:35:23] For the most part you'll probably have to take a look at updaters.inc and see what was changed in the database for the upgrade... And manually undo that [07:35:29] Nothing [07:35:56] 1.12 won't understand that you have schema updates meant for 1.13 already setup [07:36:12] And it'll say it's all ok because you already have all the pre-1.13 stuff there [07:36:33] It really depends on the release [07:36:38] ok [07:37:02] Sometimes shema changes made will break when used on an older version, and sometimes not [07:37:16] ok [07:37:21] i've been seeing this too: "Zend Optimizer for PHP 5.2.x cannot be found (expected at '/usr/local/Zend/lib/Optimizer-2.5.10/php-5.2.x/ZendOptimizer.so')" [07:38:43] Well it's a php issue... [07:39:09] I expect you have php.ini setup to use the zend optimizer and since it's not there it's failing [07:39:28] the only thing i changed in php.ini recently was memory_limit [07:39:41] You upgrade recently? [07:40:06] yes [07:40:22] and i had to increase memory limit a lot to get it to even work [07:40:22] 03huji * r34496 10/trunk/phase3/ (2 files in 2 dirs): [07:40:22] * Adding/updating Persian translations [07:40:22] * Adding the newly added message to messages.inc [07:40:24] Then that's the problem... [07:40:45] When you upgraded the Zend Optimizer wasn't upgraded to a compatible version allongside it [07:40:53] ah ic [07:41:40] T_T Why is it that I can theorize what other peoples issues are... But I always have issues with my own [07:41:52] :p [07:42:38] and this? "PHP Startup: Unable to load dynamic library './php_cpdf.dll' - ./php_cpdf.dll: cannot open shared object file: No such file or directory in Unknown on line 0 " [07:43:03] How do you have PHP installed? [07:43:22] shared host [07:43:27] Oh [07:43:49] ^_^ Then this is their fault for not maintaining upgrades right [07:44:24] what can I tell them to get them to fix this? [07:44:26] Dan: that's like asking "Why is whatever I need always in the last place I look" [07:45:04] (answer: because you stop looking when you find it... derivative answer: your issues are those things you don't solve on your own before they become issues) [07:49:03] 03huji * r34497 10/trunk/extensions/Translate/MessageGroups.php: Adding SkinPerPage to the list of extensions used by Wikimedia (it is used on Foundation wiki). [07:51:18] can anyone recommend a shared vps that allows multiple sites/domains and sql databases? [07:52:16] VPS... O_O [07:52:28] What kind of crappy VPS are you on [07:52:36] bluehost.com [07:52:39] just regular shared hosting [07:52:49] Then you don't know what VPS is [07:52:57] VPS Virtual Private Server [07:53:04] You control the entire server [07:53:07] i wasn't saying i was on vps now [07:53:08] lol [07:53:18] ^_^ You still misunderstand [07:53:30] i understand that in a vps you control everything [07:53:33] that's what i need apparently [07:53:35] VPS hosting doesn't host you sites, domains, or databases [07:53:43] oh [07:53:43] ^_^ You are the one that controls that [07:53:43] ic [07:53:54] so you can put 1000 there if you want? [07:54:15] ^_^ Absolutely infinite within the confines of how much disk space, ram, and the CPU can handle [07:54:29] I'd suggest LiNode [07:55:16] ^_^ And if you want... I can even show you a way to get NGINX to use beautifull short urls if you want to use a lightweight WebServer instead of Apache [07:56:22] i wish i knew what all that meant :p [07:56:28] Heh [07:56:46] You're going to have to know a little if you're going to handle your own environment [07:57:02] yes, or I could hire someone.. [07:57:04] WebServer, to database, all the way through to the mailserver... [07:57:09] Heh, ya, that to... [07:57:10] since i've got a slow learning curb [07:57:26] ^_^ I like my quick scripts [07:58:11] ~/mwman create-wiki [-n short id] [-c config-file] [-l link-version] [-e extension-type] [-d database-name] [-a] [08:00:09] what do you think it would cost to have someone setup a small wiki-farm on a vps server? [08:01:03] Don't know... a little hefty as they have to do everything from setting up all the things being depended on and so much more [08:01:22] yah.. [08:01:25] I've had my VPS for I think a Month now and I've still got stuff to do [08:01:31] heh.. [08:01:43] ;) Unlucky for you I just got a programming job [08:01:47] how about getting someone to help me revert back to 1.12 from alpha [08:02:08] since i can't keep up with wikipedia :p [08:02:32] Why not just wait a few months... Then upgrade to the 1.13 release? [08:02:51] because all my pages with tags don't load [08:03:03] http://bahaikipedia.org/Main_Page [08:03:05] Hmmm.... [08:03:10] normal [08:03:12] while: http://bahaikipedia.org/Bah%C3%A1%27%C3%AD_Faith [08:03:15] doesn't work [08:03:18] since it has a lot of ref tags [08:03:26] and trying to save a {{reflist}} doesn't work [08:03:39] Arg damn machine [08:04:19] Null urls!! Evil!!!! [08:04:37] ^_^ Action paths ftw! [08:04:44] what? [08:05:34] Null urls, ie paths in the form: http://example.org/Article [08:05:48] what are action paths [08:06:01] "Null article paths" are more meaningful X_X [08:06:08] Action paths are a little less commonly used... but similar to short urls [08:06:20] http://example.com/wiki/Article is a short url [08:06:31] i don't like /wiki lol [08:06:37] ^_^ This is a action path: http://dev.wiki-tools.com/edit/Main_Page [08:07:09] It basically means that for various actions like edit and such... You don't need the long /index.php?title=...&action=edit [08:07:17] ahh ic [08:08:11] Hmmm... lets see if your Null urls are the data breaking kind, or the mw breaking kind [08:08:25] lol, i've never had a problem with them before [08:08:31] MW breaking [08:08:38] http://bahaikipedia.org/robots.txt [08:08:59] ? [08:09:12] http://bahaikipedia.org/Robots.txt [08:09:31] ic [08:10:00] It would be worse if you had first-letter caseinsensitivity off [08:10:26] Then someone could create an article called [[robots.txt]] and it would be hard to delete unless you knew what you were doing [08:10:35] ic [08:11:26] Well... at least you're not using the data breaking form, where things like robots.txt and favicon.ico end up at MW pages and end up sending false data to clients asking for special data [08:11:52] heh [08:11:57] except i can't access half my wiki lol [08:12:04] null article path for the lose [08:12:06] any page with a decent number of tags won't load [08:12:06] heh [08:12:28] checked your php log? [08:12:32] yes [08:12:36] two errors over and over [08:12:41] Which ones? [08:12:42] one about not being able to access zen [08:12:44] Oh [08:12:46] those [08:12:54] PHP Startup: Unable to load dynamic library './php_cpdf.dll' - ./php_cpdf.dll: cannot open shared object file: No such file or directory in Unknown on line 0 [08:12:56] yah [08:13:01] and Zend Optimizer for PHP 5.2.x cannot be found (expected at '/usr/local/Zend/lib/Optimizer-2.5.10/php-5.2.x/ZendOptimizer.so') - try reinstalling the Zend Optimizer in Unknown on line 0 [08:13:09] ^_^ Then ya... VPS ftw [08:13:14] lol [08:13:25] or trying to revert to 1.12 and just being happy with that [08:13:27] which i'm fine with [08:13:28] When you change it might be an idea to use short urls instead of the null ones [08:13:30] if I knew how [08:13:30] 03(NEW) Wrong time stamp in signature - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=14057 minor; normal; MediaWiki: General/Unknown; (ulfhinze) [08:13:45] ok [08:13:53] You can create a 404 page like Wikimedia's to help direct people to the new article urls [08:14:07] yah [08:14:59] Splarka ^_^ notice how action paths are working nicely for me......... And i'm not using Apache... heh ;) [08:15:48] well, actions aren't null at least [08:15:56] Ya [08:16:06] ah, i finally got a guy at bluehost [08:16:14] who said those errors are server wide [08:16:15] and could belong to anyone [08:16:15] I quite like the ability to change /wiki/ to /edit/ [08:16:36] IMHO MediaWiki is best served out on VPS [08:16:40] looking in the correct area and my error is "PHP Warning: require_once(/home/bahaikip/public_html/extensions/EditCount/EditCount.php) [function.require-once]: failed to open stream: No such file or directory in /home/bahaikip/public_html/LocalSettings.php on line 169 " [08:17:08] Anything above a reall small installation and you're going to want things like Memcached [08:17:31] ^_^ Then ref isn't your issue [08:17:42] 03raymond * r34498 10/trunk/ (5 files in 5 dirs): Localisation updates German [08:17:51] i'll disable editcount then [08:17:54] Yup [08:17:58] wait a second [08:18:40] Oh nevermind [08:19:15] Just checking to see if the issue was actually affecting all your pages and things were working just because of a cache [08:19:27] I get that kind of issue a lot [08:19:33] And DNS is annoying [08:19:44] ah [08:20:15] ^_^ My PHP FastCGI instance goes down sometimes... I've goten used to "~/php start" allot [08:20:17] heh [08:20:23] *Dantman|FS needs to get God running [08:23:36] no luck [08:24:51] how about Fatal error: , referer: http://bahaikipedia.org/Main_Page [08:24:53] 03(mod) -tag inserted into unstable revision - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=14056 (10rfj) [08:34:58] what is zend_mm_heap corrupted [08:39:17] i can't get the "out of memory" errors to go away [08:39:25] no matter how much I put in the memory_limit [08:39:27] Allowed memory size of 134217728 bytes exhausted (tried to allocate 111677441 bytes) in /home/bahaikip/public_html/includes/Preprocessor_Hash.php on line 1360 [08:43:04] Your host probably doesn't allow you to raise the limits past a specified limit of theirs [08:44:18] limitimits [08:45:26] ic [08:45:29] so i'm screwed :p [08:45:46] Does anyone know if it's possible to have WhitelistPage call on an external page like Special:Allowedpages [09:03:19] thanks for all your help guys [09:26:24] 03(mod) Interwiki map update - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=12763 (10andrew) [09:27:14] 03(NEW) Pipe trick doesn' t work for interwiki prefixes with dashes in them - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=14058 15enhancement; normal; MediaWiki: Page rendering; (roan.kattouw) [09:37:09] 03(mod) Interwiki map update - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=12763 +comment (10dan_the_man) [09:39:53] 03(mod) Pipe trick doesn' t work for interwiki prefixes with dashes in them - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=14058 15enhancement->normal; +comment (10dan_the_man) [09:42:06] 03catrope * r34499 10/trunk/phase3/ (RELEASE-NOTES includes/api/ApiQuerySiteinfo.php): (bug 14028) Added language attribute to interwiki map in meta=siteinfo [09:42:50] 03(FIXED) Differentiate between interwiki and interlang links in siprop= interwikimap - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=14028 +comment (10roan.kattouw) [09:46:35] 03(mod) Pipe trick doesn' t work for interwiki prefixes with dashes in them - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=14058 +comment (10roan.kattouw) [09:52:15] hi [09:52:32] is there an easy way to remove table prefixes from a database? [09:55:56] yea mean easier than renaming each table? [09:59:27] yes [09:59:57] though renaming is fine if it keeps all the dependencies working [10:00:15] it does [10:00:47] 03catrope * r34500 10/trunk/phase3/ (3 files in 2 dirs): (bug 14022) Added usprop=registration and auprop=blockinfo [10:00:58] 03(FIXED) auprop and usprop are inconsistent - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=14022 +comment (10roan.kattouw) [10:02:12] so if i just run a bunch of ALTER TABLE RENAME commands on a mediawiki database and then remove the table prefix in localsettings.php it will keep working? [10:02:30] tgr: I think it should [10:02:40] I never tried it of course ;) [10:03:14] !b 14058 | TimStarling [10:03:14] --mwbot-- TimStarling: https://bugzilla.wikimedia.org/show_bug.cgi?id=14058 [10:07:16] 03btongminh * r34501 10/trunk/phase3/includes/Preprocessor_Hash.php: Disable debug statements which make the debug log totally unreadable. [10:09:42] I'm writing a mediawiki extension, I was wondering if there is a function for redirecting to another page when a page is called [10:09:48] bryan: Weet niet of je het gezien hebt, maar die rare foutmelding van jou is gefixt [10:09:58] zsh: Probably in OutputPage [10:10:03] !c OutputPage | zsh [10:10:03] --mwbot-- zsh: I don't know anything about "c". You might try: !adminsettings !answer !bizzwiki !centralauth !cms !csshideheader !debug !domdocument !dpl !dumphtml !feeds !imagemagic !interwiki !ldap !renameuser !rewriteproblems !smtp !thanks !threads !webrequest [10:10:07] ja ik zag het :) thanks [10:10:09] Argh [10:10:22] !class OutputPage | zsh [10:10:22] --mwbot-- zsh: See http://svn.wikimedia.org/doc/classOutputPage.html [10:11:41] RoanKattouw: thanks. [10:11:52] Was iets gestoords met Database::tableName() die foo.bar=baz escapete als foo.`bar=baz` of zoiets [10:14:03] Dus heb ik als workaround eerst heel veel `s toegevoegd om tableName() ervan te overtuigen dat alles al escaped was; daarna heeft DanTMan tableName() gefixt en konden die `s weer weg [10:15:34] Erm... that bug is already fixed [10:15:54] Do a svn update I say [10:17:21] 03huji * r34502 10/trunk/extensions/ (10 files in 10 dirs): * Adding/updating Persian translations [10:18:17] Dantman|FS: Yes, it is, that's what I was saying [10:18:54] Looked like you were giving information on the workarround to the issue [10:19:22] ^_^ meh... you can only decipher part of a message in a foreign language [10:19:27] I know, I'm sorry [10:20:51] Dantman|FS: What's your native language then? [10:21:10] ^_^ Heh... English of course [10:21:34] I have learned a small bit of German, but not enough to understand anything [10:22:15] OK... just asking because your WHOIS says your name is Daniel Friesen, which sounds German, but could also be Scandinavic [10:22:30] ^_^ Also, with all the anime I watch in subtitles, I can't make a real full sentence, but I can understand a decent bit of it [10:22:32] Or 7th-generation immigrant of course ;) [10:22:37] Heh... [10:22:47] German on my dad's side [10:23:04] Well partly [10:23:25] ^_^ I'm also British on my moms [10:23:42] Heh.. German and British... collision anyone? [10:24:31] Btw... Last name Friesen, but the last name on my mom's side is Churchill ;) [10:25:14] hmm Article::isRedirect should actually be called Article::isValidRedirect [10:26:11] Is there an equivalent to Article::doRedirect() that redirects to an article's edit page? or do i have to create a url to the articles edit page then use OutputPage? seems a bit messy to me... [10:26:51] zsh: it's not messy, you can use the functions in the Title object to generate the url [10:26:58] I dunno, but I can tell you that xyRedirect() is a total mess [10:27:57] Duesentrieb: ok. just checking to see if there is an easier || better way [10:28:21] maybe there is, i don't know :) [10:30:42] 03rotem * r34503 10/trunk/phase3/languages/messages/MessagesHe.php: Update. [10:42:10] Duesentrieb: its pretty straightforward actually. Merci. :) [10:43:03] 03btongminh * r34504 10/trunk/phase3/includes/ (Article.php ImagePage.php Wiki.php): [10:43:03] * Use getters where appropriate [10:43:03] * Fix following foreign file redirects again [10:50:04] 03(FIXED) Editing a page with the api is half broken - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=13587 +comment (10roan.kattouw) [11:02:57] 03huji * r34505 10/trunk/extensions/ConfirmEdit/ConfirmEdit.i18n.php: * Adding/updating Persian translations [11:04:13] 03huji * r34506 10/trunk/phase3/languages/messages/MessagesFa.php: * Adding/updating Persian translations [11:22:32] Hi All [11:22:41] I am running Media Wiki 1.9.3 ( Just upgraded from the previous version ) [11:22:50] However Currently its anonymous write enabled.. ( Allows one to edit any page without logging in ) [11:23:24] I tried all the tips given in the Net/Wiki guide.. But none of them have any effect.. [11:23:30] and now you want to restrict that? [11:23:46] I am pretty sure that the previously It was NOT anonymous write enabled [11:24:13] Nikerabbit: restirct .. Yes [11:24:20] !access [11:24:20] --mwbot-- For information on customizing user access, see . For common examples of restricting access using both rights and extensions, see . [11:24:28] mwbot: Tried that [11:24:37] and specified the parameters [11:25:20] it should work, such a basic thing [11:25:25] Added All these lines one after the other in Localsettings [11:25:53] $wgGroupPermissions['user']['edit'] = false; [11:26:08] $wgGroupPermissions['*']['edit'] = false; [11:26:21] Both have no effect [11:26:39] $wgGroupPermissions['*']['edit'] = false; [11:27:17] Now its running with all the above lines.. But still I am able to edit :( [11:27:28] without logging in [11:31:27] 03btongminh * r34507 10/trunk/phase3/ (3 files in 3 dirs): [11:31:27] * Show a link to [[Special:Whatlinkshere]] in case there are more imagelinks on ImagePage [11:31:27] * Cleanup ImagePage code [11:31:30] Paste your entire LocalSettings.php file into the pastebin (remove the MySQL and Proxy key before you post it though)... It's likely you're making one of the real simple mistakes [11:32:16] 03(FIXED) File links need "paging" (next 500 type links) - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=3759 +comment (10Bryan.TongMinh) [11:35:14] Does anyone know if it's possible to have WhitelistRead call on an external page like MediaWiki:Allowedpages [11:35:23] Dantman|FS: Thanks.. I will Do that.. One sec [11:37:19] *Dantman|FS debates if it would actually be a sane idea to setup MediaWiki to permit use of a .ini file as config rather than PHP and have it build that into a php form to keep performance [11:43:28] how would you add arrays to an ini? [11:45:31] Dantman|FS: Sorry.. And sorry to all the people here.. [11:45:50] It was one of those dumb mistakes... [11:45:57] An .ini wouldn't follow the same purpose as the php file [11:46:04] Which arrays do you refer to? [11:46:30] I was editing the LocalSettings.php... of /var/www/wiki ( Old one ) than the new Wiki /var/www/wiki-new :( [11:46:40] *linux_manju kicks himself 100times [11:46:50] If it's namespaces... You would put that inside of a [namespaces] section and the key=value would be what ends up in the array [11:47:08] Thanks alot [11:47:12] bye [11:47:25] For installation of extensions that would be in a [extensions] where you tell what to load. [11:48:26] And if there is anything non-normal that you need to do (not part of basic configuration) there would be an option to set a php file to load with the .ini... glob style even so you could have a subdirectory for that [11:48:52] Ohwait... [11:49:03] Security is the issue [11:49:41] It's much easier for the new admins to customize a .ini, but unless they pull it outside of the web root or webserver protect it, then it's publicly readable [11:49:54] so.. n/m [11:52:55] 03rotem * r34508 10/trunk/phase3/languages/messages/ (MessagesEn.php MessagesHe.php): Update. [11:53:32] 03huji * r34509 10/trunk/phase3/languages/messages/MessagesFa.php: * Adding/updating Persian translations [11:55:20] 03rotem * r34510 10/trunk/phase3/languages/messages/ (4 files): Rebuilding language files. [11:59:08] http://ultimategerardm.blogspot.com/2008/05/getting-message-right.html on the localisation and the stability of Flagged revisions [12:08:45] 03nad * r34511 10/trunk/phase3/ (6 files in 4 dirs): keep schema in maintenance same as postgresql [12:10:47] 03nad * r34512 10/trunk/phase3/config/index.php: rv oops disable mssql - not ready [12:13:40] 03nad * r34513 10/trunk/phase3/includes/DatabaseSqlite.php: remove comment [13:03:15] Why is it that my package manager seems to only ever ask me to install updates for the software I don't actually use? [13:03:22] *Simetrical needs to uninstall this kind of stuff [13:06:05] hehe [13:08:42] 03(mod) Page counts should not be incremented by pages viewed by bots - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=14044 (10Simetrical+wikibugs) [13:12:35] *Simetrical likes stuff in the repo that has hardcoded strings like "/data/home/river" [13:12:43] hehe [13:12:44] yay! [13:13:14] ghe [13:15:55] mmm... update checks [13:16:08] ^_^ That reminds me of an insane comment I sent to Jae [13:16:19] [00:32:58] ^_^ You know what would be interesting for a version freak....... If the system checked things for available updates... E-Mailed the sysadmin when a new one comes in, and the sysadmin could reply with a short command like 'update ok' and the server would upgrade... rotfl [13:16:19] [00:33:39] Of course... for a bit of saftey it should probably at that point e-mail the sysadmin back with the results of the update [13:17:14] Dantman|FS: i talked to Nikerabbit yesterday about automatic update checks. ask him :) [13:17:23] Heh [13:18:59] ^_^ In whatever case... I finally added stuff to my ~/php script to check the php packages I have installed, and the pear and pecl stuff for updates. [13:19:33] hi. where is the mainpage of a mediawiki project configured? [13:19:46] i.e. the name of the mainpage i guess [13:19:54] MediaWiki:Mainpage [13:20:00] !mainpage [13:20:00] --mwbot-- To change which page is the "main page" of your wiki, edit MediaWiki:Mainpage. [13:20:05] perhaps I should do some work with bash and cron then using something to send me mail when there's an update... Nothing fancy, my mailserver isn't even working for incoming stuff, but just for info [13:20:11] Oh hai. [13:23:39] thanks. thats it [13:46:21] 03(NEW) Image moving should leave entry in the upload history - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=14059 15enhancement; normal; MediaWiki: Images; (Bryan.TongMinh) [13:58:22] Hello. [14:09:25] 03yaron * r34514 10/trunk/extensions/DataTransfer/ (INSTALL includes/DT_GlobalFunctions.php): New version: 0.1.7 [14:15:51] hi [14:16:14] I am trying to understand if and how unit testing is done in MediaWiki development [14:17:02] we run on live site [14:17:04] I checked out http://svn.wikimedia.org/svnroot/mediawiki/trunk/phase3 and ran make there, is that one should do/ [14:17:05] and users come to do tests [14:17:12] 03rotem * r34515 10/trunk/phase3/maintenance/language/ (4 files): [14:17:12] * Recreating the checkExtensions script, using data in the Translate extension, and using the existing interface of checkLanguage. The i18n.db file is now obsolete. [14:17:12] * Moving the CheckLanguageCLI class to checkLanguage.inc. [14:17:12] * Several fixes in checkLanguage script. [14:17:19] do you mean manual tests? [14:17:55] who called [14:20:40] 03rotem * r34516 10/trunk/extensions/i18n.db: No longer used, not updated and duplicate to the Translate extension. [14:27:13] I'm trying to import enwiki with mwdumper and it fails with Exception in thread "main" java.io.IOException: java.sql.SQLException: Duplicate entry '0-?' for key 2 [14:28:12] check whether you are using binary collation [14:28:41] 03(mod) Support collation by a certain locale ( sorting order of characters) - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=164 (10anon.hui) [14:29:13] Hi guys [14:29:33] sorry, how do I check for binary ollation? [14:30:09] is there possibility in mediawiki to delete some specific revision of some article? [14:30:19] not hide, but delete it from database permanently [14:31:35] hiii! [14:31:54] hi [14:32:40] 03rotem * r34517 10/trunk/phase3/maintenance/language/checkLanguage.inc: Several fixes. [14:33:46] Inez: mediawiki offers no way to permanenlty remove any data via the web interface. however, revisions cen be hidden so well that they can no longer be retrieved over the web either. [14:33:54] see the oversight extension for that [14:34:20] Yup, I saw. [14:34:42] I'm thinkinh about storing only diff between article version in database, instead of full articles [14:34:55] (maybe for version - content - only for last few revisions) [14:35:08] tricky and dangerous. [14:35:30] So this is why I need to be sure that there is no way to delete any revision, because then, I may be not able to recover article [14:35:35] why dangerous? [14:35:37] compressing multimpe revisions together gives you the same or more amount of saved space [14:35:41] and a lot less trouble [14:36:06] Inez: differential storage is fragile. you lose one version, you lose all later. [14:37:09] Simetrical: Maybe they're dependencies? [14:37:11] Inez: currently, revisions may be moved to different locations. and there are also command line scripts that may be able to actually delete revisions. [14:37:23] yes, I know [14:37:26] I'm just thinking. [14:37:29] Inez: basically... *why* do you want to do that? [14:37:40] save space. [14:37:45] use compression [14:37:49] still. [14:37:56] it kills redunancy better than diff. [14:38:28] the idea is to compress multiple revisions of the same page into one blob. [14:38:44] yeah, that's a good soluton to. it's already in mw. [14:38:50] the "remove oll the duplicate stuff" logic is implemented by the compression algorithm [14:39:15] yes, that's how it works for external storage. not sure it can be done with a songle-db setup. probably possible though [14:42:55] Duesentrieb: Depending on how that external storage stuff works, shouldn't it be possible to create a 'text_real' table and call that your external storage? [14:43:21] yes. [14:43:44] i'm pretty sure that's pürossible. the setup is a bit complex though [14:44:07] it's designed to do load balancing on a cluster of external storage servers [14:44:16] so, doing something simple may be tricky :) [14:44:44] 03catrope * r34518 10/trunk/phase3/ (RELEASE-NOTES includes/api/ApiQueryBacklinks.php): (bug 14021) Removing titles= support from list=backlinks, has been obsolete for ages (since July 2007) [14:45:01] 03(FIXED) titles= should be removed for backlinks & children - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=14021 +comment (10roan.kattouw) [14:50:51] so I wonder if I should use "make test" to run the unit tests? [14:51:12] they fail on my machine [14:55:13] I'm trying to import enwiki with mwdumper and it fails with Exception in thread "main" java.io.IOException: java.sql.SQLException: Duplicate entry '0-?' for key 2. I set binary collation and got the same error [15:10:24] 03(mod) Wrong tags like are not tidied up by parser for unstable revision - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=14056 summary; +comment (10Wiki.Melancholie) [15:28:06] can I use a date instead of oldid= ? [15:28:53] Nope [15:29:17] but history has offset, which is a date [15:29:27] 03(NEW) Do not show "0 changes need review" if a template change was made by a sighter - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=14060 15enhancement; normal; MediaWiki extensions: FlaggedRevs; (Wiki.Melancholie) [15:29:31] LA2: timestamps need not be unique [15:29:51] There can be (and often are) two revisions made in the same second [15:30:08] correct, but history with offset and limit=1 still succeeds to return exactly one version [15:30:11] Remember that the oldid not only identifies the revision, but also the page [15:30:29] LA2: Yeah, but it'll get stuck if there are two revs with the same timestamp [15:30:48] get stuck? [15:30:50] Which can happen (really fast bots, leap seconds/years, clock drifts) [15:31:07] Well it'll request the next revision by timestamp right? [15:31:27] So it'll either show you the same rev over and over, or skip the one with the duplicate timestamp [15:31:31] thanks for the information that this is currently not possible [15:31:42] I think it could be useful. However, it would never replace oldide, of course [15:31:55] Also, if you request a rev by timestamp and there's a duplicate, how should MediaWiki decide which one you want? [15:32:29] Well I understand it could have its uses, but it could give rise to some very weird error messages which are hard to understand for end users [15:32:32] if I ask for a timestamp, I'll get some random version with that timestamp. If I really need one specific version, I can specify oldid [15:33:40] you think like a good programmer, considering all that could go wrong. But you haven't heard about my application yet. I'm trying to compile a list of permalinks to the version of articles that were nominated as featured articles. [15:34:02] It would probably more useful to do something like "give me the most recent revision made before or on this timestamp" [15:34:11] Which you can already do with the API [15:34:34] I can easily get a list of page names and the dates they were nominated, but then I have to retrieve history with offset and limit=1 to get the oldid of that version [15:35:00] 03ialex * r34519 10/trunk/phase3/ (4 files in 2 dirs): svn:eol-style native [15:35:03] oh, really? [15:35:32] *RoanKattouw looks it up [15:36:01] increadible that this was a featured article in April 2004, http://sv.wikipedia.org/w/index.php?title=Carl_von_Linn%C3%A9&oldid=145697 [15:38:26] api.php?action=query&prop=revisions&rvstart=20080131200845&rvlimit=1&titles=Foo [15:38:42] It's kind of embarrassing that I had to look that up, I'm the lead developer of the API [15:39:28] Or a concrete example: http://en.wikipedia.org/w/api.php?action=query&prop=revisions&rvstart=20080131200845&rvlimit=1&titles=Main_Page [15:40:02] That's the most recent revision of [[Main Page]] before Jan 31 2008 20:08:45 [15:40:10] 03(mod) If a template was changed, logged-in users see old template content in articles for about 1 minute - 10http://bugzilla.wikimedia.org/show_bug.cgi?id=14030 (10Wiki.Melancholie) [15:41:37] If you need the content or other information that's possible too [15:43:36] LA2: lol [15:46:25] wouldn't it make a lot of sense to implement offset= for the default (display) action? [15:50:10] Hi [15:51:07] Have a problem with mail notification using $wgUsersNotifiedOnAllChanges [15:52:00] if I take a page in my watchlist, everything is working fine [15:52:18] unless you run the development version, it's named $wgUserNotifedOnAllChanges [15:52:50] thanx, I will try that [15:53:54] Eewww... People are actually trying to find articles with null urls on my site... I use action paths [15:54:22] Bleh... guess I need a 404 handler [15:54:41] {{sodoit}} :) [15:57:50] $wgUserNotifedOnAllChanges or $wgUserNotifiedOnAllChanges ? [15:58:13] the first one [15:59:30] Is a Mysqldump the most recommended method of backing up a Wiki? [16:03:27] @ialex: something other to pay attention to? [16:03:40] brosius: i don't think [16:04:01] 03(mod) $wgAllowExternalImagesFrom is to limiting, extend it to allow multiple domains - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=12530 +easy (10dan_the_man) [16:04:12] hmm [16:06:07] still don´t get any mails [16:06:40] brosius: how did you set that variable ? [16:06:45] Is it allowed to post a piece of my LocalSettings.php ? [16:06:55] No, use the pastebin [16:07:01] http://rafb.net/paste/ [16:08:47] http://rafb.net/p/X0Xs2u40.html [16:10:08] ialex: Are you sure you got the variable name right? I don't see either Notifed or Notified on MediaWiki.org [16:11:21] http://www.mediawiki.org/wiki/Manual:%24wgUsersNotifiedOnAllChanges [16:12:37] brosius: you have to use something like $wgUsersNotifiedOnAllChanges = array( 'WikiSysop' ); where WikiSysop is a user in the wiki [16:12:49] Then why did you explicitly tell him to use the wrong name, with User (not Users) and Notifed (not Notified) ? [16:13:18] brosius: The variable is called $wgUsersNotifiedOnAllChanges , with user*S* and notif*i*ed [16:13:23] oops, $wgUsersNotifedOnAllChanges = array( 'WikiSysop' );, it's notifed in < 1.13 [16:13:39] Still, it's User*s* [16:13:50] yeah, i didn't see that one [16:13:58] no matter, if I get it working ;O) [16:14:13] 06(LATER) Consider position change of #mw-revisiontag box - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=14035 (10JSchulz_4587) [16:15:47] 03(mod) Parser issue for HTML definition list - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=11748 +comment (10jlerner) [16:16:05] I need help in backing up my wiki.,..I am reading Manual:Backing_up_a_wiki and still not getting it [16:16:10] 03aaron * r34520 10/trunk/extensions/FlaggedRevs/FlaggedArticle.php: Show box less [16:16:15] !man Backing_up_a_wiki [16:16:15] --mwbot-- http://www.mediawiki.org/wiki/Manual:Backing_up_a_wiki [16:16:26] 03(FIXED) Show #mw-revisiontag-edit box only if necessary - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=14055 +comment (10JSchulz_4587) [16:16:38] Well the best way to backup your wiki depends on what you want to backup [16:17:02] RoanKattouw: yes I am on that page... and tried the sqldum lines as well as the dumpBackup.php method which didn't work.. I was looking for some assistance here [16:17:29] If you only want to backup the pages, use the XML dump. If you also want other stuff (users and their passwords and all that) backed up, do a database dump [16:18:30] In most cases, you'll want a database dump, read the Database section and the Character set section [16:18:48] >> /usr/bin/nice -n 19 /usr/bin/mysqldump -u $USER -p$PASSWORD --default-character-set=$CHARSET $DATABASE -c | /usr/bin/nice -n 19 /bin/gzip -9 > ~/backup/wiki-sql-$(date '+%a').sql.gz [16:18:54] Yea [16:19:05] <^demon> . [16:19:12] Of course you need to replace $DATABASE and friends with whatever applies to your situation [16:19:14] filled int he values for $USER $PASSWORD $ChARSET and $DATABSE ... [16:20:17] RoanKattouw: First try... I don't think I had the right flags in and the sql.gz file was empty [16:20:29] Does it work now? [16:20:35] Do I need a -D flag for the $databse? [16:20:41] No [16:21:31] So does it work? [16:21:37] I gotta go for a few minutes now, brb [16:22:46] 03ialex * r34521 10/trunk/phase3/ (docs/hooks.txt maintenance/findhooks.php): [16:22:46] * Added --online option to maintenance/findhooks.php to compare hooks with http://www.mediawiki.org/wiki/Manual:Hooks [16:22:46] * Renamed GetAvailableRights to UserGetAllRights in docs/hooks.txt [16:22:48] Access denied for user '' to database '' when using LOCK TABLES [16:23:31] gegema: Try using --user=user and --password=password rather than the -u and -p stuff [16:24:00] RoanKattouw_away: Ok [16:24:29] hmm, using http://rafb.net/p/bVTrNd57.html , but still no mails on page changes [16:24:46] using version 1.12 [16:25:00] RoanKattouw_away: Same error [16:25:01] 03(mod) Support collation by a certain locale ( sorting order of characters) - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=164 (10brion) [16:25:17] brosius: a user name, not an address [16:25:32] oh, I see [16:26:20] great, now it works. [16:26:26] RoanKattouw_away: I am connecting to the db using the wiki user and not the root user account when trying the above >> not sure if that makes a difference [16:26:30] thank you very much for your support [16:36:17] 03aaron * r34522 10/trunk/extensions/FlaggedRevs/ (FlaggedRevs.php FlaggedRevsPage.php): Always tidy (bug 14056) [16:36:26] 03(FIXED) Wrong tags like are not tidied up by parser for unstable revision - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=14056 +comment (10JSchulz_4587) [16:42:00] 14(WFM) Wrong time stamp in signature - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=14057 +comment (10brion) [16:49:45] 03huji * r34523 10/trunk/phase3/languages/messages/MessagesFa.php: Fixing and old typo in Persian translations [16:51:16] 03aaron * r34524 10/trunk/extensions/FlaggedRevs/FlaggedRevsPage.i18n.php: Might be locked [16:51:30] 03(FIXED) The extended box message for a flagged revision is incorrect if the article is protected - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=13971 +comment (10JSchulz_4587) [16:52:14] 14(DUP) Do not show "0 changes need review" if a template change was made by a sighter - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=14060 +comment (10JSchulz_4587) [16:52:17] 03(mod) Provide other FlaggedRev boxes for the case of a template/ image change, currently resulting in "0 changes need review" - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=14031 (10JSchulz_4587) [16:56:12] is there a workaround for https://bugzilla.wikimedia.org/show_bug.cgi?id=11748, other than upgrading? [16:57:16] jlerner, maybe. I doubt it. [16:57:28] yeah [16:58:14] 14(WFM) Parser issue for HTML definition list - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=11748 +comment (10Simetrical+wikibugs) [17:00:01] anyone feel like giving their two cents about bug 14048? [17:00:06] !b 14048 [17:00:06] --mwbot-- https://bugzilla.wikimedia.org/show_bug.cgi?id=14048 [17:00:38] 03(NEW) Weired bug in Sidebar; the message is not read?! - 10http://bugzilla.wikimedia.org/show_bug.cgi?id=14061 major; normal; MediaWiki: Internationalization; (huji.huji) [17:01:44] 03(mod) Special: Export should have an option to export with the sites license - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=14048 +comment (10Simetrical+wikibugs) [17:02:45] Simetrical, thanks.. specifically I don't have svn here (work) -> and therefore did it this way.. [17:03:39] Wiredtape, you can use diff -u. [17:03:50] on windows? [17:05:43] Wiredtape: TortoiseSVN can generate diffs [17:05:56] "Create patch..." in the right-click menu [17:06:02] RoanKattouw_away : yeah.. I only wish I were able to install it here :) [17:06:02] Wiredtape, plenty of diff implementations for Windows. [17:06:11] You can just download the binary. [17:06:18] gegema-lunch: It shouldn't make a difference [17:06:22] Or heck, there's probably some web tool. [17:06:24] 03(mod) Provide other FlaggedRev boxes for the case of a template/ image change, currently resulting in "0 changes need review" - 10https://bugzilla.wikimedia.org/show_bug.cgi?id=14031 normal->high (10JSchulz_4587) [17:06:53] gegema-lunch: Maybe run mysqldump --help and see what the parameters are supposed to be, then adjust the command on the wiki page [17:06:54] ok.. either way, i'll do that tonight.. but specifically I wanted to know of opinions regarding the questions I placed there.. [17:07:17] gegema-lunch: I gotta go carry buckets of sand to my back yard now, so bye [17:09:20] 03nikerabbit * r34525 10/trunk/extensions/Gadgets/Gadgets.php: * Fixed a bug that caused gadgets definition to be reparsed on every request [17:22:57] 03nikerabbit * r34526 10/trunk/extensions/APC/ (APCCacheMode.php SpecialAPC.php ViewAPC.php): * Fix parameter remembering, was a little confused how FormOptions should be used [17:23:20] weird that nobody noticed that gadget thingie [17:35:57] 5 PHP Strict Standards: Declaration of ImagePage::isRedirect() should be compatible with that of Article::isRedirect() in /var/www/w/includes/ImagePage.php on line 16 [17:37:31] In trying to backup my Wiki, I am using the command >> mysqldump -u username --password=password --default-character-set=latin1 wikidatabase -c > ~/backup/wiki-sql.gz and I am getting an error when using LOCK TABLES >> any suggestions? [17:38:48] I have also tried passing the -C flag for compression and no flags at all, same error message [17:39:23] gegema : what is the error? [17:40:35] Wiredtape: Got error: 1044: Access denied for user 'myusername'@'localhost' to database 'wikidbase' when using LOCK TABLES [17:41:11] do them usernames and databases actually exist? [17:41:59] MinuteElectron: Yes they do > I can connect to the db using the credentials [17:42:07] gegema: what priviliges does your myusername have? [17:43:50] Starting from Alter, Alter routine to Update and Usage; also has a Lock tables Privilege [17:45:07] hmm.. my suggestion is you ask the people over at #mysql.. seems to me there is something silly with the setup for myusername user :) [17:45:09] Wiredtape: I am assuming the command 'show PRIVILEGES' when logged into the mysql server shows the Privileges of the current user [17:45:22] afaik [17:46:14] Wiredtape: asking that in #mysql atm [17:47:04] http://en.wikipedia.org/w/index.php?title=User:Superm401/Sandbox2&action=edit [17:47:06] Grahahafafah. [17:47:17] Wiredtape: I was also trying to run dumpBackup.php and got a 'DB connection error" error [17:47:44] lol [17:48:02] I would be terrified to know what the page is actually supposed to do. [17:48:10] gegema did you set up a adminsettings file? [17:48:13] Compute the first 1000 digits of pi? [17:48:21] Execute Folding@Home on Wikipedia servers? [17:48:36] Sheer sadism? [17:48:42] Wiredtape: Not that I can remember [17:49:49] Simetrical: jeez... that's scary.. [17:50:11] O.o [17:50:28] gegema : look for adminSettings.sample (or someother ext) in your main mw dir.. and edit it as it says.. safe as .php [17:51:04] gegema and unfortunately, #mysql usually takes a long time before they answer questions :-\ [17:51:53] Wiredtape: Thanks >> will just hangot in that room to see if anyone answers, and try your suggestion in the meantime [17:53:37] wikipedia error [17:53:51] and now its back [17:54:53] and another error.. :-\ [17:57:37] Wiredtape: wrong channel [17:57:59] MinuteElectron : yeah.. sorry... [18:02:49] brion: Have you synced the servers yet? [18:03:22] he has [18:03:28] Good [18:04:08] *Dantman pictures brion at home picking up the phone to hear a creepy voice saying "Have you synced the server's yet?" heh... [18:04:12] brion: Could you tell me which query (ies?) filesorted so I can fix them? [18:05:04] Does MW use mysql time zone, or does it have its own time setting? [18:05:24] Mine is off by 4 hrs and I am trying to sync it with my server time [18:05:49] gegema: I believe it uses UTC [18:06:09] So I guess you're in GMT - 5, plus one hour DST makes UTC -4 [18:06:17] RoanKattouw: can that be changed to a tz setting? [18:06:57] brion: Ah, saw it on wikitech, you're sure that the recentchanges query is the one then? [18:07:22] yyyyep [18:07:44] | enwiki | Query | 601 | Sorting result |SELECT /* ApiQueryRecentChanges::execute [18:07:55] 10 minutes to sort results? not good :D [18:08:09] brion: Ah, thanks [18:08:24] It's MySQL 4's fault ;) are we ever gonna update MySQL at the servers? [18:08:34] eventually [18:08:36] "it's nigh impossible to integrate with addJoin() and it doesn't seem to be necessary anyway (my MySQL instance automatically chooses rc_timestamp)" [18:08:38] brion, really? [18:08:39] why? [18:08:52] AaronSchulz: SELECT foo, bar FORCE INDEX (baz) [18:09:02] Only works if baz is an index of bar [18:09:13] Does SELECT foo, bar FORCE INDEX (foo.baz) work? [18:09:13] then you are passing it in wrongly [18:09:14] the original reason we *wanted* 5 was for the unicode support, but it's incomplete :0 [18:09:17] you need to use array keys [18:09:19] At least going by the past few releases of MySQL, they seem to be adding cute features rather than ones that are actually useful for serious use by people who know what they're doing. [18:09:24] the improved query analyzers and nice things like that are nice though [18:09:40] But it's also slower and has no major new features we could use. [18:09:50] AaronSchulz: How do I do that? $options['USE INDEX'] = 'baz'; is what we use [18:09:55] and it crashes a lot [18:09:58] Since things like subqueries and views are ludicrously inefficient in most cases. [18:10:00] and has lots of bugs [18:10:12] But it selects indexes better [18:10:13] *RoanKattouw hides [18:10:15] RoanKattouw, $options['USE INDEX'] = array( 'bar' => 'baz' ) works, I think? [18:10:16] T_T I'm using 5.0... [18:10:17] Try it. [18:10:21] $options['USE INDEX'] = array( tableNameA => indexforA, tableNameB => indexForB ) [18:10:28] Simetrical: we ain't moving until domas is happy with it :) [18:10:31] AaronSchulz: Thanks, didn't know *that* [18:10:39] a lot of people don't [18:11:02] AaronSchulz: I assue tableNameA has to *exactly* match one of the elements of the $tables array? [18:11:24] Which kind of sucks if one of those elements is "foo LEFT JOIN bar ON blah=baz" [18:11:43] so? [18:12:25] http://ganglia.wikimedia.org/pmtpa/graph.php?g=network_report&z=medium&c=MySQL&m=&r=hour&s=descending&hc=4 :D [18:13:02] brion, domas has said there are no new features of interest to us. [18:13:05] brion: heeeeeee [18:13:12] What might we want, triggers or something? [18:13:34] someday, decent collation would be great [18:13:37] how can i check if a wiki has a dump functionality ? [18:13:37] but that has all kinds of issues :D [18:14:16] AaronSchulz: Well foo LEFT JOIN bar ON blah=baz FORCE INDEX (times) doesn't work, right? [18:14:26] RoanKattouw, why not? [18:14:27] FORCE INDEX has to come right after the table name, right? [18:14:30] DB42, I can tell you right now.. :) no.. [18:14:33] yes [18:14:41] Wiredtape: no what ? [18:14:56] AaronSchulz: Yes, it doesn't work, or yes, it does work? [18:14:57] anyway, we prolly should make the contrustor support LEFT joins easier [18:15:05] [14:12] FORCE INDEX has to come right after the table name, right? [18:15:11] Oh OK [18:15:12] yes [18:15:18] you can have several FORCE INDEX statments [18:15:21] DB42, no wiki's that use mediawiki have a dump function.. (unless given by other means.. or unless you want to export some articles) [18:15:25] one after each table [18:15:32] or skip some for tables, whatever [18:15:40] Is there some Database function that'll add the FORCE INDEX for me or something else if using PostGres/Oracle/whatever? [18:15:41] AaronSchulz, maybe we should have LEFT JOIN as an option? [18:15:46] Wiredtape: ok thanks [18:15:50] Simetrical: No [18:15:59] What about multiple JOINs? [18:16:00] so basically if i want to d/l a wiki i have to do it manually? [18:16:04] RoanKattouw, arrays? [18:16:05] SELECT foo, bar LEFT JOIN baz [18:16:06] Simetrical: $tables should be tweaked [18:16:12] $options['LEFT JOIN'] = array( 'tablename' => 'conditions...' ); [18:16:26] RoanKattouw, you're missing FROM somewhere and I'm not sure where. [18:16:31] DB42, mysqldump... or if you process a list of all pages you could export it all [18:16:37] AaronSchulz, yes, but how? We've been discussing it. Accept raw SQL? [18:16:43] SELECT * FROM foo, bar LEFT JOIN baz then [18:16:49] so it could be string OR array( a, b, c ) OR array( a, 'LEFT JOIN' => b, 'LEFT JOIN' => c ) [18:17:01] or something [18:17:03] Wiredtape: i dont have access to the wiki itself by other means as to the sql or so [18:17:05] as long as it is sensible [18:17:15] can i see some "meta" info like which page linkes to what page, etc ? [18:17:19] AaronSchulz, Simetrical: How about ApiQueryBase::addJoin() ? [18:17:25] !c ApiQueryBase [18:17:25] --mwbot-- See http://svn.wikimedia.org/doc/classApiQueryBase.html [18:18:06] AaronSchulz, you can't reuse the same index. :) [18:18:20] DB42: for each page you can see what other pages link to it.. (special:whatlinkshere) [18:18:22] But we aren't using key => value pairs now, you're right. [18:18:46] We could do array( 'a', 'b' => array( 'LEFT JOIN', 'foo = bar' ) ), maybe, but that's kind of ugly. [18:19:07] array( a, b, 'LEFT JOIN' => c ) looks nice ;) [18:19:13] and array( a, 'LEFT JOIN' => b, 'LEFT JOIN' => c ) [18:19:16] once you start writing complex queries, you wish we had prepared statements instead of some bizarre db abstraction [18:19:27] is there a program that make connection graph between different wiki pages ? [18:19:57] Simetrical: well array( a, b, 'LEFT JOIN ON (x)' => c ) [18:20:03] the ON needs to go somewhere ;) [18:20:04] DB42: You can export the pages themselves through Special:Export [18:20:14] either there or in another param [18:20:16] DB42: connection graph = showing article connection bubbles? [18:20:20] just like $options [18:20:21] AaronSchulz, you can have two left joins on the same condition. [18:20:23] I think. :) [18:20:49] AaronSchulz, Simetrical: Why don't you look at ApiQueryBase::addJoin() and see if that makes any sense? The parameters I mean, not the implementation [18:21:20] Simetrical: maybe the easiest looking way is to add another input, like $options, but called $jointype or something [18:21:36] like array( a => 'LEFT JOIN ON (x)' ) [18:22:18] RoanKattouw: I hope you can tell if your queries "make sense" ;) [18:22:30] What I'm doing in the API right now is addJoin( array('a', 'b', 'c'), array(ApiQueryBase::LEFT_JOIN, ApiQueryBase::RIGHT_JOIN), array('foo=bar', array('baz' => 3, 'blah=kgfd')), array(null, 'page', null)); [18:23:10] Which produces SELECT whatever FROM a LEFT JOIN b AS page ON foo=bar LEFT JOIN c ON baz=3 AND blah=kgfd [18:23:21] AaronSchulz: I asked whether the function prototype made sense [18:23:30] The queries it produces do make sense, of course [18:24:01] So basically it's addJoin($tables, $jointypes, $conditions, $aliases) [18:26:34] Maybe we could add $jointypes to Database::select() and have null denote a non-join (or, more correctly, an implicit join) [18:27:53] Anyway I gotta go now [18:29:39] Wiredtape: yes [18:31:07] DB42: well.. not that I know of.. but if you plan of making one (flash or equivelant preferably) than I'd be very interested in that.. [18:31:20] basically i want to take a tv show wiki [18:31:28] and parse all the links to a graph [18:31:38] but for that i need a dump of the wiki ... [18:32:21] or you could use the api.. and spider through "what links here" [18:32:54] or ... you could use the api and run through Special:Allpages (or was it All_pages?) [18:34:08] the question is has somebody done this before (in any format) [18:34:27] not that i know of [18:35:16] but i do remember someone making a category tree (not the extension) which displayed connections between articles and their categories.. [18:41:06] 03brion * r34528 10/trunk/phase3/includes/ImagePage.php: (log message trimmed) [18:41:06] Wikify some image messages: [18:41:06] * linkstoimage [18:41:06] * nolinkstoimage [18:41:06] * redirectstofile [18:41:06] Two of these were previously raw-HTML paragraphs, and had div classes stuck on them on eg English Wikipedia. [18:41:09] r34507 changed them into plaintext, breaking them. [18:43:38] yay [18:53:21] 03ialex * r34529 10/trunk/extensions/Nuke/ (SpecialNuke.php SpecialNuke_body.php): Moved Special:Nuke page class to SpecialNuke_body.php and made it extends SpecialPage, this allows to not load messages at each request [18:54:17] 03brion * r34530 10/trunk/phase3/includes/EditPage.php: [18:54:17] Ensure there's a newline at the end of the editing