The resurrection of atari-wiki.com

[exxos]

So in phpmyadmin it looks fine...

pm.PNG

It crashes the wiki.

w1.PNG

If I click EDIT..

e.PNG

Now if I copy the text in phpmyadmin and paste it into the EDIT page and click preview...

p.PNG

It seems to work fine. So no idea what's going on here ? But this is a problem as there are 100's of articles which are now crashing the wiki after the recent update. I suspect the encoding for the database got changed at some point. So I am looking into that currently.

[troed]

Agree, the text not displaying correctly and that error message sounds like it. However, you might want to do the same patch as this to make sure it's not a different error altogether where the error message itself causes the malformed characters:

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

[exxos]

Agree, the text not displaying correctly and that error message sounds like it. However, you might want to do the same patch as this to make sure it's not a different error altogether where the error message itself causes the malformed characters:

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

I did see that one, but they doing that on the setup wiki script not on the wiki itself.

After resubmitting the page, it changed in the database and looks corrupted there, but now fine in the wiki :shrug:

Capture.PNG

EDIT:

Looks like its Windows 1252: Western European encoding.

[exxos]

So it seems pages which crashed the wiki are in CP1252 format, and when they are resubmitted they are resubmitted as ASCII text.

Long story short on a lot of scripts later...

It turns out there is seemingly 89 pages with character problems which crash the wiki. So I will just manually go through the database and convert them next. Won't have much time tomorrow though as out most of the day. But might get it done when I get back home tomorrow night.

I have also found there is some really bizarre SQL cache going on. Even if I completely delete the database and reuploaded from a backup, the pages I deliberately added things like "OOOOOOOOOOOOOOOOOOOO" on the top of the text so I could identify them in the database easily.. Those still appeared even though the database had been completely rewritten !!! I cleared the cache in chrome, tried a different browser, tried holding down control,shift,alt to refresh, tried restarting the SQL server. In the end I just had to reboot the server so it would actually display the proper data from the database...

No idea if anyone's got any ideas why it is doing that to start with ?! It had me confused for a while what was going on because changes I was doing was not showing up on the wiki but was in the database.

I hate computers!

[exxos]

So temlib has 1,124 articles, my wiki has 1,120 articles. I did add a couple pages. So not sure where the discrepancy came from.

In any case, if anyone can help with a script for verifying temlib against my wiki.... Can doublecheck I have not actually lost any pages.. But as I said previously there could be collateral damage anyway somewhere...

[troed]

I tried search for an existing tool but failed, although I'm very certain such tools exist.

Creating a script to curl the mainpage and then all linked internal pages in a tree, comparing some value, isn't that difficult. I could do it, although reinventing the wheel should always be avoided :/

[exxos]

It might not be to hard as there are lists of pages https://temlib.org/AtariForumWiki/index ... l:AllPages

I do recall there being several pages not linked anywhere on the wiki. But I assume both wikis have the same problem. I'll add it to my neverending list of things to do.

[exxos]

I fixed all the pages which were crashing the wiki AFAIK now.

The A.I. and I have been doing scripts to check the discrepancies. Some of the pages I added which are obvious. The only one which seems to be in temlib and not my wiki is the ST_Diagnostic_Cartridge page. I actually created a new page for that already anyway. But as it might break links, I will put the page on my wiki for now.

Found this one as well.

https://temlib.org/AtariForumWiki/index.php/Expos%C3%A9 But not sure what the Expos%E9 one was, doesn't seem to exist.

The only other discrepancies just seem to be generic ones like register account etc.. But my script for extracting links from the wikis probably did not bypass those types of links. Of course registering is not permitted why am still fixing things.

So there is still a discrepancy of two pages.. But I'm not really worried about this because I have actually added more pages to my wiki. So I can only assume the temlib pages count is not correct at this point. :shrug:

Code: Select all

