X-Cart forums

[starwest]

Originally Posted by Manic

Great Mod!
Anyone know where to comment out the phrase "This search took xxxx seconds"?

Thanks

In skin1/modules/Smart_Search/smart_search.tpl comment out:

<div align="right">
{if $query_time}{$lng.lbl_took_seconds|replace:'query_time':$query_time}
{/if}</div>

[Manic]

Thanks!

[starwest]

Has anyone else had any experience with this mod as it relates to wholesale pricing? We've got various membership levels setup on our site and it seems that Smart Search only wants to display the standard/retail price no matter what membership level our customers are logged in as.

If you utilize wholesale pricing with this mod, I'd love to know whether or not you're experiencing the same thing. We've tried with the stock tpl files, and it still happens, but perhaps I missed something.

[Cefko]

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

[wjbrewer]

New Smart Search Available Jan/Feb '09.

Over the past several months I have re-written then entire engine to the Smart Search. New features are:

• 30-500% faster on the customer side.
• Product Options included in search.
• Custom index that doesn't rely on the MySQL stopwords and word length limits for improved search results.
• Switching to the Advanced search form doesn't require a page reload (It slides in with a JavaScript effect).
• Faster index building in the admin (about 5 seconds for every minute it currently takes).
• Improved algorithm with relevancy based on word distance.
• Improved support for 1-3 letter words.
• Improved support for dashed words and SKUs (for example XX-123 and XX123 will now match).
• Eliminated the 50% common word threshold.
• New search query that can be fully customized by the end user for easier integration X-Cart customizations and other modules.

There will also be two new add-ons for the Smart Search available separately (see thumbnail below):

1. A quick filter mechanism to limit quickly view search results by by price, category, or manufacturer.

2. A drop down auto complete / product suggestion tool that will suggest words, other popular queries, and matching products to the customer while they type in a search query.

Please see the screen shot below (may change for the final release).

smart_search.jpg

[Jerrad]

That's really looking great!
Is the 'Shop by' category/price/manufacturer (on the right side of the image) also a part of the new Smart Search?

And will this version also work with 4.0.x?

Thanks!

[inboxnews]

Originally Posted by wjbrewer

New Smart Search Available Jan/Feb '09.

Awesome. I want it now! How much?

[cycloneuk]

I keep getting the below error every now and then when people perform searches, any ideas?

[24-Nov-2008 17:39:28] (shop: 24-Nov-2008 17:39:2 SQL error:
Site : www.fragrancezone.co.uk
Remote IP : 92.3.152.216
Logged as :
SQL query : SELECT DISTINCT *, COUNT(*) AS score FROM xcart_products WHER) GROUP BY xcart_products.productid ORDER BY score DESC
Error code : 1064
Description : 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 xcart_products.productid ORDER BY score DESC' at line 1
Request URI: /_search.php?page=1&q=ck+in+2u
Backtrace:
/var/www/vhosts/fragrancezone.co.uk/httpdocs/include/func/func.db.php:180
/var/www/vhosts/fragrancezone.co.uk/httpdocs/include/func/func.db.php:106
/var/www/vhosts/fragrancezone.co.uk/httpdocs/include/func/func.db.php:322
/var/www/vhosts/fragrancezone.co.uk/httpdocs/modules/Smart_Search/smart_search_query.php:0
/var/www/vhosts/fragrancezone.co.uk/httpdocs/_search.php:165

[starwest]

Originally Posted by cycloneuk

I keep getting the below error every now and then when people perform searches, any ideas?

[24-Nov-2008 17:39:28] (shop: 24-Nov-2008 17:39:2 SQL error:
Site : www.fragrancezone.co.uk
Remote IP : 92.3.152.216
Logged as :
SQL query : SELECT DISTINCT *, COUNT(*) AS score FROM xcart_products WHER) GROUP BY xcart_products.productid ORDER BY score DESC
Error code : 1064
Description : 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 xcart_products.productid ORDER BY score DESC' at line 1
Request URI: /_search.php?page=1&q=ck+in+2u
Backtrace:
/var/www/vhosts/fragrancezone.co.uk/httpdocs/include/func/func.db.php:180
/var/www/vhosts/fragrancezone.co.uk/httpdocs/include/func/func.db.php:106
/var/www/vhosts/fragrancezone.co.uk/httpdocs/include/func/func.db.php:322
/var/www/vhosts/fragrancezone.co.uk/httpdocs/modules/Smart_Search/smart_search_query.php:0
/var/www/vhosts/fragrancezone.co.uk/httpdocs/_search.php:165

I have the exact same problem. If you notice, your query contains only 2-letter phrases. The error on my site also occurs for only 2-letter search phrases. I've emailed Bill multiple times with no response, but I assume that he's cleared it up for the next version because in his above post he mentions that the new version will contain:

"Improved support for 1-3 letter words."

I'd hope that for those of us who don't wish to upgrade he releases a fix, but we'll see. You may want to contact him through his website and see if you have better luck then I did.

[wjbrewer]

Originally Posted by cycloneuk

I keep getting the below error every now and then when people perform searches, any ideas?

This is caused by a query that contains all words that are less then the $_character_limit set in the smart_search_config.php file. I can send you an update.

Originally Posted by starwest

I'd hope that for those of us who don't wish to upgrade he releases a fix, but we'll see. You may want to contact him through his website and see if you have better luck then I did.

Perhaps you forgot we just went through this last month. You made a post about it: http://forum.x-cart.com/showthread.php?t=42624