Hi

 

i Know its possible to filter or narrow by brand when you click on a category but i would like to seach by brand without it being related to a category. I was thinking of having a dropdown with the brand names and searching using this control. Is this possible?

 

Thanks

 

 

Sure. Nothing is impossible.

 

Here is what you need to do.

1) Update [dbo].[DSC_Category_GetChildren] to return all categories when @CategoryId is 0

Thanks Lukezy

 

Before I start playing with the solution you mentioned I have 2 issues. The narrow by brand(manufacturer) section does not seem to be working.

 

I have added new manufacturers and I have added the manufacturer to a new product. I have also ticked the display useful links but the brand does not show in my categorylist.

 

I checked the DSC_Category_Manufacturer_Count table and the count field is always 0. Here is the data from my table.

 

Also the count values are always zero even though I have products entred for these categories and whni click on the category, products are listed. Am i missing some configuration setting?

 

Thanks

 

<table> <tbody> <tr> <td>1</td> <td>1</td> <td>0</td> </tr> <tr> <td>1</td> <td>2</td> <td>0</td> </tr> <tr> <td>2</td> <td>1</td> <td>0</td> </tr> <tr> <td>2</td> <td>2</td> <td>0</td> </tr> <tr> <td>3</td> <td>1</td> <td>0</td> </tr> <tr> <td>3</td> <td>2</td> <td>0</td> </tr> <tr> <td>5</td> <td>1</td> <td>0</td> </tr> <tr> <td>5</td> <td>2</td> <td>0</td> </tr> <tr> <td>6</td> <td>1</td> <td>0</td> </tr> <tr> <td>6</td> <td>2</td> <td>0</td> </tr> <tr> <td>NULL</td> <td>NULL</td> <td>NULL</td> </tr> </tbody> </table> count value for the categories

It means that you orderpipeline is not working. Check this thread.

 

You can manually run the following SQL script to fix this temporary.

EXEC DSC_Category_Populate_Manufacture_Count 0, 0

EXEC DSC_Category_Populate_PriceRange_Count 0, 0

I will reinstall the order pipe line. Will this fix the problem?

Hi Lukezy

 

I reinstalled the order pipeline and it said there were no problems(the order pipelineservuce was started sucessfully) . But the narrow by brand and category count were still not working.

The narrow by price was always working.

 

I ran the stored procedures you recommened in the other thread and it worked.

 

You also metioned using the global.asax fiel to check to see if it works. Can you explain further please as I am not sure how to do this.

 

Thanks

First check DotShoppingCart source in your EventLog to see if you had any exception logged. That's quickest way to pin point the issue.

 

If not, you can set a break point in the yellow background line below and step into it.

 

In Global.asax

 

void Application_Start(object sender, EventArgs e) {
    OrderPipelineController.Start();
}

Hi Lukezy

 

Thank you for your assistance.

 

I have completed the following task as mentioned in this post. I was using it as a windows service before this.

 

http://www.dotshoppingcart.com/View/Article/Documentation/Online%20Help/Installation/101.aspx

 

I have set up the break points as mentioned and stepped into it but I am not sure what i should be looking for as no errors appeared and it stepped into the start functions and then i continued with F11 and project loaded. I assume this is correct.

 

The Orderpipeline still is still not working and there are no errors in my event viewer. I noticed when the server was restarted the Dotshoppingcart.Commercial.Orderpipelineservice.exe was runinng in my processes and errors in the event viewer for the orderpipeline were present 

 

If i have set this up as a web service and not a windows will i need to unistalll the service?

 

 

Here is the errro i am getting on start up.

 

Event Type: Error
Event Source: DotShoppingCart
Event Category: None
Event ID: 100
Date:  22/10/2008
Time:  11:18:40
User:  N/A
Computer: SPARE
Description:
Timestamp: 22/10/2008 10:18:40
Message: HandlingInstanceID: 086aaffd-7ad6-49c3-a9f8-2350d21d6d3b
An exception of type 'System.ArgumentException' occurred and was caught.
------------------------------------------------------------------------
10/22/2008 11:18:40
Type : System.ArgumentException, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message : Item has already been added. Key in dictionary: 'host'  Key being added: 'host'
Source : mscorlib
Help link :
ParamName :
Data : System.Collections.ListDictionaryInternal
TargetSite : Void Add(System.Object, System.Object)
Stack Trace :    at System.Collections.ListDictionaryInternal.Add(Object key, Object value)
   at DotShoppingCart.Commercial.OrderPipeline.TaskProvider.Proccess(String host, IConfigurationSource cfgSrc)
   at DotShoppingCart.Commercial.OrderPipeline.ProcessorProvider.Run()
   at DotShoppingCart.Commercial.OrderPipeline.RunnableProvider.StartRun()

Additional Info:

MachineName : SPARE
TimeStamp : 22/10/2008 10:18:40
FullName : Microsoft.Practices.EnterpriseLibrary.ExceptionHandling, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null
AppDomainName : DotShoppingCart.Commercial.OrderPipelineService.exe
ThreadIdentity :
WindowsIdentity : NT AUTHORITY\SYSTEM

Category: General
Priority: 0
EventId: 100
Severity: Error
Title:Enterprise Library Exception Handling
Machine: SPARE
Application Domain: DotShoppingCart.Commercial.OrderPipelineService.exe
Process Id: 2016
Process Name: C:\BT2\DotShoppingCartSuiteV2.53\Install\OrderPipeline\DotShoppingCart.Commercial.OrderPipelineService.exe
Win32 Thread Id: 624
Thread Name:
Extended Properties:

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
 

 

 

Ah, you don't need to follow the post. Windows service is the preferred way. You might want to back out the changes that you made. After you have done that, try restarting OrderPipelineService and check if you have the same error.  

My problem is that the client is using shared hosting so i wont have the option to use the windows service.

Is there a fix for these errors using the web service?

 

Yes, using web application is supported. You could stop and uninstall the windows service since you don't it any more. Clear the DotShoppingCart eventlog entries.

 

After that, try restarting app pool in IIS or VS web develop server. And then check if it's work properly.