FUDforum: Bug Reports » SQL Error if search contains special characters

Home » FUDforum Development » Bug Reports » SQL Error if search contains special characters

Show: Today's Messages :: Polls :: Message Navigator

SQL Error if search contains special characters [message #20220]

Sun, 03 October 2004 12:45

Olliver

Messages: 443
Registered: March 2002

Karma:

Senior Member

If someone enters \ or ' into the search form without any additional characters following, it'll immediately result in an SQL error. This was first broken in 2.6.6 but I've just noticed it's still around in the latest CVS as well. It is also reproducable for this installation here at fudforum.org.

Error message goes like:

Quote:

Fatal error: SQL Error has occurred, please contact the administrator of the forum and have them review the forum's SQL query log in /xxx/xxx/xxx/forum/index.php on line 49

Interesting is, that "\ some more" and "' some more" works without problem. The search only can't handle these characters alone.

Olliver

[Updated on: Sun, 03 October 2004 12:46]

Report message to a moderator

[Message index]

		SQL Error if search contains special characters By: Olliver on Sun, 03 October 2004 12:45
		Re: SQL Error if search contains special characters By: Ilia on Mon, 04 October 2004 13:25
		Re: SQL Error if search contains special characters By: Olliver on Mon, 04 October 2004 13:26
		Re: SQL Error if search contains special characters By: Ilia on Mon, 04 October 2004 13:27
		Re: SQL Error if search contains special characters By: Olliver on Mon, 04 October 2004 13:40

Previous Topic:	Unable to set avatars in user CP
Next Topic:	2.6.6 email notifications bug ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 19:27:39 GMT 2024

Total time taken to generate the page: 0.05973 seconds