[00:49:37] Wondering if anyone can assist - upgrading to 1.34 from 1.28 and it is sitting on Renaming index lc_lang_key into Primary to table 110_cache - has been on this for ages. Pages are showing on wiki but no content. [01:20:13] DrewTheGru: when you say "has been on this for ages" can you be a bit more descriptive about time [01:20:27] also it depends on the size of the database as well [01:55:54] Krinkle: cookiecutter-library is for creating a new library, it has all the bootstrap files and stuff. the generator-wikimedia-php-library is an older version by or.i that had some issues, so we/I switched to cookiecutter [01:57:25] Krinkle: in theory we would be able to make changes to the cookiecutter bootstrap and then have an automated tool like libup copy over those changes to existing libraries, but when I tried that there were too many slight variations among the libraries to make it reasonable [02:16:57] https://paste.ubuntu.com/p/XwvGjq7WXK/ [02:17:11] an error occur ...how to fix it [02:23:41] Don’t use 7zip [04:25:43] legoktm: okay, I'll focus on cookie cutter for now then as that one is easier to edit. As a starting point anyway to sync with some of the changes we've made adhoc in some lib repos [04:26:06] Then we can figure out what and if we want to automate on existing one's [04:26:11] ones ^ [04:26:45] sounds good [08:19:31] p858snake|L It was running for at least two hours. I left it for a while longer and then closed the session and reran. All seemed to have worked, thank you for responding. [08:32:45] how do i get the time zone of a wiki? [08:33:24] im looking at Special:RecentChanges and the timestamps are useless to me if i don't know what time zone they are in. arew they UTC? are they my time zone? are they the server's time zone? [08:34:25] ah, it's in user preferences if i am logged in [09:24:44] Hello, i need to use an bot, in my own mediawiki or in Wikipedia??? [09:38:00] anyone know when i perform a backup of my mediawiki db, it crashes when it gets tot the 'text' table? [10:10:37] how do i take a wiki offline? is that a thing? [10:12:55] i don't really want to use $wgReadOnly since that doesn't prevent writes to the database [10:13:35] and the site will still break when the database goes down... [10:20:12] i guess i have to make a splash page and reconfigure my web server ? [11:00:51] unholycrab: if your database goes down, MediaWiki will just display a "unable to contact database" error page [11:05:59] legoktm: what page is that? maybe i can just hack this to say something better... [11:11:34] unholycrab: https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/core/+/refs/heads/master/includes/exception/MWExceptionRenderer.php#304 [11:12:12] thanks legoktm [11:12:21] yw [11:20:48] An HTTP 503 response would be better IMHO for this particular case of outage [12:44:44] anyone know how i can change this --> SELECT old_text,old_flags FROM `text` WHERE old_id = '2858' LIMIT 1 [12:44:50] to delete ? [12:45:00] need to delete this 2858 id which is corrupt [12:45:55] Deleting it would probably give you another error about a missing text record [12:46:29] its just a revision id to a page thats corrupt in the 'text' table of my wiki [12:48:37] will this work? DELETE FROM `text` WHERE old_id = '2858' [12:48:49] DELETE FROM `text` WHERE old_id = '2858' [12:49:25] #1712 - Index text is corrupted [12:49:29] :/ [12:49:44] although my wiki is working and page display ok [12:50:16] Vulpix I can run an bot in my own MediaWiki or in Wikipedia??? [12:57:17] wonderer: You can delete the whole page and then restore all revisions except the one that fails. Or suppress the contents of that revision [12:59:45] Vulpix Why you banned SpainDist??? [13:00:15] kiwi_595: it's a troll/bot [13:11:02] Vulpix MediaWiki 1.36 will be written in Node.JS??? [13:12:01] oops [13:12:07] Vulpix Do not ban me. [13:13:42] Vulpix gd point [13:13:42] Vulpix Do not ban me. [13:14:45] Sorry for the noise, I'm not used to issue those commands [13:15:13] hmm not sure what page the corrupt rev_id pertains too [13:15:19] will try to figure out [13:15:55] How did you find the corrupt text id, then? [13:53:03] when i do a backup [13:53:11] mysql fails on the rev_id [14:02:55] by backup you mean taking an XML dump, or an sql dump? Because if it's the later, there's no way you can fix it by deleting that row. You'll have to put that database for recovery [14:35:03] sorry Vulpix [14:35:11] was busy still troubleshooting [14:35:17] yes xml dump [14:35:35] am going through the log on every rev_id it fails [14:35:48] remove the corresponding page after edit/copy all [14:36:04] and then re-run xml dump until it fails on next rev_id [14:36:11] thats how am working through it now [18:08:11] Reedy: ping