Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

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

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

Thanks!

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

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.

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

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 :)

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

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).

Attachment 1222

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

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!

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

Awesome. I want it now! How much?

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

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:28) 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

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

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.

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

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.



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

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

I stand corrected (and can't believe I forgot our exchange from only 2 months back) - sorry.

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

Will the new release be the same price? If I purchase now will I get a free upgrade or would you recommend waiting.

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

Hi Bill,

Is this update already available ?

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

I too am interested on the status of the new Smart Search engine.

Also, how flexible will the "simple filtering" be? Can I setup the mod to filter by different options instead of defaults of price, category, and manufacturer? (filtering by specific extra fields would be GREAT).

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

I dont think Bill would mind me saying he is beta testing and things are going well.

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

Hi

Altered Cart is under construction so I'll ask the forum members.

I have Smart Search installed. I just noticed when searching for a word with the letters "char" (such as "charles" or "character"), it displays a message "invalid search" on a white background and my entire store disappears.

Anyone have this problem with their Smart Search?

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

Hi Manic,

I just tested a search with "char" in my development cart and facing the exact same problem!

Nico

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

Have just tested this on mine and exact same problem.

Hopefully be a fix for this. I do want to improve our search.

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

I don't have that problem when searching for 'char'...
I get a search result with a product which (partially) contains the word 'char'.

A few months ago I asked Bill to make some changes to Smart Search, unfortunately I haven't got a idea what he did or changed...

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

This was added when the were a lot of attacks using CHAR keyword attempting to hack X-Cart. X-Cart versions 4.x and higher are not vulnerable to this attach.

To change this open _search.php and find this about line 100:


You can remove the entire block of code, or just the "exec" and "char" at the end.

This code is no longer in the Smart Search for version 2.0 and on.

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

How can we get the latest version of smart search?

Thanks.

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

If I upgrade Smart Search from 1.3.4 to 1.3.10 which files do I actually need to update? I only ask as some of my smart search files have been fixed by Bill over the last few years and I don't want those alterations to be affected and break my store. The main reason for upgrading is to enable boolean by default (which is in the new config file) as we seem to be getting some very sporadic results when searching by manufacturer and model number when boolean isn't used. Is manufacturer not a searchable field?

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

Anyone using Smart Search on 4.1.12? The _search.php file just displays a blank page. It was working fine on 4.1.11

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

I have Smart Search and it works great, but McAfee Secure says that hackers can inject SQL thru the search... Can somebody from alteredCart help me out and resolve this issue? McAfee has it as a "level 3" vulnerability and it won't show the McAfee Secure seal on my site because of it...

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

hi wjbrewer,

does the smart search now support advanced filter mod?

is there a place where i can test out the search for >1000 products, with before using and after using the smart search?

last thing, i tried the demo, using a keyword javascript (was looking for the javascript book) and it returned "invalid search".

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

Quick question, could't find the answer myself. Can I also use Smart Search to block users from searching in !PRODUCTCODE for example? I have an Excel database to fill our store with and the !PRODUCTCODE column is for internal use only, it contains codes that I don't want our customers to see/search in. Thanks in advance.

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

Could anyone who is using Smart Search V2 upwards please let me know their sites URL as on our site it crashes IE6 and I would like to know if anyone is experiencing something similar8O

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

Is this still currently an issue? Or was it resolved?

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

We are also getting sporadic reports of Smart Search crashing Internet Explorer; don't think it is limited to IE6; apparently doesn't occur with other browser platforms.

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

It seems to be an issue related to our site and does not affect other sites to my knowledge

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

For users of Smart Search v2.0 or greater.

There is a recently discovered conflict with IE8 preventing the advanced search from loading. To fix make the following change:

skin1/modules/Smart_Search/smart_search.tpl

Near the bottom of the file change this line:


to this:

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

Here is an easy modification to display the search terms in Management -> Statistics -> Search statistics sorted in the order from most to least searched. This can give you a better idea of the most used search phrases on your store.

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

Hi Bill-

I am interested in getting Smart Search, are all the mods listed in this thread in the current version or would I still have to do them?

Also, someone mentioned an injection vulnerability a few comments back, has that been addressed in the current version?

Thanks!

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

Unless the scanning script hacks your page (which it doesn't) it is impossible for a 'hacker' scan to detect this type of vulnerability. This was caused by an error being displayed, and was fixed when it was reported.

All bug fixes are always included in the current release version. Additionally, all future updates are free.

Bill

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

I just want to say thank you to BILL fast support and finally someone who stands behind their product and provides FREE future updates. Shows you are proud, that people are using your mods. :) very happy.

I have over 100,000 products on my store and this thing is crazy fast and accurate. LOVE IT. Probably one of the best mods I have installed yet. $150+ dollars well spent. Hey guys honestly - you will be amazed. :)

GREAT MOD....

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

I'll second the previous poster. AlteredCart has great support and service. I screwed up the install due to an error that was completely my fault (forgot to upload a file) and Bill got right in there and figured things out for me right away.

On top of the great service, Smart Search rocks. If you don't already have it, get it.

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

Agreed. When does the guy sleep?

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

We have the same problem,please resolve this problem ASAP,thank you!

Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.
 

A quick question for anyone using the Neon Lights 3 column template on 4.23 - is the Bestsellers module showing in your sidebar column on the Smart Search results page?

I've been hacking away at the template files preparing to launch on 4.23, so it may be that I have lost this somewhere along the line ... a consensus would be a help so I don't mither Bill unnecessarily ...