an ASP.NET Open Source CMS & eCommerce platform
Search:
Skip Navigation LinksHome > DotShoppingCart Forums > Support > DotShoppingCart Suite > Category List - Item Totals are incorrect.
Last Post 8/4/2008 1:22:47 PM By Linden. 17 replies.
Page 2 of 2 (18 posts) << First < Prev 1 2 Next > Last >> 
8/3/2008 2:53:39 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Category List - Item Totals are incorrect.

Please check if you are completely following Move OrderPipeline from Windows Service into Web Application.

DotShoppingCart Staff
8/3/2008 5:54:52 PM
Linden
Posts: 32
Joined: 3/19/2008
Re: Category List - Item Totals are incorrect.

Doh! I forgot to make the changes to global.asax when I upgraded from 2.0 to 2.11. Now that we have that out of the way I can show you the error I'm getting:

In RunnableProvider.cs an exception is thrown at line 47 for the EmailCampaignTaskProvider. The description is "Column 'templateName' does not belong to table Table."

8/3/2008 7:58:02 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Category List - Item Totals are incorrect.

Compare the sproc starting with DSC_EmailCampaign_* between the 2.0 and 2.11 if see if you have all the sproc updated. If that doesn't fix this, please post back entire the exception stack.

DotShoppingCart Staff
8/4/2008 6:17:08 AM
Linden
Posts: 32
Joined: 3/19/2008
Re: Category List - Item Totals are incorrect.

Yep. DSC_EmailCampaign_GetAllForSending and DSC_EmailCampaign_SendToMailingList were different. That resolved the error I described but revealed another. I won't bother you with the details of the error until I'm sure my entire database is up to date for version 2.11. Is there a change log or something that describes the differences between a 2.0 and a 2.11 database? I would rather my existing database than create a new one since we have store and customer data we would like to preserve.

8/4/2008 11:59:11 AM
Linden
Posts: 32
Joined: 3/19/2008
Re: Category List - Item Totals are incorrect.

I've checked my tables and sprocs and believe they are all up to date for 2.11. The error I get now when trying to start the orderpipeline is in runnableprovider.cs line 47 again. This time it says "The parameter 'address' cannot be an empty string." Here's the stack trace

   at System.Net.Mail.MailAddress..ctor(String address, String displayName, Encoding displayNameEncoding)
   at System.Net.Mail.MailAddress..ctor(String address)
   at DotShoppingCart.OpenSource.Core.EmailManager.SendEmail(String subject, String content, NameValueCollection tokensToReplace, String from, ICollection`1 to, ICollection`1 bcc) in C:\Users\Linden\Documents\Visual Studio 2008\Projects\Amy Sims Designs 2.11\Core\EmailManager.cs:line 42
   at DotShoppingCart.Commercial.OrderPipeline.EmailCampaignTaskProvider.RunTask(String host, IConfigurationSource cfgSrc)
   at DotShoppingCart.OpenSource.OrderPipeline.TaskProvider.Proccess(String host, IConfigurationSource cfgSrc) in C:\Users\Linden\Documents\Visual Studio 2008\Projects\Amy Sims Designs 2.11\OrderPipeline\OrderPipeline\TaskProvider.cs:line 50
   at DotShoppingCart.OpenSource.OrderPipeline.ProcessorProvider.Run() in C:\Users\Linden\Documents\Visual Studio 2008\Projects\Amy Sims Designs 2.11\OrderPipeline\OrderPipeline\ProcessorProvider.cs:line 37
   at DotShoppingCart.OpenSource.OrderPipeline.RunnableProvider.StartRun() in C:\Users\Linden\Documents\Visual Studio 2008\Projects\Amy Sims Designs 2.11\OrderPipeline\OrderPipeline\RunnableProvider.cs:line 47
   at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart()

Sorry to take up so much forum space with my problem.

8/4/2008 12:11:12 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Category List - Item Totals are incorrect.

The email address was empty. Run the sproc "DSC_EmailCampaign_GetAllForSending" manually and then figure out why some records have empty email address.

DotShoppingCart Staff
8/4/2008 1:22:47 PM
Linden
Posts: 32
Joined: 3/19/2008
Re: Category List - Item Totals are incorrect.

The sp executed normally and showed email addresses for all users. I did have an email campaign that didn't send because the orderpipelinecontroller wasn't set up to run. I deleted that campaign and now the orderpipelinecontroller seems to be starting alright. Thanks for your patience.

Page 2 of 2 (18 posts) << First < Prev 1 2 Next > Last >>