Register User Error?

[webhost]

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.

[Steve Machol]

This might help:

http://www.vbulletin.com/forum/showthread.php?s=&threadid=20215

[webhost]

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

[webhost]

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);

[Mike Sullivan]

(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.

[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


that's quite obviously not from vB)

The query I ran I found on vbulletin

[Steve Machol]

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 faultI believe what Ed means is that this error is being caused by a hack you installed and not from vB.

[webhost]

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

[webhost]

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