Eplanation on why the change

A lot of you are asking why the change.

Yes it was broke (at least cracking anfd failing in many places) and it had to be fixed.

Well the previous bulletin board was a flat text file database using perl language. Using major server resources. Page errors were happening up to 70 times a day. Extremely slow also because we are supplying about 800,000 page views per month.
We had gone past the capabilities of the program (x 10).

I had to find a new system. SQL2000 databases are too expensive and we decided to go for mySQL and php as the language.

I found that we had two options
1. Close the existing board and start a new board with no posts (easy) or...
2. migrate the flatfile text across to mySQL database and continue with the current threads (difficult) and upgrade hardware (expensive)

I chose option 2.
I had to weigh up the differences too.
We have to get more memory yet on the server to run mySQL better than it is now. (should get more on Monday)

It is fully configurable and has losts of options which I am trying to turn off (but having difficulty). eg Avatars

If you do not like the colours then remember I am colour blind, at least you can see the colours
You could help by telling what colours you would prefer.

You can visit the old boards here and check your PMs and read all your old posts.
You can even still send and receive new PMs.

Sadly the change over has had far too many hiccups which will take me some time to solve.

Hope you now have atleast some understanding from this side of the data cable.

Yet to set up the moderator settings. Stay tuned Pele and Charles.

I have learnt what can go wrong generally will. But I know I can sort it out in time

Kindest regards

Malcolm

I have extended name length and signature length to previous boards.
Change to same colours and fonts.
Same old post icons
still more changes to do thanks for all the feed back

thanks malcolm! you deserved kudos for all your hard work. can you answer the question on whether our old intro threads are coming back? (please say yes, please say yes)

Thanks, Malcolm. I feel better now. Really. (Just bring back member statuses when you get a chance, hm? No rush. Just sayin'. )

Thanks Malcolm. I think that explaining things is very important when so many people are so emotionally attached through this place. We all know you are doing the best you can as fast as you can, but don't kill yourself doing it.

One final question...is the fireperformers.com section going to be returned?

Thanks again for the explaination!
Hugs
P~

Man i may get a lot of heat for this but I think it would be better if the avatar option would only be given to those with a higher member status. Say 500... It's only my opinion..

After starting to get used to the changes, I find that I like the facelift for the most part.

there is one thing I severly miss though - the active topics page. The "view posts in the last 24 hours" option we have now is not nearly so satisfying since you can't read the first hundred characters or so of the post before going to it. That was the primary way I skimmed through threads and watched who was replying to things I said while I was still online. I don't like having to open a thread before knowing if anything worthwhile has been said recently. I also liked that the old active topics listed each thread only once. It is very hard to sort through threads now with some of them listed a hundred times (often being the ones were people are just chatting and not saying much of interest to someone outside the conversation) and others only once.

Otherwise I think I will rather like many of the new options once my nostalgia for the old HoP fades away...

I especially love the auto-preview and convenient edit box for your posts - nice! I will use this feature a lot!

don't know what people mean by saying the changes make HoP slower. From where I sit, it seems to be significantly faster now. Is this my imagination?

thanks for the effort you give all of us Malcolm!

I agree about the avatar option only being available to senior HoPpers having more than 500 posts or so - but probably because I have more than 500 myself!

i like, nay i love the new look, cheers mal, its well nice, a more homie feel.....

in terms if the avartars, its like a goal to get one!hell it keeps me cummin back!

K! mal,. cheers for all the work, and hard effort, were can i send my love and money!

ps ordered i thin k12 electic-glow sticks today, ow the joys of having a credit card again!

LALALALALALA

I love it.

really...a HUGE thank you from me..

Well done!

cheers for your explanation, makes sense to me. I wasn't aware it was running off a txt file before, i feel dirty when writting programs a tenth of the size of this that don't use sql! Perl is pretty neat, but when you discover PHP and MySQL for websites there's really no going back. SQL2000 sucks, and ram is cheap. The server that runs HoP chat has 1.1gb of PC133 ram bought for about 60 uk pounds, has an average of 3.2 queries a second and seldom uses more than 2% of a 1ghz cpu. MySQL has been known to crash and be quite erratic on several occasions over the past few years, so be sure to take a backup once in a while.

If you have an niggiling PHP/MySQL questions then let me know

I have a question..

what does erratic mean?

is like lingerie and leather and all that cos if it is then im not allowed to talk about it...mum says so.

erratic

\Er*rat"ic\, a. [L. erraticus, fr. errare to wander: cf. F. erratique. See Err.] 1. Having no certain course; roving about without a fixed destination; wandering; moving; -- hence, applied to the planets as distinguished from the fixed stars.

aha....
from the latin...
i see.


T H A N K Y O U !

Brilliant Change.

Now in a years time we can drop "I remember the old boards..In my day...." into posts! Great!

As for Avatars - let us keep them - otherwise I accidentally read other peoples posts, instead of just mine

Quote:

---

SQL2000 sucks

---

mebbe if you dunno what yer doin..

I'd pick .NET n SQL 2000 over mySQL/PHP any day(ease of use, performance, features, etc)..Only problem is the price for licensing is wayyy too steep..

whats that you say? point and click interfaces are required to bullsh*t your way through your admin job if you don't know what you are doing? OK, yea i agree

To be fair, all things considered, I'd rather have a nice little Oracle number, but for a website?