That does confirm how little he knows about databases.
I would say he's playing the fool to fool some fools
Exactly.
"Deny everything" has been his middle name.
Deliberately ignoring the facts, as the easiest way to make any conversation meaningless.
Proven formula, used for years...
BTW these links are still broken. They are now referencing files that don't exist at "/pics/comments/" instead of files that don't exist at "/zxdb/sinclair/".
@Lee Fogarty you will need to download these images from the ZXDB repository and upload them to your site in order to make them work!
NOTE: Also reproduced from my post at the WoS forum
In case anyone missed what happened, I have this strange habit of taking screenshots of evidence in case it disappears somehow...
This is the Joust page until a few minutes ago:
This is what happened to WoS while the database was getting modified directly:
And this is the same page now:
Interestingly the "Updated On" date at the bottom hasn't changed. It's because the database was updated directly (then the entire website restarted in a hurry) instead of using the online update tool at WoS to do it. Perhaps because it wouldn't look too good in "What's new?" page to explicitly say "replaced ZXDB links"? We will never know...
NOTE: Also reproduced from my post at the WoS forum
If you open this page and look at "Known Errors", it will look like this:
Can you see that broken link icon? Right click on it and choose "open image in new tab". You will find out the reason it's broken is because this file is missing:
All this taking WoS down to update something in the database seems to be making a mockery of the "live updates". In fact, why the hell does a database driven site even need to be taken down? I have never had to stop a site whilst I made a database update. Or if so, incredibly rarely, as in so rare I can't remember ever doing it in the last 20 years.
Vampyre wrote: ↑Thu Jul 02, 2020 7:33 pm
All this taking WoS down to update something in the database seems to be making a mockery of the "live updates". In fact, why the hell does a database driven site even need to be taken down? I have never had to stop a site whilst I made a database update. Or if so, incredibly rarely, as in so rare I can't remember ever doing it in the last 20 years.
Perhaps because the live update system was not planned to make changes, without storing evidence about what exactly was changed.
Although rebooting the site to hide evidence is just making it too obvious that there's an attempt to hide evidence.
Well, I must confess it's exciting to keep an eye right now on WoS, while waiting to see if it will reboot again to erase the new "Ant Attack" evidence.
Seven.FFF wrote: ↑Thu Jul 02, 2020 7:30 pm
I bet there’s hundreds of these, and he’s not smart enough to write a query to find them all, and do a batch fix and image download from SC
This is why I don't get why a database driven site even needs to go down. SELECTing that data is pathetically easy to do to find them and the UPDATE with a REPLACE isn't much harder. It's really entry-level database CRUD stuff that anyone with a few weeks of experience should be able to do.
God knows. I've given up trying to work out what the hells going on over there.
Err, hello, please don’t spoil the fun of watching a half hidden game of wack-a-mole!
Said game is fun to watch
Last edited by 1024MAK on Thu Jul 02, 2020 8:07 pm, edited 1 time in total.
Standby alert
“There are four lights!”
Step up to red alert. Sir, are you absolutely sure? It does mean changing the bulb
Looking forward to summer later in the year.
Of course, anyone can now play along looking for ZXDB Easter eggs on WoS
Standby alert
“There are four lights!”
Step up to red alert. Sir, are you absolutely sure? It does mean changing the bulb
Looking forward to summer later in the year.
Seven.FFF wrote: ↑Thu Jul 02, 2020 7:30 pm
I bet there’s hundreds of these, and he’s not smart enough to write a query to find them all, and do a batch fix and image download from SC
This is why I don't get why a database driven site even needs to go down. SELECTing that data is pathetically easy to do to find them and the UPDATE with a REPLACE isn't much harder. It's really entry-level database CRUD stuff that anyone with a few weeks of experience should be able to do.
God knows. I've given up trying to work out what the hells going on over there.
Perhaps because he also needed to reset the cache in a hurry.
I bet he doesn't have a mechanism that updates the cache, after avoiding his own online update system and changing the database directly.
Einar Saukas wrote: ↑Thu Jul 02, 2020 8:09 pm
Perhaps because he also needed to reset the cache in a hurry.
I bet he doesn't have a mechanism that updates the cache, after avoiding his own online update system and changing the database directly.
That's most probable reason. I think that he does have some cache updating mechanism, but not for the case when the database is directly updated. Clearing the cache then is easy as well, but it requires doing, and if such entrypoint is not ready, then the quickest way is to restart the whole server.
I usually reboot Redis only, so ZX-Art doesn't go down, just becomes slower for some seconds.
Vampyre wrote: ↑Thu Jul 02, 2020 7:57 pm
This is why I don't get why a database driven site even needs to go down. SELECTing that data is pathetically easy to do to find them and the UPDATE with a REPLACE isn't much harder. It's really entry-level database CRUD stuff that anyone with a few weeks of experience should be able to do.
God knows. I've given up trying to work out what the hells going on over there.
Perhaps because he also needed to reset the cache in a hurry.
I bet he doesn't have a mechanism that updates the cache, after avoiding his own online update system and changing the database directly.
Good point about the cache. Think you've got to the root of it.
Standby alert 
