an ASP.NET Open Source CMS & eCommerce platform
Search:
Skip Navigation LinksHome > DotShoppingCart Forums > Support > Installation > Error on search - Full Text Indexing is install...
Error on search - Full Text Indexing is installed and running
Last Post 1/30/2009 1:53:10 PM By Bahram. 13 replies.
Page 1 of 2 (14 posts) << First < Prev 1 2 Next > Last >> 
1/13/2009 5:22:59 PM
Brena
Posts: 8
Joined: 12/1/2008
Error on search - Full Text Indexing is installed and running
Hi Luke,
 
DSC is installed and working, installed using InstDSC.exe, no errors as far as I'm aware. SQL server express 2005, fulltext indexing is installed and running but am getting the following error when searching. Where's a good place to start looking? Thanks for your help. Brena.
 

The column prefix 'p' does not match with a table name or alias name used in the query.
Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'p' because it is not full-text indexed
1/13/2009 7:08:05 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Error on search - Full Text Indexing is installed and running
Could you please check if your database has full-text enabled? Also if full-text indexes are created on tables like dbo.DSC_Product?
DotShoppingCart Staff
1/13/2009 8:35:44 PM
Brena
Posts: 8
Joined: 12/1/2008
Re: Error on search - Full Text Indexing is installed and running
Thanks Luke,
 
In Databse properties the checkbox for "use full text indexing" is checked. I'm unsure how to check if a table has a full text index.
 
I checked in SQL server configuration manager and full text search is running and I can also see this is Services.
 
The DSC_Product table does not appear to have Full Text on columns in column properties - Full Text Specification - all set to no.
 
OK so which Tables/columns do I need to enable this on?
 
Thanks for your help!
1/13/2009 8:55:32 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Error on search - Full Text Indexing is installed and running
Did you use instDSC.exe when creating the database? If so, it should handle that you automatically.
DotShoppingCart Staff
1/13/2009 8:59:12 PM
Brena
Posts: 8
Joined: 12/1/2008
Re: Error on search - Full Text Indexing is installed and running
Sure did. Didn't see any errors, had success message at end.
 
Thanks.
1/13/2009 9:01:08 PM
Brena
Posts: 8
Joined: 12/1/2008
Re: Error on search - Full Text Indexing is installed and running
Would it be easier to try a full re-install again? We have configured a few things but mainly to learn about how to configure things <img src="http://www.dotshoppingcart.com/FCKEditor/editor/images/smiley/msn/regular_smile.gif" alt="" />
 
Thanks for your advice.
1/13/2009 9:10:25 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Error on search - Full Text Indexing is installed and running
Let's try do some debugging first. If you have SQL management studio installed, you can do that in the UI.
 
First check if it the database has the fulltext index enabled.
 
Second, check if the fulltext index was created to tables.
 
If everything is ok, then run the following sql script in the query window.
 
exec DSC_Product_Search @keywords = 'some keyword', @TotalProducts = 0
 
DotShoppingCart Staff
1/13/2009 10:00:02 PM
Brena
Posts: 8
Joined: 12/1/2008
Re: Error on search - Full Text Indexing is installed and running
Cool thanks!
 
Yes, checkbox is checked but I have no Full-Text index menu item in the right click menu. I think maybe there's a component missing? Using SQL management studio express 2005 version. If I right click on DSC_product table, click design then select the productName column, in it's properties it says No to Full text specification and cannot be set to yes.
 
As a comparison I checked on my local machine (had run InstDSC.exe on it) running full SQL Express 2008 and Management Studio Express 2008 it also has no Full-Text menu item but the column properties says YES to full text specification and that is is full text indexed. This can be set to NO also (not that I'm going to).
 
The query above runs fine on local machine, not on server.
 
I will look into SQL server install more (although it seems everything is there and server is preconfigured with SQL server advanced) - Then will try installing DSC again.
 
Thanks for your help.
 
 
1/14/2009 2:43:29 PM
Brena
Posts: 8
Joined: 12/1/2008
Re: Error on search - Full Text Indexing is installed and running
Hi Luke,
 
Just to be sure nothing was too borked I have completely started over - from a fresh reinstalled virtual server. When doing this I get SQL server 2005 express advanced with the image.
 
Before starting I checked in SQL server setup, Full text is installed and running.
 
I have run InstDSC, everything installed fine. Have yet to start Orderpipeline.
 
Jumped into SQL management express, opened DSC_Product table in design, selected productName column, it's properites for Full Text indexing still say No.
 
If I right click on the column there is an item Full text index, click it I get a dialog but cannot add a full text index. Message says...
 
"Creation of full text indexes is not available. Check you have correct permissions or that full text catalogues are defined"
 
Any tips what may have gone wrong?
 
Thanks for your help! Brena
 
 
1/14/2009 2:55:35 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Error on search - Full Text Indexing is installed and running
It mighe be the permission issue. Check the directory where you store the database files. Check if the identity running the SQL instance and full text service instance has the write permission to the database files and the full text catalogue. The full text catalogue is a directory named something like dsc.ActiveUpdate.
DotShoppingCart Staff
1/29/2009 3:41:15 PM
Bahram
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
Re: Error on search - Full Text Indexing is installed and running
 
Hi Brena,
 
Full Text Search (msftesql) has tagged incorrectly in the registry as dependent to a non-existiong service. So you should remove this line from registry and restart your server.
 
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\msftesql\DependOnService.
Delete the line with "NTLMSSP", restart OS, and msftesql starts up.
 
 
Bahram
Page 1 of 2 (14 posts) << First < Prev 1 2 Next > Last >> 
Project hosted at CodePlex.com
Copyright © 2013 DotShoppingCart. All rights reserved.