We upgraded to 7.0.3 on our development server and enabled full text search. We are now getting errors in both simple and advanced search. Entering only 1 keyword works fine. Entering 2 or more words returns a SQL error. If we insert "AND" or "OR" between keywords, that works too.
Has anybody else had problems with 7.0.3 and full text search? We can't go live with it the way that it is now.
Thanks
Full Text Search in 7.0.3 using multiple words - AND problem
-
Logan Rhodehamel
- Developer
- Posts: 4116
- Joined: Wed Dec 10, 2003 5:26 pm
Re: Full Text Search in 7.0.3 using multiple words - AND problem
Yes, the problem with FTS was reported to us prior. We have resolved the issue. Please go here:
http://bugs.ablecommerce.com/show_bug.cgi?id=8128
You can obtain the update. So far the problem with FTS is the only known issue in 7.0.3 release.
http://bugs.ablecommerce.com/show_bug.cgi?id=8128
You can obtain the update. So far the problem with FTS is the only known issue in 7.0.3 release.
Cheers,
Logan
.com
If I do not respond to an unsolicited private message, it's not because I'm ignoring you. It's because the answer to your question is valuable to others. Try the new topic button.
Logan
.comIf I do not respond to an unsolicited private message, it's not because I'm ignoring you. It's because the answer to your question is valuable to others. Try the new topic button.
-
Logan Rhodehamel
- Developer
- Posts: 4116
- Joined: Wed Dec 10, 2003 5:26 pm
Re: Full Text Search in 7.0.3 using multiple words - AND problem
Note... full text search is currently implemented as a phrase search, consistent with how it behaved prior to the implementation of the FTS feature. We are researching ways to allow merchants to better leverage the features of FTS from the store search.
Cheers,
Logan
.com
If I do not respond to an unsolicited private message, it's not because I'm ignoring you. It's because the answer to your question is valuable to others. Try the new topic button.
Logan
.comIf I do not respond to an unsolicited private message, it's not because I'm ignoring you. It's because the answer to your question is valuable to others. Try the new topic button.
Re: Full Text Search in 7.0.3 using multiple words - AND problem
Any idea when there will be more options than "phrase search" for 7.0.3. commercebuilder.dll full text search functions?
I modified the 7.0.3. advanced search page to work with the original "broken" commercebuilder.dll and replace spaces with AND before submitting the text.
This greatly improves our search results.
But, the subsequent patched .dlls don't work with the modification or by substituting AND using the unmodified search pages. In the original .dll using a logical AND or OR worked.
Is the Full Text Search still being worked on as a problem or a future enhancement?
We don't want to implement our modification now if we will have to take it out later to fix a problem with commercebuilder.dll. So far, none of the patch fixes would affect us.
Would a separate .dll for full text search functions be possible?
I modified the 7.0.3. advanced search page to work with the original "broken" commercebuilder.dll and replace spaces with AND before submitting the text.
This greatly improves our search results.
But, the subsequent patched .dlls don't work with the modification or by substituting AND using the unmodified search pages. In the original .dll using a logical AND or OR worked.
Is the Full Text Search still being worked on as a problem or a future enhancement?
We don't want to implement our modification now if we will have to take it out later to fix a problem with commercebuilder.dll. So far, none of the patch fixes would affect us.
Would a separate .dll for full text search functions be possible?