Create Full text search ( error on index.)

Last post 11-20-2008 3:28 PM by dealkk. 12 replies.

Page 1 of 1 (13 items)
	Sort Posts: Previous Next

02-13-2008 10:59 PM

FabFourStore.com
Joined on 02-12-2008
Posts 45

Create Full text search ( error on index.)

Reply Contact

created the catalog fine , not the index.

CREATE FULLTEXT INDEX ON FABSHOP08.dbo.CSK_Store_Product

(

ShortDescription Language 0X0

)

KEY INDEX ProductID ON beatcatalog

WITH CHANGE_TRACKING AUTO

'ProductID' is not a valid index to enforce a full-text search key

http://www.fabfourstore.com

Filed under: Full text

02-14-2008 10:10 AM In reply to

Steve Walker
Joined on 02-11-2008
London
Posts 32

Re: Create Full text search ( error on index.)

Reply Contact

Hi,

If this helps. For the product table it should be:

[ProductId] [int] IDENTITY(1,1) NOT NULL,

And DC3 makes the FreeText changes like below:

EXEC sp_fulltext_database 'enable'
GO
CREATE FULLTEXT CATALOG dashCommerce_Catalog
GO

CREATE FULLTEXT INDEX ON [dbo].[dashCommerce_Store_Product] KEY INDEX [PK_dashCommerce_Products] ON [dashCommerce_Catalog] WITH CHANGE_TRACKING AUTO
GO

ALTER FULLTEXT INDEX ON [dbo].[dashCommerce_Store_Product] ADD ([Name] LANGUAGE 1033)
GO
ALTER FULLTEXT INDEX ON [dbo].[dashCommerce_Store_Product] ADD (ShortDescription LANGUAGE 1033)
GO
ALTER FULLTEXT INDEX ON [dbo].[dashCommerce_Store_Product] ADD (BaseSku LANGUAGE 1033)
GO

Regards,

Steve

02-15-2008 10:14 AM In reply to

FabFourStore.com
Joined on 02-12-2008
Posts 45

Re: Create Full text search ( error on index.)

Reply Contact

Steve you have such great answers, I am still one step back at the moment can't create a trusted user for sqlexpress.

Done this a few times before with NP. am I missing something.?

Database Server: JOHN\SQLEXPRESS

Database Name:FABSHOPDC

Database User Name:JOHN\fabshop

A critical error has occurred: Login failed for user 'JOHN\fabshop'. The user is not associated with a trusted SQL Server connection

http://www.fabfourstore.com

02-15-2008 10:32 AM In reply to

Steve Walker
Joined on 02-11-2008
London
Posts 32

Re: Create Full text search ( error on index.)

Reply Contact

Hi,

Depends on the server error message number as there are many reasons why you get that one. But they normally point to security issues.

I would follow this http://support.microsoft.com/kb/889615 as it applies to 2000 and 2005 as well. Same error for both :-)

Regards,

Steve

02-15-2008 10:56 AM In reply to

FabFourStore.com
Joined on 02-12-2008
Posts 45

Re: Create Full text search ( error on index.)

Reply Contact

A critical error has occurred: Login failed for user 'JOHN\fabshop'. The user is not associated with a trusted SQL Server connection

That's the error

I will checkout your link want to get 3.0 running this weekend..!!

Maybe then I can contribute too/ !!!

http://www.fabfourstore.com

02-15-2008 5:39 PM In reply to

FabFourStore.com
Joined on 02-12-2008
Posts 45

Re: Create Full text search ( error on index.)

Reply Contact

Thanks Steve.

Alright I created the DB...NOW This error.

Format of the initialization string does not conform to specification starting at index 0.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentException: Format of the initialization string does not conform to specification starting at index 0.

Source Error:

Line 96:       Validator.ValidateStringArgumentIsNotNullOrEmptyString(configurationSectionName, CONFIGURATION_SECTION_NAME);
Line 97: 
Line 98:       ConfigurationDatumCollection configurationDatumCollection = new ConfigurationDatumCollection().
Line 99:         Where(ConfigurationDatum.Columns.Name, configurationSectionName).
Line 100:        Load();

Source File: C:\Inetpub\wwwroot\Dash\Core\Controllers\ConfigurationDatumController.cs Line: 98

http://www.fabfourstore.com

02-16-2008 6:28 AM In reply to

newtito
Joined on 02-11-2008
Posts 26

Re: Create Full text search ( error on index.)

Reply Contact

same problem...

thanks...

03-11-2008 1:37 PM In reply to

mohsinsoft
Joined on 02-15-2008
Posts 2

