1 hour maintenance becomes 4, the explanation...

Cloud

Hi all -

Sorry about the downtime today from 10.30 to 2.30 - here's the explanation...

For a while now people have been plaguing me to fix the old UBB Community boards posts, where names were showing up as Guest. I wrote a script sometime ago to do this, but unfortunately it was working on a non-indexed field because it was matching posts by IP address and date (in case a post was at the same time as another, the IP address was a second check, but neither field was indexed) and took ages to run (about a day :-)). Obviously this isn't a goer on a live table (as I soon found out after running it!), but I was able to run the query yesterday on our old box, so that then I could import the results into our existing database. However, I found out today when the script ended that the old Community forum posts weren't even there any more, I either never imported them all correctly in the first place or something else happened along the way.

Anyway, today I went to perform the relatively straightforward matter of importing the 20000 or so missing UBB Community posts, I spent an hour or so manually associating userids from vB with those in UBB (but I only managed to type in the userids for our 150 moderators, there were 1500 users in total who had posted on the old UBB Community forums). When I imported all the posts, the user accounts I didn't want (the non-associated ones) were all imported as well, and even worse, they had exactly the same names as existing accounts - doh! Regi helped out at this stage by removing those duplicate users, but mySQL had a fit when it was trying to remove records of those users in the posts table.

Ehhhh-neee-way! Much starting and stopping and repairing of mySQL files later, we're back up and running. The good news (from our point of view anyway!) is that we're retrieved these 20000 old posts, they may not be associated with the right usernames but at least they're there. Also, our post count has hopped past that of our friendly rivals, P45. Finally, the post counts of the moderating elite will increase if they had posts on the old UBB Community forums (once we get around to updating post counts late at night).

We hope everything is working stabley (is that a word?); we were at one stage looking at restoring the forums from last night's backup but hopefully we haven't lost anything important (except maybe WWMan or bubbles ;-)).

Thanks for your patience - this time, Cloud says oops!

John.
--

Cloud

And before I go, thank you again Regi!

ironbrew

Yess i understand 100%...surprisingly i do understand a few ponit about the scripts!

Also Evn tho im not really worried about that particular board...thanx for making boards.ie a more happy and enjoyable place to be!!

*ok ill get right out of your ass now!

Kulgan

Thanks cloud , is handy for our forum

astrofool

nice one, but, (and you're gonna love this!), each old thread now exists twice

http://www.boards.ie/vbulletin/forumdisplay.php?s=&forumid=50&pagenumber=1&sortfield=lastpost&sortorder=asc&daysprune=1000&x=15&y=12

Karl Hungus

Originally posted by Cloud
Sorry about the downtime today from 10.30 to 2.30 - here's the explanation...

I dont want your explanations!!!
I want that four hours waiting for boards to 'load' of my life back!!!

Gordon

Thanks Cloud - I actually got a bout of unadulterated "work" in today!

Dazzer

Um

Cloud

Most duplicate threads have now been removed.

John.
--