FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » SQL Error if search contains special characters
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
SQL Error if search contains special characters [message #20220] Sun, 03 October 2004 12:45 Go to next message
Olliver   Germany
Messages: 443
Registered: March 2002
Karma: 0
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

Re: SQL Error if search contains special characters [message #20231 is a reply to message #20220] Mon, 04 October 2004 13:25 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Fixed in CVS.

FUDforum Core Developer
Re: SQL Error if search contains special characters [message #20233 is a reply to message #20220] Mon, 04 October 2004 13:26 Go to previous messageGo to next message
Olliver   Germany
Messages: 443
Registered: March 2002
Karma: 0
Senior Member
I've did some more testing and have to extend my bug report:

It seems that error will occur whenever someone attempts to perform a search with a single printable character as search term.

Olliver
Re: SQL Error if search contains special characters [message #20235 is a reply to message #20233] Mon, 04 October 2004 13:27 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
the error ccurred whenever the search string didn't contain any valid words.

FUDforum Core Developer
Re: SQL Error if search contains special characters [message #20238 is a reply to message #20235] Mon, 04 October 2004 13:40 Go to previous message
Olliver   Germany
Messages: 443
Registered: March 2002
Karma: 0
Senior Member
I didn't notice your reply while I was editing my second message, sorry. Anyway, the error has been fixed and the search is doing fine again.

Thnx a ton
Olliver
  Switch to threaded view of this topic Create a new topic Submit Reply
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) ] [ RSS ]

Current Time: Fri Nov 22 19:50:28 GMT 2024

Total time taken to generate the page: 0.02997 seconds