[00:13:54] Hi all, does anyone have a solution to prevent source blocks of type sql from capitalising references a tables named user? Im trying to document some configuration for mediawiki on mysql, and while the source is user its rendered as USER which breaks when executed in mysql. I also cant appear to quote the table name as this also breaks the sql. [00:14:38] how are you quoting it? [00:14:50] 'user' or "user" both break [00:14:56] use backticks [00:15:06] that's what mysql uses for quoting table names [00:15:42] bingo, that works. thanks! [00:15:57] (which doesn't mean that the hightlighter couldn't benefit if it didn't do that) [00:16:00] :) [00:18:49] for the record, it did not do that. mediawiki 1.23.13. [00:19:39] but i guess its hard for media wiki to know which variant of sql its rendering. most of whats in this wiki is pl/sql [00:25:10] antus: the sql highlighter comes from GeSHi [00:25:19] !GeSHihighlighter [00:26:00] https://www.mediawiki.org/wiki/Extension:SyntaxHighlight_GeSHi [00:26:25] oh, it moved to pygments [00:27:06] Hello all! I'm having troubles with restoring my database from a backup when trying to upgrade from 1.22 [00:27:18] Illegal mix of collations (utf8_bin,IMPLICIT) and (cp1251_general_ci,COERCIBLE) for operation '=' [00:27:44] I checkk EVERY COLUMN in my database and I don't see any cp1251 in there... How can I fix it? [00:29:34] maybe mysql assumes the cp1251 encoding for data in the sql commands it's receiving? [00:29:42] (i don't know much about this stuff) [00:30:16] Somebody told me that data is always in utf8... [00:31:18] I've even run converting script for every column - still same thing... [00:32:25] the data *is* always in utf-8. [00:32:49] but mysql might think it isn't for some reason? [00:33:01] How do I change its mind? :) [00:34:43] hmm. http://stackoverflow.com/questions/1008287/illegal-mix-of-collations-mysql-error [00:34:50] Tess: mediawiki backups are always in utf-8 [00:35:07] but mysql has many places where you can specify a charset [00:35:26] even more, old mediawiki used to lie and store utf-8 data in latin1 columns [00:36:01] (which later made intelligent mysql dumpers get confused) [00:36:10] Tess: you get this while importing a backup, right? not from MediaWiki code? [00:37:11] right, importing old database or when running update.php after upgrade [00:38:17] Platonides: it seems that I checked everything in phpMyAdmin and I don't see a trace of cp1251 anywhere... [00:38:31] Is there a way to cheat it somehow? [00:39:09] Tess: try adding `SET collation_connection = 'utf8_bin';` at the top of the SQL dump file. it just might work [00:39:34] When I try to undump it from .xml dump instead of importing, it does not even let me -- same error [00:40:51] MatmaRex: ok, trying right now [00:49:47] to MatmaRex: nope, did not work... [00:51:31] hm. :( [00:52:46] Tess: try executing `mysql` with `--default-character-set=utf8_bin`, maybe, then? per http://manpages.ubuntu.com/manpages/wily/en/man1/mysql.1.html [00:53:20] if not that, then i don't have any more ideas, sorry. [00:56:52] MatmaRex: I'm not sure I have access for that, let me try [00:57:15] "utf8_bin is not a compiled charset" so I tried just "utf8" and access is denied :) [00:57:28] thanks for trying though ;-) [00:58:45] it might be "binary"? [04:37:42] Hey guys. I'm trying to create my own custom infobox, and I'd like to recreate a table from an existing site as closely as possible. What's the best way to do this? Copy the HTML for the table into a new template page, and are there any tools for creating templates that you'd recommend? Thanks! [09:31:35] hello [09:32:10] Does anyone know nyingmapa monastry in rewalsar?/? [09:39:18] tenzi why would you ask in #mediawiki ? [09:40:45] cause i typed nyingmapa monsatry and it came up but in this website [09:45:17] this is not a website, it's a support channel for the software that sites like wikipedia, wikia, and others, run [09:52:39] Hmm, my server has just started returning 500 internal server errors when it encounters the composer autoloader in mediawiki [09:53:10] nothing was edited on the server so I am a bit confused as to what could have changed to cause this [09:53:56] any ideas? [10:07:32] ok managed to track down the exact line its erroring it on [10:07:43] setincludepath in composer autoload [10:14:25] Well... this shouldnt work. [10:14:32] I just commented out that line [10:14:36] and everything is working fine [10:57:05] hm, I found a hardcoded value in MW which in my use case would be useful to have as a LocalSettings.php configuration option. As a general thing, if I write a tiny patch to accomplish this, how many toes would I be stepping on and how loudly would they shout at me? [10:57:49] I already asked on the mailing list and got no answer, so I assume a patch might be a better way of soliciting opinions [11:01:11] Who are "they"? :) [11:01:38] In general, patches are very welcome if you can explain your usecase and if it convinces the maintainers. :) [11:01:55] https://www.mediawiki.org/wiki/Gerrit/Tutorial [11:01:59] from reading the sentence, "they" are toes. :p [11:02:06] good question. I'm assuming I don't get commit access (I actually don't want commit :) ) so I'd be submitting a patch to the folks who do have commit access -> "them" :) [11:02:17] also yes, toes :) [11:04:02] it'd be a really trivial (maybe 2-3 line) patch so it's be illogical that we go through hoops for commit, but I just want either a) to get the feature in or b) understand why it's a bad idea. So I thought a patch would be a good way to present the notion [11:04:33] There is Code Review (via "Gerrit") in between and everybody can put proposed changes into Gerrit, hence no direct commit access needed :) [11:04:43] good, I'll do that then [11:04:46] for full info, see https://www.mediawiki.org/wiki/How_to_become_a_MediaWiki_hacker [11:04:54] yeah was skimming that earlier. [11:06:05] ty andre [11:10:41] yw [12:07:53] anyone familiar with mw-ocg-service around? [12:08:44] it works i my setup when started from command line, like ./mw-ocg-service.js -c localsettings.js [12:09:57] but starting the service made by copying the mw-ocg-service.conf file to /etc/init/ just gives me mw-ocg-service: {"name":"mw-ocg-service","hostname":"localhost","pid":1357,"level":50,"channel":"backend.error.fatal","msg":"Configuration error: Cannot determine if /mw-ocg-bundler/bin/mw-ocg-bundler exists!", [12:11:19] tried changing the .conf file so that BINDIR is statically defined instead of set up by checking the symlink, but that made no difference [12:34:27] irpi788 [14:17:06] morning [14:43:07] ping [15:17:00] I can start my mw-ocg-service from the command line, but spawning with the service command just gives me "mw-ocg-service main process () terminated with status 8" [15:17:45] I think this is because nodejs/mw-ocg-service can't find dependencies, or the other programs... [15:18:05] ideas / pointers? [15:18:09] who would know? [15:19:26] jsl14: hello [15:20:12] jsl14: you can try filling a task in https://phabricator.wikimedia.org/ with the project OCG-General-or-Unknown [18:20:20] How does one avoid their composer.json from getting killed during each update? [18:22:18] you use composer.local.json instead, or, better yet, not use composer to install mediawiki extensions [18:51:08] Nemo_bis: ashley: I got approval eleven extensions. Two require clean up before releasing. :) [18:51:12] *approval on [18:51:43] awesome :D any ETA? :) [18:52:13] This week when I have free time. I am preparing our MW 1.26 deploy for next week, so super busy! [18:59:45] Trela: congrats!! remember to tell everyone the good news on mediawiki-l when you publish them [19:00:05] Mediawiki-l is the mailing list, yes? [19:00:58] Yep. :D [19:08:28] Does anyone know why Special:LonelyPages would be out of date, is there a way to force it to update? [19:13:39] !debug [19:13:39] For information on debugging (including viewing errors), see http://www.mediawiki.org/wiki/Manual:How_to_debug . A list of related configuration variables is at https://www.mediawiki.org/wiki/Manual:Configuration_settings#Debug.2Flogging [19:18:41] z_AlexJFox: do you have $wgMiserMode set? that would explain it. when $wgMiserMode is active, you can update cached (expensive) special pages like AncientPages, LonelyPages, WantedPages etc. via the maintenance script maintenance/updateSpecialPages.php or by installing the RefreshSpecial extension and then visiting the on-wiki special page Special:RefreshSpecial [19:20:25] thanks ashley, I'll look into that right now [19:34:16] Hi, with https://www.mediawiki.org/wiki/Manual:$wgDBssl I can use SSL for DB connections (apparently), but it doesn't say how to provide the needed SSL certs. thoughts? [20:43:55] $wgCentralIdLookupProviders is the best thing ever that I am just discovering. [20:49:28] Good evening [20:51:46] !wg CentralIdLookupProviders [20:51:46] https://www.mediawiki.org/wiki/Manual:%24wgCentralIdLookupProviders [20:51:58] Trela, well, it is relatively new [20:52:02] Undocumented! [20:52:16] anomie, ^ [20:52:25] Yep. I am manually merging it into MW 1.26.2 to support the newer Echo. [20:53:04] * bawolff will document it, once I figure out what it is [20:54:13] From the in progress release notes: * Added CentralIdLookup, a service that allows extensions needing a concept of "central" users to get that without having to know about specific central authentication extensions. [21:04:24] * bawolff has documented! [21:08:55] \o/ [21:20:34] !wg test [21:20:34] https://www.mediawiki.org/wiki/Manual:%24wgtest [21:22:02] !hello [21:22:03] There is no such key, you probably want to try: !, !iamabot, !wm-bot, [21:22:06] ! [21:22:06] Hello, I'm wm-bot. The database for this channel is published at http://bots.wmflabs.org/~wm-bot/db/%23mediawiki.htm More about WM-Bot: https://meta.wikimedia.org/wiki/wm-bot