We have a couple of problems with our smart search
1. The search hangs when searching for 1 letter word
http://www.nakupovanje.net/_search.php?page=1&q=playstation+3
or
http://www.nakupovanje.net/_search.php?page=1&q=v+550
Is this due to ft_min_word_len setting??
2. SQL error when tyring to rebuild database
Remote IP : 91.199.174.100
Logged as : tank
SQL query : SELECT *,
((MATCH (product) AGAINST ('Kartica Eksterna zvočna' )*500) +
(MATCH (descr) AGAINST ('Kartica Eksterna zvočna' )*5) +
(MATCH(xcart_products.keywords) AGAINST ('Kartica Eksterna zvočna' )*100) +
(MATCH(xcart_products.productcode) AGAINST ('Kartica Eksterna zvočna' )*1) +
(MATCH (fulldescr) AGAINST ('Kartica Eksterna zvočna' )*1)) AS score,
xcart_products.avail as avail
FROM xcart_products
WHERE (MATCH(product) AGAINST ('Kartica Eksterna zvočna' )
OR MATCH(descr) AGAINST ('Kartica Eksterna zvočna' )
OR MATCH(xcart_products.keywords) AGAINST ('Kartica Eksterna zvočna' )
OR MATCH(xcart_products.productcode) AGAINST ('Kartica Eksterna zvočna' )
OR MATCH(fulldescr) AGAINST ('Kartica Eksterna zvočna' )
OR xcart_products.productid='0' )
AND forsale IN ('Y')
GROUP BY xcart_products.productid
ORDER BY score DESC
LIMIT 0, 70
Error code : 1191
Description : Can't find FULLTEXT index matching the column list Request URI: /_search.php?page=1&q=Kartica+Eksterna+zvo%C4%8Dna
Backtrace:
/var/www/html/include/func/func.db.php:183
/var/www/html/include/func/func.db.php:109
/var/www/html/include/func/func.db.php:321
/var/www/html/modules/Smart_Search/smart_search_query.php:0
/var/www/html/_search.php:168
3. UTF-8 special characters (like č,š) are not shown in Tags section (the words-tags end where there should be a special character)
Any help would be appreciated
