Rank: Member
Joined: 5/5/2015(UTC)
Posts: 9
|
I am trying to set up the Advanced Search in BV 2013. I went through the wizard in SQL Management Studio to define the full text search on the bvc_Product table. It then allowed me to select the "Enable Advanced Search" checkbox in the backend under Search Settings, but now all searches return zero results. I'm assuming I didn't configure something properly on the Full Text Search, but not sure what the problem is. I've looked through the documentation and forums but haven't found any detail on how to set this up. Is there any documentation somewhere for setting up the Advanced Search?
|
|
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,393 ![United States]( "United States") Location: Hummelstown, PA Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
|
Everything should have been setup when you installed (or upgraded) to BVC 2013. Meaning, the full text catalog, index population, etc. should have been automatically setup for you.What you could do is delete the full text catalog that you created and manually run the SQL script below: Code:SET NUMERIC_ROUNDABORT OFF
GO
SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
PRINT N'Checking if Full Text Search is installed'
IF SERVERPROPERTY('IsFullTextInstalled') = 0
BEGIN
PRINT N'Full Text Search is not installed! Please install this component and re-run this script.'
END
ELSE
BEGIN
IF CAST(SERVERPROPERTY('productversion') AS NVARCHAR) LIKE '9.%'
BEGIN
IF DATABASEPROPERTYEX(DB_NAME(), 'IsFulltextEnabled') = 0
BEGIN
PRINT N'Enabling full text search'
EXEC sp_fulltext_database 'enable'
END
END
IF OBJECTPROPERTY(OBJECT_ID('bvc_Product'), 'TableHasActiveFulltextIndex') = 0
BEGIN
PRINT N'Creating full text catalogs'
CREATE FULLTEXT CATALOG [ft_bvc_Product]
WITH ACCENT_SENSITIVITY = OFF
AS DEFAULT
AUTHORIZATION [dbo]
PRINT N'Adding full text indexing to tables'
CREATE FULLTEXT INDEX ON [dbo].[bvc_Product] KEY INDEX [PK_bvc_Product] ON [ft_bvc_Product] WITH CHANGE_TRACKING AUTO
CREATE FULLTEXT INDEX ON [dbo].[bvc_ProductType] KEY INDEX [PK_ProductType] ON [ft_bvc_Product] WITH CHANGE_TRACKING AUTO
PRINT N'Adding full text indexing to columns'
ALTER FULLTEXT INDEX ON [dbo].[bvc_Product] ADD ([SKU])
ALTER FULLTEXT INDEX ON [dbo].[bvc_Product] ADD ([ProductName])
ALTER FULLTEXT INDEX ON [dbo].[bvc_Product] ADD ([MetaKeywords])
ALTER FULLTEXT INDEX ON [dbo].[bvc_Product] ADD ([MetaDescription])
ALTER FULLTEXT INDEX ON [dbo].[bvc_Product] ADD ([MetaTitle])
ALTER FULLTEXT INDEX ON [dbo].[bvc_Product] ADD ([ShortDescription])
ALTER FULLTEXT INDEX ON [dbo].[bvc_Product] ADD ([LongDescription])
ALTER FULLTEXT INDEX ON [dbo].[bvc_Product] ADD ([Keywords])
ALTER FULLTEXT INDEX ON [dbo].[bvc_ProductType] ADD ([ProductTypeName])
ALTER FULLTEXT INDEX ON [dbo].[bvc_Product] ENABLE
ALTER FULLTEXT INDEX ON [dbo].[bvc_ProductType] ENABLE
END
END
GO |
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
|
|
Rank: Member
Joined: 5/5/2015(UTC)
Posts: 9
|
Thanks Aaron, that worked perfectly. I really appreciate the quick reply!
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.