![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
(no subject)
Sep. 3rd, 2006 05:00 am... i need to remember not to start singing out loud when in the kitchen at night ...
Ok, time for a more real update.
First, last day in the materials departement. Not much went on. Received a huge amount of vynil and aluminium wall covering stuff, and MDF panels and other junk.
The MDF stuff lead to an argument at work about what it's worth. Some people were arguing that it was much better than wood, since it's in one single piece and easier to cut and nail and stuff. I argued that it was crap, because it would absorb water and deform, it didn't stay straight on it's own, would get dented or torn easily, and was cardboard.
And the break ended before anything came out of this.
Once i got home, i got in the same argument with my mom. So i decided to prove my point.
This is what happens when MDF gets wet. Not really nice. You have there another piece just like the one i got wet. And that was about a minute in the kitchen sink.
... and out of curiosity, i had to microwave it later. Which made it explode.
At least, i think i proved my point.
After that, it was working on Rashan's forum, as he finally had sent me the backups and what he managed to keep when his host kicked him off.
Turns out, there were a few dozen shells and stuff installed there. C99 and others, usual stuff. But there were just so many copies that it took forever to clean up.
After that, it was phpBB/IntegraMOD hell. Turns out that the version he had (1.4.0) wouldn't work with PHP5 and the rest of my setup. But i found a beta of 1.4.1, which did work. And which was also MUCH better, as 1.4.0 was over a year old, with tons of exploits.
So i went with 1.4.1. Turns out, there's no actual way to upgrade, you have to reinstall. Blah. And with a reinstall, the old DB still is setup for 1.4.0, which means it has to be fixed by hand. Which was hell. And the backup plugin also didn't include various other plugin's tables, so those had to be recreated manually. And the plugins themselve had versions conflicts, wanted only PHP4, only MySQL 3, or various other conditions. Complained about chmod on windows...
Then once things wanted to try to load, it was all the supposed "security plugins" all finding something wrong, trying to block me because i was apparently hacking, and then try to write a hacking report to the DB, which didn't work due to misconfig, and just created a huge chain of problems. Most of them just got commented out until the board would load.
Also had quite a bit of fun with the database backups. Turns out that the spellcheck for it has the whole dictionary in the DB. And that the search engine for the forum works by putting every single word ever used in a table, giving them an unique ID, then making another table where you have millions of entry for where each word is used. Total size? about 45mb. Waaay too much.
In addition to that, the export thing for the backup used the wrong quotes/double quotes/etc in various places, forgot to escape certain characters, and all kinds of things like that. So i had to fix or delete dozens of lines manually. Took about 2h to do just that.
Finally, i got the thing to load right. I still have a few small-ish bugs to fix, like the knowledge base not finding stuff, but the posts, PM, chat and shoutbox are working. I think that's the most important part.
Now once Rashan sets the DNS server for the domain to DynDNS's, i can put his board publicly availible again
And i think i'll get a bit more sleep now.
... i need to write about a certain dream later. It was fun.
Ok, time for a more real update.
First, last day in the materials departement. Not much went on. Received a huge amount of vynil and aluminium wall covering stuff, and MDF panels and other junk.
The MDF stuff lead to an argument at work about what it's worth. Some people were arguing that it was much better than wood, since it's in one single piece and easier to cut and nail and stuff. I argued that it was crap, because it would absorb water and deform, it didn't stay straight on it's own, would get dented or torn easily, and was cardboard.
And the break ended before anything came out of this.
Once i got home, i got in the same argument with my mom. So i decided to prove my point.
This is what happens when MDF gets wet. Not really nice. You have there another piece just like the one i got wet. And that was about a minute in the kitchen sink.
... and out of curiosity, i had to microwave it later. Which made it explode.
At least, i think i proved my point.
After that, it was working on Rashan's forum, as he finally had sent me the backups and what he managed to keep when his host kicked him off.
Turns out, there were a few dozen shells and stuff installed there. C99 and others, usual stuff. But there were just so many copies that it took forever to clean up.
After that, it was phpBB/IntegraMOD hell. Turns out that the version he had (1.4.0) wouldn't work with PHP5 and the rest of my setup. But i found a beta of 1.4.1, which did work. And which was also MUCH better, as 1.4.0 was over a year old, with tons of exploits.
So i went with 1.4.1. Turns out, there's no actual way to upgrade, you have to reinstall. Blah. And with a reinstall, the old DB still is setup for 1.4.0, which means it has to be fixed by hand. Which was hell. And the backup plugin also didn't include various other plugin's tables, so those had to be recreated manually. And the plugins themselve had versions conflicts, wanted only PHP4, only MySQL 3, or various other conditions. Complained about chmod on windows...
Then once things wanted to try to load, it was all the supposed "security plugins" all finding something wrong, trying to block me because i was apparently hacking, and then try to write a hacking report to the DB, which didn't work due to misconfig, and just created a huge chain of problems. Most of them just got commented out until the board would load.
Also had quite a bit of fun with the database backups. Turns out that the spellcheck for it has the whole dictionary in the DB. And that the search engine for the forum works by putting every single word ever used in a table, giving them an unique ID, then making another table where you have millions of entry for where each word is used. Total size? about 45mb. Waaay too much.
In addition to that, the export thing for the backup used the wrong quotes/double quotes/etc in various places, forgot to escape certain characters, and all kinds of things like that. So i had to fix or delete dozens of lines manually. Took about 2h to do just that.
Finally, i got the thing to load right. I still have a few small-ish bugs to fix, like the knowledge base not finding stuff, but the posts, PM, chat and shoutbox are working. I think that's the most important part.
Now once Rashan sets the DNS server for the domain to DynDNS's, i can put his board publicly availible again
And i think i'll get a bit more sleep now.
... i need to write about a certain dream later. It was fun.
