This came up when this user tried to register is there a fix?

Database error: Invalid SQL: SELECT room FROM c_users WHERE username='Pie'oh'pah' LIMIT 1
MySQL error: 1064 (You have an error in your SQL syntax near 'oh'pah' LIMIT 1' at line 1)
Session halted.

This might help:

http://www.vbulletin.com/forum/showt...threadid=20215

Thanks I added it to sessions.php, I have asked the user to login in again. We will see if that is the fix. Thanks Again.
Calendar hack just about complete.

Joey

Made change above still get same error?

Any Ideas?

edit

ran this query I will wait to see if it fixed it. I believe it has.

UPDATE user SET ignorelist=TRIM(ignorelist);

(Moving to hacks forum as that's quite obviously not from vB)

Make sure you're running the username through addslashes() before attempting to validate it against the database.

ED I don't know what you mean a user just tried to register on my board and that is the error he got. I don't know why he got it. He just did. Not my fault


The query I ran I found on vbulletin

[QUOTE]Originally posted by webhost
ED I don't know what you mean a user just tried to register on my board and that is the error he got. I don't know why he got it. He just did. Not my fault

Yes My apology I looked at it again and see c_users in the error message. That goes with that Chat hack I put in.
I stand corrected and humbled.

Joey

fixed had to change this " ' " with this " . " in the chat software
users config file