search error

General ShopSite user discussion

search error

Postby horsefriendly » Fri Jan 06, 2012 1:16 am

I am using ShopSite Pro version 10. I have not been able to get the search function to work properly. First it returned too many unrelated results. Then I recently added words to the stop list and it quit functioning all together with an error message as follows: Query failed: no such table: ss_s_SearchLog(1) . Any help would be appreciated.

Thank you,

Barbara Silverthorne
horsefriendly.com
horsefriendly
 
Posts: 3
Joined: Fri Jan 06, 2012 12:54 am

Re: search error

Postby ShopSite Lauren » Fri Jan 06, 2012 12:45 pm

Barbara, it doesn't look like you have the search field enabled for any of your ShopSite created pages. If ShopSite does not have any pages that are using the search feature, ShopSite simply turns off/ignores the search feature. Make sure at least one of your ShopSite pages is using the search feature (Pages > Edit Page Content, check the checkbox to show the product search field on that page).
- ShopSite Lauren
Contact me for help with any of your
custom ShopSite template questions.
ShopSite Lauren
 
Posts: 889
Joined: Fri Aug 11, 2006 1:35 pm
Location: Orem, UT

Re: search error

Postby horsefriendly » Fri Jan 06, 2012 7:04 pm

I have one hidden page with a search on it: https://www5.cruzio.com/shopsite/ss/preview.cgi?&ran1=971&ran2=443&page=62

It sort of worked at one time. It was returning too many items. Then I added words to the stop. Then the error started to appear. Then I removed the search from all but one page so as not to scare away customers. I did not change the settings that included pages in the search index.
horsefriendly
 
Posts: 3
Joined: Fri Jan 06, 2012 12:54 am

Re: search error

Postby horsefriendly » Fri Jan 06, 2012 8:20 pm

There is a similar error message on the following page: Preferences=>Search Setting=>Search Logging

Search Weekly Summary
Content-type: text/html
Error

Query failed: no such table: ss_s_SearchLog(1)

Day # of Searches Top Term with Results Top Term without Results
Jan 06 2012
horsefriendly
 
Posts: 3
Joined: Fri Jan 06, 2012 12:54 am


Return to User Forum

Who is online

Users browsing this forum: No registered users and 111 guests