| SQL error if search contains Russian characters [message #20626] |
Thu, 21 October 2004 17:01  |
Aonmaster
Messages: 28
Registered: December 2003
Karma: 0
|
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.
|
|
|
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]