Format of the initialization string does not conform to specification starting at index 0.

Reply Contact

I am getting this error too. Can anyone help me out from this ..

Server Error in '/' Application.

Format of the initialization string does not conform to specification starting at index 0.

Line 96:       Validator.ValidateStringArgumentIsNotNullOrEmptyString(configurationSectionName, CONFIGURATION_SECTION_NAME);
Line 97: 
Line 98:       ConfigurationDatumCollection configurationDatumCollection = new ConfigurationDatumCollection().
Line 99:         Where(ConfigurationDatum.Columns.Name, configurationSectionName).
Line 100:        Load();

Source File: F:\ms\dash_3_0_xp\dashCommerce 3.0 Beta\Core\Controllers\ConfigurationDatumController.cs Line: 98

Stack Trace:

[ArgumentException: Format of the initialization string does not conform to specification starting at index 0.]
   System.Data.Common.DbConnectionOptions.GetKeyValuePair(String connectionString, Int32 currentPosition, StringBuilder buffer, Boolean useOdbcRules, String& keyname, String& keyvalue) +1242
   System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey) +128
   System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules) +102
   System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) +52
   System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) +24
   System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions) +125
   System.Data.SqlClient.SqlConnection.ConnectionString_Set(String value) +56
   System.Data.SqlClient.SqlConnection.set_ConnectionString(String value) +4
   System.Data.SqlClient.SqlConnection..ctor(String connectionString) +21
   SubSonic.SqlDataProvider.CreateConnection(String newConnectionString) +24
   SubSonic.SqlDataProvider.CreateConnection() +22
   SubSonic.AutomaticConnectionScope..ctor(DataProvider provider) +56
   SubSonic.SqlDataProvider.GetReader(QueryCommand qry) +40
   SubSonic.AbstractList`2.Load() +404
   MettleSystems.dashCommerce.Core.ConfigurationDatumController.FetchConfigurationByName(String configurationSectionName) in F:\ms\dash_3_0_xp\dashCommerce 3.0 Beta\Core\Controllers\ConfigurationDatumController.cs:98
   MettleSystems.dashCommerce.Core.Configuration.DatabaseConfigurationProvider.FetchConfigurationByName(String configurationSectionName) in F:\ms\dash_3_0_xp\dashCommerce 3.0 Beta\Core\Configuration\DatabaseConfigurationProvider.cs:121
   MettleSystems.dashCommerce.Store.SiteSettings.Load() in F:\ms\dash_3_0_xp\dashCommerce 3.0 Beta\Store\SiteSettings.cs:125
   MettleSystems.dashCommerce.Store.Web.SiteMasterPage.get_SiteSettings() in F:\ms\dash_3_0_xp\dashCommerce 3.0 Beta\Store\Web\SiteMasterPage.cs:96
   MettleSystems.dashCommerce.Web.site.Page_Load(Object sender, EventArgs e) in F:\ms\dash_3_0_xp\dashCommerce 3.0 Beta\Web\site.master.cs:113
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +47
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

03-11-2008 2:12 PM In reply to

chriscyvas
Joined on 02-08-2008
Posts 72

Re: Format of the initialization string does not conform to specification starting at index 0.

Reply Contact

I think this comes from not configuring your connection string.

--
Support dashCommerce - Buy Our Stuff!!

Find a bug? Create a Work Item for a fast response.. Want to help? Create a patch for us!

Filed under: 3.0

03-11-2008 3:29 PM In reply to

sloynes
Joined on 03-09-2008
Posts 2

Re: Format of the initialization string does not conform to specification starting at index 0.

Reply Contact

I'm getting the same error even with the connectionString being set.

03-11-2008 7:02 PM In reply to

myozaw
Joined on 03-04-2008
Posts 3

Re: Create Full text search ( error on index.)

Reply Contact

I think you haven't install DB scripts yet. After you create DB, you need to run '../install/install.aspx' for the first time. This will install required DB stuffs. And, after that you will need to change the connection string information inside 'connection.config' file.

Hope this work,

Myo Zaw.

03-12-2008 4:05 AM In reply to

mohsinsoft
Joined on 02-15-2008
Posts 2

Re: Create Full text search ( error on index.)

Reply Contact

Thank you. I forgot to create db.

Now i can see the admin panel.

Thanks

Mohsin

11-20-2008 3:28 PM In reply to

dealkk
Joined on 07-24-2008
Posts 18

Re: Create Full text search ( error on index.)

Reply Contact

I am new to full text search

if i want to include product type to be searchable, what do i need to do

product table

productid, typeid

product table

typeid, typename

Page 1 of 1 (13 items)