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 :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
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 08:45 Go to next message
Olliver   Germany
Messages: 443
Registered: March 2002
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
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 08: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 09: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
add to buddy list
ignore all messages by this user
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 09:26 Go to previous messageGo to next message
Olliver   Germany
Messages: 443
Registered: March 2002
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
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 09: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
add to buddy list
ignore all messages by this user
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 09:40 Go to previous message
Olliver   Germany
Messages: 443
Registered: March 2002
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
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
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
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: Sat Oct 21 19:18:11 EDT 2017

Total time taken to generate the page: 0.00720 seconds