garvinhicking wrote:
Which MySQL version are you using?
Server version: 5.1.49
If you have phpmyadmin, try to execute this query
0 strings
Maybe the UTF-8 characters are not properly en/decoded
At least it seems so: on UTF8 PHPAdmin page all russian content are shown in unreadable form
echo "QUERY: " . $querystring;
Query 1 - "разница"
Code: Select all
QUERY: SELECT ep_sticky.value AS orderkey, ep_cache_extended.value AS ep_cache_extended, ep_cache_body.value AS ep_cache_body, e.id, e.authorid, a.realname AS author, e.allow_comments, e.moderate_comments, a.email, e.timestamp, e.comments, e.title, e.body, e.extended, e.trackbacks, e.exflag, e.isdraft, e.last_modified, a.username AS loginname FROM s_entries e LEFT JOIN s_authors a ON e.authorid = a.authorid LEFT JOIN s_entrycat ec ON e.id = ec.entryid LEFT OUTER JOIN s_entryproperties ep_cache_extended ON (e.id = ep_cache_extended.entryid AND ep_cache_extended.property = 'ep_cache_extended') LEFT OUTER JOIN s_entryproperties ep_cache_body ON (e.id = ep_cache_body.entryid AND ep_cache_body.property = 'ep_cache_body') LEFT OUTER JOIN s_entryproperties ep_access ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access') LEFT JOIN s_entryproperties ep_sticky ON (e.id = ep_sticky.entryid AND ep_sticky.property = 'ep_is_sticky') WHERE (MATCH(title,body,extended) AGAINST('разница')) AND isdraft = 'false' AND timestamp <= 1315845900 AND (ep_access.property IS NULL OR ep_access.value = 'public') GROUP BY e.id ORDER BY timestamp DESC LIMIT 15QUERY: SELECT ep_sticky.value AS orderkey, ep_cache_extended.value AS ep_cache_extended, ep_cache_body.value AS ep_cache_body, e.id, e.authorid, a.realname AS author, e.allow_comments, e.moderate_comments, a.email, e.timestamp, e.comments, e.title, e.body, e.extended, e.trackbacks, e.exflag, e.isdraft, e.last_modified, a.username AS loginname FROM s_entries e LEFT JOIN s_authors a ON e.authorid = a.authorid LEFT JOIN s_entrycat ec ON e.id = ec.entryid LEFT OUTER JOIN s_entryproperties ep_cache_extended ON (e.id = ep_cache_extended.entryid AND ep_cache_extended.property = 'ep_cache_extended') LEFT OUTER JOIN s_entryproperties ep_cache_body ON (e.id = ep_cache_body.entryid AND ep_cache_body.property = 'ep_cache_body') LEFT OUTER JOIN s_entryproperties ep_access ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access') LEFT JOIN s_entryproperties ep_sticky ON (e.id = ep_sticky.entryid AND ep_sticky.property = 'ep_is_sticky') WHERE (MATCH(title,body,extended) AGAINST('разница*' IN BOOLEAN MODE)) AND isdraft = 'false' AND timestamp <= 1315845900 AND (ep_access.property IS NULL OR ep_access.value = 'public') GROUP BY e.id ORDER BY timestamp DESC LIMIT 15
and
- nothing found for разница (must be at least 1 hit)
- empty search-result window (now)
Query 2 - "возраст"
Code: Select all
QUERY: SELECT ep_sticky.value AS orderkey, ep_cache_extended.value AS ep_cache_extended, ep_cache_body.value AS ep_cache_body, e.id, e.authorid, a.realname AS author, e.allow_comments, e.moderate_comments, a.email, e.timestamp, e.comments, e.title, e.body, e.extended, e.trackbacks, e.exflag, e.isdraft, e.last_modified, a.username AS loginname FROM s_entries e LEFT JOIN s_authors a ON e.authorid = a.authorid LEFT JOIN s_entrycat ec ON e.id = ec.entryid LEFT OUTER JOIN s_entryproperties ep_cache_extended ON (e.id = ep_cache_extended.entryid AND ep_cache_extended.property = 'ep_cache_extended') LEFT OUTER JOIN s_entryproperties ep_cache_body ON (e.id = ep_cache_body.entryid AND ep_cache_body.property = 'ep_cache_body') LEFT OUTER JOIN s_entryproperties ep_access ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access') LEFT JOIN s_entryproperties ep_sticky ON (e.id = ep_sticky.entryid AND ep_sticky.property = 'ep_is_sticky') WHERE (MATCH(title,body,extended) AGAINST('возраст')) AND isdraft = 'false' AND timestamp <= 1315845900 AND (ep_access.property IS NULL OR ep_access.value = 'public') GROUP BY e.id ORDER BY timestamp DESC LIMIT 15
- total records: 72 (with unwanted entries \no string inside\ and without expected)