The resurrection of atari-wiki.com

[exxos]

The articles seem fine again now AFAICT. Though I have found there's a switch in the settings file to store images in folders. This seems to have changed in later versions of the wiki breaking how images are uploaded. So I've fixed that now.

Mostly still puzzling over why 99% of the images are "not found" anymore. Uploaded a test image and its fine. Looking in the image database there isn't anything different in the rows than non-working images.

If I try and upload the same image file, it says its there already.. so it knows and doesn't know there's a image then

1.jpg (82.75 KiB) Viewed 5111 times

Not been able to do much today, seem to have a eye infection making it hard to focus on stuff

[exxos]

I have noticed a couple of things. For some reason some users have been deleted from the user database. Currently I'm not sure what point they vanished. The user delete script I wrote only seems to delete users with no email or usernames. Though I must of had another script at some point because that alone would not have cleared out the spam users. I think what may have happened was I was only checking users had posted anything, it is possible users uploaded a lot of images but do not actually post anything and thus could have got deleted out at some point. Oops!

Though one of the scripts is supposed to fix that which seems broken and doesn't fix them

So what I did was to copy the original user database over and use that one then upgrade the wiki to version 25 as thats my WIP wiki. Now oddly in the file list it looks like all the images are now present!

The problem is, files are still missing from the home page etc looking at one of the images..

filelist.PNG (175 KiB) Viewed 5055 times

Past revisions are there but the current version which is at the top of the list does not work still because I only altered to relating tables, I compare them to the original database and they looked identical.

This leads to another strange issue that the original database does not list any files whatsoever in the filelist page. However the images actually show up on the wiki just fine . So I think something was broken on the original database anyway

Another really bizarre oddity in this, as I deleted the whole images folder on the server, so files were not there whatsoever. I also wrote a script which search the whole database for any entries whatsoever of a particular image file and delete them out. So when I went to try and upload the missing file, the wiki software reported the images already there! If I go on the file list and click delete image, says file not found! So I don't see how the file can and cannot be there at the same time. Needless to say I think something is seriously FUBAR in the wiki scripts somewhere.

I only got one reply to my request with the wiki developers, it was only a tweaked one line I was running but it did not do anything anyway. I'll post a small day since then what I think its pretty clear nobody cares, not really surprised.

So currently I am running a tweaked script I found on github (***) and running the update script again to see if that fixes the user problem at least. Having the images actually show up in the file list is a huge step forward in any case. I did try also updating to version 39 of the wiki but it seems to all become broken after version 33 when the information about that person says it did a lot of database changes.

(***) The script was not actually "broken" I added in $id =null; around line 190 to fix the problem.

The next puzzle after that, is why the latest images are not showing up on actual pages.. Though the images I uploaded do show up just fine.

EDIT:
So the new cleanupUsersWithNoId.php now got the "guest users" and the filelist now shows as in the image. So progress at least!

EDIT2:

Using cleanupUsersWithNoId.php from V35 of the wiki (i'm on 33 currently) seems to have brought back several more images and the Xenon animation is now back on the home page.. Calamus.jpg is still missing as well. odd.

[exxos]

Once upon a pixelated night in the digital realm, a web developer named Exxos found himself entangled in a perplexing labyrinth of MySQL errors on his webpage. Frustration mounted as glitches multiplied like elusive database ghosts.

In a moment of whimsy, Exxos decided to confide in a trusty rubber duck perched on the desk. To his bewilderment, the rubber duck quacked to life, its plastic wings flapping with enthusiasm.

"Let's quack this SQL sorcery away!" declared the now-animate rubber duck, introducing itself as Quacktus, the interdimensional debugging duck.

Together, they embarked on a wild adventure across the binary cosmos, surfing the data streams and dodging MySQL gremlins. Quacktus shared tales of debugging dilemmas in the Rubberverse, where relational mysteries were the ultimate challenge.

Their first pitstop was Debuggledon-9, a planet ruled by sentient queries. Quacktus engaged in a heated debate with the SQL Overlord, convincing it to reveal the secrets of optimal database performance. Armed with newfound wisdom, they surfed a cosmic wave to Syntaxia, a dimension where code spoke in SQL statements.

With Quacktus' knack for deciphering MySQL intricacies and Exxos's newfound interdimensional coding insights, they traversed the realms of logic and absurdity. On the Quantum Quackway, a highway of queries and joins, they encountered a digital oracle who foretold the resolution of Exxos's MySQL miseries.

As the final quack echoed through the cyberspace, the MySQL errors surrendered to the mighty debugging duo. The rubber duck, having completed its mission, transformed back into an inanimate desk companion.

Amid the glow of victorious code, Exxos sat back, grateful for the quacktastic journey that had led to debugging enlightenment. And so, the legend of Quacktus, the interdimensional debugging duck, lived on in the annals of web development lore.

[stephen_usher]

[exxos]

So currently I'm not aware of any issues on the wiki

1.PNG (257.78 KiB) Viewed 4989 times

So next I'm going to update to a more recent version..

The second test server still trying to update the original database. Though I think I'm just going to nuke that account because currently it is costing around £50 a week with all the servers and size of all the backups etc

[Cyprian]

great news.
does that test server available for everyone?

[exxos]

great news.
does that test server available for everyone?

The test server is only available for people who are helping fix broken links and sites etc. Then once content is mostly fixed, the wiki will be moved to my exxoshost server for public access via www.atari-wiki.com

[exxos]

So I had to upgrade from 33 to 35 first which was almost pointless. Now upgraded to the latest v40 Will do some tests tomorrow see if it all still works.

Looks like the article count went down for some reason. Though it is only 4 less than the temlib one. It is possible for articles could have simply been lost or the temlib count is wrong. The thing is I actually added a few pages so.. No idea.

Capture.PNG (21.79 KiB) Viewed 4966 times

Something in the updated wiki broke. It is back to those invalid characters it is not liking again

Capture.PNG (139.98 KiB) Viewed 4964 times

2.PNG (46.27 KiB) Viewed 4962 times

3.PNG (27 KiB) Viewed 4962 times

[exxos]

It seems a drop in article count is down to now "invalid pages". So I got the A.I. to write a script to look for invalid characters from the CP437 set..

So I need to figure out what went wrong there... And guess something else which is broken in the wiki now which I will have to fix

2.PNG (26.82 KiB) Viewed 4953 times

Some pages my script finds actually load fine anyway. So I could be finding old revisions of files which are no longer active anyway.

[exxos]

OK so I have no idea what happened here. temlib copy vs the updated wiki now...

temlib.PNG (29.15 KiB) Viewed 4991 times

wiki.PNG (20.23 KiB) Viewed 4991 times