[02:35:22] Hi! [02:38:37] Esther: Hi [09:32:23] Hello [13:39:17] I'm having trouble with my wikimedia installation. I got it installed, using mysql. When I click "edit" on the home page, I get [13:39:22] A database query error has occurred. This may indicate a bug in the software.[cef81f30b605b028026a471e] 2017-08-23 12:12:02: Fatal exception of type "Wikimedia\Rdbms\DBQueryError" [13:39:33] Oh yeah, I'm serving with httpd. Nothing is logged about this in /var/log/httpd/error_log. [13:39:48] Other things work: for instance "protecting" that home page... [13:39:59] view history works on this page, and it shows that I protected it. [13:43:06] Oh yeah, I logged into mysql as the mediawiki user, and successfully selected from some tables there. I suppose this is a needless test because installation succeeded, and it's serving content. [13:49:54] !debug [13:49:54] For information on debugging (including viewing errors), see https://mediawiki.org/wiki/Manual:How_to_debug . A list of related configuration variables is at https://mediawiki.org/wiki/Manual:Configuration_settings#Debug.2Flogging Also see https://mediawiki.org/wiki/Manual:Errors_and_symptoms [13:49:59] lmat: ^ [13:55:14] Great, thanks [14:27:48] Technical Advice IRC meeting starting at 3 pm UTC/5 pm MEZ in channel #wikimedia-tech, hosts: @addshore & @CFisch_WMDE - all questions welcome, more infos: https://www.mediawiki.org/wiki/Technical_Advice_IRC_Meeting [14:47:04] Esther: Thanks! I'm looking at "Creating custom error logs". Without doing that, where do debug logs go? Where is the default? [14:47:47] debug log for what exactly? [14:48:11] for example, if your web server does not like something, it depends on your web server's configuration. [14:48:17] not much to generalize... [14:48:18] andre__: DB. $wgDBerrorLog = '/var/log/mediawiki/dberror.log'; If I don't set that, what is the default? [14:48:45] /dev/null [14:48:46] lmat: if you don't set a generic debug log, then they go nowhere (as in they aren't stored) [14:48:46] /dev/null ? :P no idea, sorry [14:48:55] :-o [14:49:04] Well then, I'll set up logging [14:49:49] Debug logging really is for debugging. The logs aren't all that useful if you're not trying to fix something, and they will get very large if you just have them enabled on your wiki all the time [14:50:12] bawolff: I see. Yes, I have an error (see above) [14:50:45] oh, you don't want debug logging for that [14:50:49] Yeah [14:50:56] oh [14:50:57] You just need to enable it to print more stuff out to the web [14:51:03] So you get full errors [14:51:18] Reedy: I think I did that... I did wgShowSQLErrors, wgDebugDumpSql and wgShowDBErrorBacktrace [14:51:29] That... should be enough [14:51:32] Just set: $wgShowSQLErrors = true; $wgShowDBErrorBacktrace = true; $wgShowExceptionDetails=true; [14:51:35] jinx [14:51:47] doesn't say anything else: A database query error has occurred. This may indicate a bug in the software.[bb04e6c7d3024118edb6b0dc] 2017-08-23 14:47:30: Fatal exception of type "Wikimedia\Rdbms\DBQueryError" [14:52:06] $wgShowExceptionDetails = true; [14:52:07] That one too [14:52:23] We have a rediciulous number of variables controlling if sql errors are shown [14:52:45] Reedy: HEY! That one gave data...looking [14:53:10] table doesn't exist. "A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?" [14:53:17] well, did you? [14:53:28] I don't know how to "run" a "schema"... [14:53:35] !update [14:53:35] update.php is a script that updates the database tables. You usually need to run it after upgrading MediaWiki or installing certain extensions. For details, see [14:53:43] By the way, the missing table is from an extension! [14:53:55] answer should still be the same [14:54:01] aye. [14:54:10] does "run a schema" mean "run update.php"? [14:54:22] Weird that the "did you forget..." isn't shown by default [14:54:36] where do you see run a schema? [14:54:57] "application's database schema updater" means update.php [14:55:23] I don't know why we don't just say update.php in that message. Its kind of a silly wording [14:55:39] !fixit [14:55:39] There is no such key, you probably want to try: !sofixit, [14:55:47] bawolff: It's nonsensical actually. [14:56:28] lmat: Not really, its grammatically correct and has all the right words [14:56:46] Its just going to be confusing to the target audiance [14:56:58] bawolff: :-) Yes, grammatically, it's correct. If "run a schema" means anything, I think it would mean "make sure the database daemon is on", right? [14:57:20] With sqlite... That doesn't make sense either :P [14:57:25] bawolff: That reminds me of my friend who was a non-programmer. He asked me how he could "hook up the API"... [14:57:29] Reedy: yeah ;-) [14:58:04] Its saying run a schema updater, not run a schema [14:59:03] I don't see why it doesn't make sense for sqlite - sqlite is less strict than traditional dbs when it comes to schemata, but it still has the same concept [14:59:15] https://gerrit.wikimedia.org/r/373302 [14:59:17] bike shedding time [14:59:29] lol [15:00:30] bawolff: Oh goodness. I misread it. Sorry! [15:00:56] bawolff: That makes much more sense. Then my question would be: "Where is the schema updater?" which is much more serviceable. oof [15:01:10] I guess the only other question is whether to mention the web installer as an option, but maybe that's too much info in the error [15:01:13] that sounds good [15:01:48] Reedy: Hey, that's pretty good! [15:02:12] Or maybe we just add that bit in brackets or something [15:02:32] Already +2'd. Its too late :P [15:02:38] lol [15:03:50] Reedy: Perhaps a link to https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script ? [15:03:55] oh, too late :-P [15:04:03] Well, we can make more patches [15:04:09] I think a plain text link might work... [15:04:15] But we can't guarantee it's HTML [15:04:21] As I think shell can barf with that too [15:05:14] nice. "abort with control-C" I aborted so I could read the message, then ran again. [15:05:17] Oh, Done in 6.6s [15:06:03] EDIT WORKS! \o/ [15:06:10] This wiki is going to change the world... [15:06:21] It's gonna be yuge [15:06:26] You WILL love it. [15:06:40] ;-) [15:08:03] bawolff: MatmaRex just said no [15:08:47] MatmaRex raining on our parade ;) [15:09:02] sorry D: [15:09:22] It makes sense, to the extent it should have MW specific stuff [15:09:31] I didn't even thing about the whole /libs thing [15:09:31] But MW core needs a way to override that message... Or append to it [15:09:37] Obviously we can't use MW hooks [15:10:12] "Maybe we could have some special handling in MWExceptionRenderer to specifically mention update.php?" [15:10:19] Mmm [15:10:58] I guess a task never got filed for it [15:11:25] MatmaRex: Yeah, that [15:13:44] https://phabricator.wikimedia.org/T173946 [15:13:48] oh, we are already doing this for DBConnectionError [15:13:54] so it should be straight forward [15:35:03] block and nuke shows hte same userlist every time even after i blocked and nuked them? [15:35:20] that doesn't make sense [15:46:21] if blockandnuke unintentionally blocks a user, how do i unblock them [15:47:26] and blockandnuke didn't do anything... [15:47:28] bewbs: Special:Unblock should work [15:48:21] cna i see a list of blocked user/ip's [15:49:17] i'm thinking lbockandnuke isn't working for me [15:50:02] when i click blockandnuke it has a list of users. i click the button athte bottom and it comes up with a list of pages and ip's. when i click block and nuke, it just spins [15:53:22] Special:listblocks [16:59:45] How do I test e-mail capability on my server? [17:00:06] It never had me set up a SMTP host...does it have a good default? [17:02:24] errm, you create two users and try to send an email to yourself? :P [17:02:32] what do you mean? [17:02:51] andre__: Yeah, that. [17:03:06] andre__: How does one "send an email to yourself?"? [17:03:47] You register two users, at least one with a valid email address, and then log in as one user and use "Email the user" to the user that has registered a valid email address. [17:03:50] I think. [17:04:49] andre__: "Email the user" is that something one can do within mediawiki? [17:04:55] yeah [17:05:02] andre__: http://lmat.info.tm/LibrEd [17:05:04] or what email functionality are you after actually? [17:05:57] andre__: Nothing in particular, I just want to make sure it's properly configured [17:06:23] So that if an e-mail comes, I'll get it :-) [23:22:19] lmat is discovering MediaWiki!