The resurrection of atari-wiki.com

[exxos]

So the wiki main page states "1,886 articles on this Wiki" and the old temlib clone says "1,124 articles on this Wiki". I get 2957 pages in the database. But not sure why such a huge discrepancy. Though likely the page count on the main page is bad anyway. But with multiple revisions of some pages that *could* account for it.. but I will keep digging before actually doing the delete.

So looks like the revision table has 12353 articles. But that is revisions of the same page. So that's like every page has been revised 10 times kinda thing. So not really worried about that count.

I will do a debug dump of the 2957 pages and see if anything looks off, but possible the main page count is simply wrong I guess.

EDIT:

I think this is likely the discrepancy.. All the images are being classed as a "page" as well.

Capture.PNG

EDIT2:

Looks like the odd spam post might have got though, but kinda expected the odd one to still be there anyway.

Code: Select all

Page ID 1281 exists in the REVISION table Lengame
Page ID 1207 exists in the REVISION table Leonardo
Page ID 1102 exists in the REVISION table Lethal_Xcess
Page ID 1077 exists in the REVISION table Level_Codes
Page ID 3881 exists in the REVISION table License_Status_of_commercial_software
Page ID 57143 exists in the REVISION table Lifetime_Top_5_Unlimited_Online_Drive:_How_Start_Off_An_Web_Business_On_A_Shoestring_Overall_Wedding_Budget
Page ID 1139 exists in the REVISION table Line_A
Page ID 1356 exists in the REVISION table Line_of_Fire
Page ID 1088 exists in the REVISION table Linux_Disk_Commands

EDIT3:

Onward with the page table cleanup :)

Capture.PNG

[exxos]

Seems I need to do some setup somewhere as I can't upload files.
First on my test server I was getting "Maximum file size: 0 B" which turned out to be "post_max_size = 0" in php.ini.

Now something else happens which I don't get.

Capture.PNG

I have also noticed there are some missing pages. So what I am doing is installing the original database on a second test server so I can just export over the missing entries from the database as and when required.

EDIT:

OK the upload was permissions problem on the wiki images folders.

[exxos]

ah dammit! Not sure how this page got removed. Though there is bound to be the odd missing page here and there. In a couple hours i'll have my second test server up so I can export the missing ID's back over to the proper wiki database. Not a big deal. Though finding missing pages is a bit tricky past dumb luck of clicking "random page" currently :shrug:

Capture.PNG

[troed]

ah dammit! Not sure how this page got removed. Though there is bound to be the odd missing page here and there.

Good enough - when we stumble upon such a page let's just copy back from Waybackmachine.

[exxos]

Good enough - when we stumble upon such a page let's just copy back from Waybackmachine.

If only it was that simple :)

1.PNG

2.PNG

It's the only page missing I have found so far.

[exxos]

Seems to be some text files with invalid characters where I have to edit and save the page to get it to view at all :shrug:

Capture.PNG

Also, I can only imagine how frustrating all these types of pages are :roll:

Capture.PNG

I am putting external site references in as I find them but it is rather time consuming.

[exxos]

So the Pompey_Pirates page error is puzzling. I've traced it right though the database and all the info is there. But the ID its chucking out as the not found error, is nowhere near the correct page ID. So I don't know where its getting #5533364 from! I've restored the original database and that's the same, so (thankfully) its nothing I have actually broken!

EDIT:

ahh found the bugger!

Old vs new DB. Don't know how that ended up corrupted. But as the server was seemingly running with bad RAM.. :shrug:

page_orig.PNG

page.PNG

Capture.PNG

[exxos]

Does anyone understand that composer install thing? I never figured that out as I was supposed to use it for my Stripe install, and after battling for some days I found out I could just simply copy the files directly onto my server and not have to bother with it at all! Unfortunately media wiki 1.35 seems hellbent on requiring it.

https://www.mediawiki.org/wiki/Manual:Upgrading
https://www.mediawiki.org/wiki/Composer/For_extensions
https://getcomposer.org/download/

It is way too confusing for me to follow all these topics. I think composer is installed but it does not do anything. If I try run the update script it just says..

PHP Fatal error: Uncaught Exception: Unable to open file /var/www/html/mediawiki/extensions/myComposerExtension/extension.json: filemtime(): stat failed for /var/www/html/mediawiki/extensions/myComposerExtension/extension.json in /var/www/html/mediawiki/includes/registration/ExtensionRegistry.php:185

I mean there is nothing in the folder. Even if I navigate to the folder and do composer install, the first time it installed loads of crap but it still did not put anything in the folder. I completely lost how all this is supposed to work ?!

I mean this really takes the pi$$

Follow the official download instructions to install Composer. Nothing extra needs to be done for it to work with MediaWiki.

[exxos]

If I remove the composer line out of the settings file I just end up back at this again...

Code: Select all

PHP Fatal error:  Uncaught Error: Interface 'Liuggio\StatsdClient\Factory\StatsdDataFactoryInterface' not found in /var/www/html/mediawiki/includes/libs/stats/IBufferingStatsdDataFactory.php:13
Stack trace:
#0 /var/www/html/mediawiki/includes/AutoLoader.php(109): require()
#1 [internal function]: AutoLoader::autoload()
#2 /var/www/html/mediawiki/includes/libs/stats/NullStatsdDataFactory.php(10): spl_autoload_call()
#3 /var/www/html/mediawiki/includes/AutoLoader.php(109): require('/var/www/html/m...')
#4 [internal function]: AutoLoader::autoload()
#5 /var/www/html/mediawiki/includes/libs/objectcache/wancache/WANObjectCache.php(332): spl_autoload_call()
#6 /var/www/html/mediawiki/includes/ServiceWiring.php(662): WANObjectCache->__construct()
#7 /var/www/html/mediawiki/vendor/wikimedia/services/src/ServiceContainer.php(447): Wikimedia\Services\ServiceContainer->{closure}()
#8 /var/www/html/mediawiki/vendor/wikimedia/services/src/ServiceContainer.php(416): Wikimedia\Services\ServiceContainer->createService()
#9 /var/www/html/media in /var/www/html/mediawiki/includes/libs/stats/IBufferingStatsdDataFactory.php on line 13

EDIT:

https://www.mediawiki.org/wiki/Topic:Vxm4ey2j3kafh3m7

So my install files could be corrupted then :roll: I'll start again then.

EDIT2:

OK so don't use winrar to extract a tar file then it seems :roll:

[exxos]

Today I am working on the colossal amount of external links.

This script sorts them all alphabetically so I can see better at a glance what is going on. When it finishes it will group together all the common domain names so then I can use them as a blacklist to delete them from the database later on.

Capture.PNG

On my second test server it is currently updating the original database to a later version of the wiki. Currently we are only running version 25 and I am guineapiging the second test server updating to version 35 LTS. I think they are on version 42 but I want to make sure 35 works first as there is a bit of kerfuffle about not updating in steps and resulting in corruption otherwise. So version 35 is the recommended step.