Be Excellent To Each Other

5 is a fair bit quicker, and the only main difference I found is that date/time fields now need you to specify DATE = '0000-00-00 00:00:00' rather than DATE = '' if you want 'date not set'.

Just checked, I *do* have a 'click here to upgrade to mySQL 5' button, but it makes me nervous.

CLICK IT

*screams*

edit:

Updating "MySQL® Version" from "4.1" to "5.0".
MySQL version update occurring in background. This process can take up to 10 minutes to complete.

Haahaa, you'll have 60+ customers on the phone inside the next 20 minutes. GRIM... FOOLED YOU GOOD BOY.

Appears to have gone without a hitch, although I did just do a mega backup of everything known to man, so I was fairly safe eitherway

Yeah, man. For starters, all MySQL 5 queries have to be written in French.

That has just made me laugh far too much.

J'ai juste été ram pillée dans les fesses

Damn you Grim... damn you.

I just noticed one of my sites had bust, some php claiming an invalid query result set where before there was no problem. I just had a look and couldn't work it out because the query appeared perfectly valid.

Then it hit me - I have a field in a table called 'condition'. Turns out 'condition' is a reserved word in mysql 5.0. Booooo!

And that, dear friends, is why you should always put backticks around table and field names in SQL queries.

Also,

PHP version 5.2.5
MySQL version 5.0.45-community

I HOPE YOU'RE HAPPY NOW

you know these forums you host yourself (ie - this one).

I take it SQL is a basic requirement for these right?

Also, is phpBB generally better than Simple Machines?

Yes, you'll need some sort of database (PHPBB can run with most types of database, but MySQL is the most common).
Simple Machines? Never heard of it.

Dude I've already plugged my own services, what are you waiting for?

From what I was able to make out, phpBB is a far more 'established' forum - it's older, gets regular real-world pounding, and is all comprehensive and stuff. Simple Machines is the brash young rookie who so far has done nothing wrong, has taken its knocks without a fuss, and is catching the eye of many a young forum-fancier.

The admin section of PHPBB is pretty complicated.
Again, I can't compare it to Simple Machines.

phpBB also has a pretty fuckin' lax security record, I wouldn't trust it.

That's what it gets for being the most popular, though. PHPBB3 is greatly improved, though (apparently).

[edit]And, er... You're trusting it right now.

Oh hell, yes.

Yeah, I imagine that phpbb, Invision and Vbulletin are the biggest targets for hackers but it also means that there are more people ready to plug the holes when they appear. I think I used Simple Machines initially on my site but I use Fireboard now but only because its a native Joomla component, otherwise I'd be using phpbb myself.

Yeah, but if someone hacks into BeEx through a phpBB security flaw, I couldn't give a shit Not my servers, son

hey chaps,

I've got SQL up and running (one database for my new forum, one ready for 'content'). All the tutorials start with you installing it locally as if your machine was a webserver or something but that's okay.

What's confusing me though is the php side of things. Specifically, they talk about making a connection to the SQL database from a php page which is fine except wouldn't it be incredibly easy to just view the source of that php page and suddenly know all my connection details and thus kill my database if they wanted to?

What's the really obvious stupid thing I'm missing here?

(any help = lots of love from me)

You can't view the source of a PHP page*. Try it with this one - no PHP anywhere.


*Okay, technically it's possible, but only if your apache is set up wrong and isn't actually running the pages as PHP. But you'd realise pretty quickly, because all you'd get is a page of script.

That sounds like MAGIC but I trust you implicitly Mr Grim.

Thanks, I might actually make some progress on this now.

(possibly!)

HEY CHUM. I've completely skipped this whole thread, but I'm going to be setting something very similar up soon, in WordPress. If you would consider switching PEOWW over to WP (although I like the style as is), there's this extremely handy bit of malarky all ready to plug straight in;

http://www.channel-ai.com/blog/plugins/star-rating/

Scroll down to see a table exactly like what you want.

i'm going to bed now but I shall investigate WP and the link thoroughly instead of doing any work tomorrow!

thanks!

Good good.
It's not magic - PHP is a server side scripting language. It does all it's calculation on the server, then outputs the HTML to the client (ie. user), so the client only ever sees the HTML.

Jonarob, I've been having a look at things. I see it was mentioned over at WOS that Wordpress isnt too reliable in heavy traffic situations.

Also, I write for a site that uses CCMS, a content manager thing specifically for gaming websites, which looks good (but isn't free) but they are looking to switch to Joomla.

ARGH!

So I'm torn between trying to do it all myself, using WP or using a Joomla or some other CMS. erk!

Not by itself, but there is a free plugin to solve that issue: wp-cache.

Better add Drupal to your list if you are looking at free CMSs!

Personally, I wouldn't attempt doing it myself when there's already a good choice of other stuff around. Plus if there is a big enough userbase, you'll find a host of useful add-ons (and not-so-useful - unless you want to display the weather in Estonia for example) should you need them

Ah, but if I'd have had that attitude six years ago I'd be digging up the M1 with a JCB right now.

As opposed to digging it up with your landie.

Fuck yeah.

Oh yeah, sometimes it's better to learn it for yourself - even with my amateurish php skills I've knocked up a few things that this company now use regularly but with content management, everyone seems to have had a go so to me it makes sense to go with something that has already had shedloads of development thrown at it.

Aye, the number of things you can tack onto WP is fucking awesome.

I'm now putting that cache thing onto mine that The Gaywood suggested. It might prove handy if anyone actually cares to look at the blog this month. I'll be relying on you all to spam the URL in places where it'll get loads of interest and thus make me loads of money.