taizou @lion@computerfairi.es

well my internet went down but i'm tethering off my phone to fucking finish this
I deleted all those orphaned slots/content entries and ran the script. the script actually found the orphaned text this time but threw an error when trying to delete it. so I ran another sql query to delete the text
THAT failed cos it ran out of space while trying to write a temp file so I'm now doing them 100 at a time

@mavica_again good, I'll keep posting
Or I would but my internet has just gone down

OK so what I figured out is that revisions are linked to content by the "slots" table, and the "slots" table suspiciously has 2888 entries referencing nonexistent revision ids, which is the exact same number of archived revisions that were purged
So I THINK I should be safe to delete those slots and Then delete the content entries corresponding to those slots and Then delete the text entries corresponding to the content entries

Sorry for posting through this btw

I Think what happened was the first script purged the references to the revisions in the "archive" table, meanwhile the second script is looking for references in the "content" table which was not actually touched by the first script
so uhhhhh I guess I can try and identify orphaned content entries myself and delete them and then run the second script and hope I don't fuck everything up

How did I even get here this has nothing to fucking do with Docker

so i ran a mediawiki script to purge the deleted revisions, which worked
but that script then runs another script to purge orphaned text records (which are the thing that is actually taking up the space) and that... did nothing
cool cool thanks

oh christ it's from when i had open talk pages and they got spammed to shit & its stored thousands of revisions of megabytes of fucking spam in the database

was looking into how much free space i have on my VPS before i do all this & found that i'm using like half the 40GB available
and of that like 4GB was /var/log/journal so i configured it to use max 100MB because i never checked those logs in my life?
another 4GB ibdata1 in mysql which .......apparently is mostly accounted for by my notes wiki db WHY there's barely shit in there

I keep reading the subtitle of Like a Dragon Gaiden as "The Man Who Eated His Name" and I'm not sure what I can do about that

Okay I got too into all this and it has become 2:30am whoops
Made pretty good progress though. I had a big list of todos and problems and questions from last time & I've got through all of them except for some PHP extensions I still need to install
Then if that all works I can try it on the actual server.....

doing a bit of housekeeping on the existing code first. like trying to get rid of php short open tags. i used to use those a lot

can't actually be bothered but i was thinking about maybe doing something new on there & i don't want to be held back by the old sites running on old versions of things on the same server

might jump back on the "trying to run my personal websites through docker" thing. i guess. maybe

@frost They're both famiclone handhelds with a mixture of mostly hacks and Nice Code games on them. The bottom one has two fake "cartridges" that activate a few extra games