FUDforum: Bug Reports » SQL error if search contains Russian characters

Home » FUDforum Development » Bug Reports » SQL error if search contains Russian characters

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

SQL error if search contains Russian characters [message #20626]

Thu, 21 October 2004 17:01

Aonmaster

Messages: 28
Registered: December 2003

Karma:

Junior Member

Hello Ilia,

I'm running FUDforum 2.6.6 at http://akl.ru/forum
Whenever I try searching for any Russian word, it gives an error

(/home/aklnsks9/public_html/fudforum/index.php:116
/home/aklnsks9/public_html/fudforum/theme/default/search.php:444
/home/aklnsks9/public_html/fudforum/theme/default/search.php:636
/home/aklnsks9/public_html/fudforum/index.php:1149
) 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY msg_id ORDER BY word_count DESC LIMIT 500' at line 1
Query: INSERT IGNORE INTO fudforum_search_cache (srch_query, query_type, expiry, msg_id, n_match) SELECT 'd41d8cd98f00b204e9800998ecf8427e', 0, 1098378025, msg_id, count(*) as word_count FROM fudforum_search s INNER JOIN fudforum_index i ON i.word_id=s.id WHERE word IN() GROUP BY msg_id ORDER BY word_count DESC LIMIT 500
Server Version: 4.0.17
[Referring Page] http://akl.ru/fudforum/index.php?t=search&

When enter English word - it goes well. Could you please see what it might be? Thanks.

Report message to a moderator

[Message index]

		SQL error if search contains Russian characters By: Aonmaster on Thu, 21 October 2004 17:01
		Re: SQL error if search contains Russian characters By: Aonmaster on Thu, 21 October 2004 17:14
		Re: SQL error if search contains Russian characters By: Ilia on Thu, 21 October 2004 21:21

Previous Topic:	Powered by FUDforum
Next Topic:	Possible bug in nested categories

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 14:09:17 GMT 2024

Total time taken to generate the page: 0.05641 seconds