I really don't know if this goes here, but it can't hurt ;).

When registering for the forum here, I noticed that the username I had chosen (Ai'ron) returns a SQL error. I'll go ahead and quote it here:



Looks like the single quote is messing it up. I suspect it's a problem with this version of Invision Power, but from what I remember of PHP, it shouldn't be hard to fix. :)

Off-topic, but excellent work on the website design! As an amateur designer myself, I can't help but be impressed by it. :)

Hey AiRon,

Thanks for posting the sql dump - helps a lot in diagnosing the problem. But thats not neccesary because you've hit the nail on the head. This version of IPB seems to have an inherent problem with apostrophes in usernames.

Considering the PHP syntax i can see why. An apostrophes signals a beginning or end to a String - in this case the string of your username. And so when it gets the ' midway through the name it throws this error.

Sadly, i can't easily fix this error, but i certainly will try find an official patch for it.

Thanks for bringing it up.

Miles
Forum Admin

:)

I was trying to see if I could still register if I escaped the single quotes by putting a forward slash infront of the apostrophe, and it seemed to register all right (I'm sorry, I didn't mean to actually complete the registration, but I forgot there wasn't another step after filling in the proper fields). Problem is that it still displays the forward slash.

I wonder, would registering with "& #39;" (without the space) instead of the apostrophe do it?

Quite possibly... IM me next time you are online so we can test - that way i can instantly delete the new account if it flops.

:)