/AtariForumWiki:Privacy_policy (Not found in )
/AtariForumWiki:Privacy_policy (Not found in )
/AtariForumWiki:About (Not found in )
/AtariForumWiki:About (Not found in )
/AtariForumWiki:General_disclaimer (Not found in )
/AtariForumWiki:General_disclaimer (Not found in )
/Expos%C3%A9 (Not found in output_links_EAW.txt)
/Expos%C3%A9 (Not found in )
/Request_Account (Not found in output_links_EAW.txt)
/Request_Account (Not found in )
/ST_Diagnostic_Cartridge (Not found in output_links_EAW.txt)
/ST_Diagnostic_Cartridge (Not found in )
/32mhz_booster_by_exxos (Not found in )
/32mhz_booster_by_exxos (Not found in )
/DFB1X_50mhz_booster (Not found in )
/DFB1X_50mhz_booster (Not found in output_links_AFW.txt)
/User:Exxos (Not found in )
/User:Exxos (Not found in output_links_AFW.txt)
/User_talk:Exxos (Not found in )
/User_talk:Exxos (Not found in output_links_AFW.txt)
/Atari_Wiki:Privacy_policy (Not found in )
/Atari_Wiki:Privacy_policy (Not found in output_links_AFW.txt)
/Atari_Wiki:About (Not found in )
/Atari_Wiki:About (Not found in )
/Atari_Wiki:General_disclaimer (Not found in )
/Atari_Wiki:General_disclaimer (Not found in )
/Diagnostic_Cartridge (Not found in )
/Diagnostic_Cartridge (Not found in output_links_AFW.txt)
/Expos%E9 (Not found in )
/Expos%E9 (Not found in output_links_AFW.txt)
/Monochrome_Games_for_ST (Not found in )
/Monochrome_Games_for_ST (Not found in output_links_AFW.txt)
/NVRAM_RTC_by_exxos (Not found in )
/NVRAM_RTC_by_exxos (Not found in output_links_AFW.txt)
/ST536_50mhz_030_with_alt-ram_booster_by_exxos (Not found in )
/ST536_50mhz_030_with_alt-ram_booster_by_exxos (Not found in output_links_AFW.txt)
/STF/M/E/030/MST_PSU_replacement (Not found in )
/STF/M/E/030/MST_PSU_replacement (Not found in output_links_AFW.txt)
/ST_PSU_servicing_and_upgrades (Not found in )
/ST_PSU_servicing_and_upgrades (Not found in output_links_AFW.txt)
/ST_RGB_Video_DAC_upgrade (Not found in )
/ST_RGB_Video_DAC_upgrade (Not found in )
/Serenaid (Not found in )
/Serenaid (Not found in output_links_AFW.txt)
/Sony_MPF920_Floppy_Drive_conversion (Not found in )
/Sony_MPF920_Floppy_Drive_conversion (Not found in output_links_AFW.txt)
/The_Atari_ST(E)_BLiTTER_in_brief_by_The_Paranoid_of_Paradox_2012 (Not found in )
/The_Atari_ST(E)_BLiTTER_in_brief_by_The_Paranoid_of_Paradox_2012 (Not found in output_links_AFW.txt)
/V2.2_16mhz_booster_by_exxos (Not found in )
/V2.2_16mhz_booster_by_exxos (Not found in output_links_AFW.txt)

My copy of the wiki has a few pages we are not in the temlib wiki as well.

So overall out of I think it was like 9 million spam pages, if the collateral damage was only 2 pages (which are now copied over) , then I think it went incredibly well :)

[exxos]

Past users of the wiki with the exception of the ones who said they were going to help fix links etc, all the passwords have been changed to a really long one. I doubt any of these users will be coming back, but their account still exists, but it would require a admin to change their password so they can login again.

Changed all the passwords because there was no way to tell if any of these accounts was compromised. Considering a lot of these accounts are 20+ years old now, it is likely the passwords are not very secure anyway. I did not want to take any risks so all the passwords have been reset to something different.

For the time being open registration on the wiki will not be allowed. Accounts would otherwise have to be verified by a admin and I really don't want to create anyone any more work in trying to figure out which accounts are genuine or spammers etc

Currently only admins can create accounts for users. So users must currently request a account creation by a admin. While it is not finalised, the admins will of course be moderators on here, plus MugUK from AF. Any page edits / creations etc will also have to be reviewed by a admin before being published.

The above may be relaxed or changed in time. Though my primary objective is not allow spammers to register on the wiki, and even if they do manage to somehow get on the wiki, changes will be intercepted by a admin.

I doubt there will be a massive amount of people willing to contribute to the wiki anyway. I don't think manual creation of accounts upon request is going to take up a lot of time. Otherwise , having open registration could quickly turn into a huge nightmare.

In case anyone is wondering, I did mention it a few days back anyway. I was going to link accounts from this forum to the wiki so it would make things easier for users that way. The problem is, it requires forum extensions, and wiki extensions, and they both have to talk to each other and also be maintained. I just foresee it ultimately being a huge headache in maintaining all that. So the wiki will be completely isolated from forum users. I think long-term if the wiki gets taken over by someone else in the future, it is not going to be dependent on forum accounts to be able to function.

[MugUK]

It's been a loooooong while since I last tweaked a page in MediaWiki as an old job forced me to learn Twiki :)