HomeHome Product Discus... Product Discus...SmithCartSmithCartError on updating email templatesError on updating email templates
Previous
 
Next
New Post
8/17/2011 8:11 PM
 

Hi, I am following the instructions in the manual for updating the email templates. When I click the submit button to save the template (any of the three) I get the following

A critical error has occurred.
The stored procedure 'dbo.Smith_AddEmailTemplateSC' doesn't exist.

 

I am running cart 4.43 and DNN 5.6.2

 

thanks very much Joanne

 
New Post
8/17/2011 8:55 PM
 
Hi Joanne,

Are there and errors in the Event Log?

Thanks,
 
New Post
8/17/2011 9:00 PM
 

HI Kevin, this is from the event log.

 

thanks Joanne

 

Message: DotNetNuke.Services.Exceptions.PageLoadException: The stored procedure 'dbo.Smith_AddEmailTemplateSC' doesn't exist. ---> System.InvalidOperationException: The stored procedure 'dbo.Smith_AddEmailTemplateSC' doesn't exist. at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at Smith.DNN.Modules.BuyNow.SqlDataProvider.AddEmailTemplate(Int32 tabModuleID, String name, String subject, String template, Int32 portalID) at Smith.DNN.Modules.BuyNow.EmailTemplateController.AddEmailTemplate(EmailTemplateInfo objEmailTemplate) at Smith.DNN.Modules.BuyNow.EmailTemplate.btnSubmit_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---

 
New Post
8/17/2011 9:22 PM
 
Here is a link to a forum post with the missing stored proc you need:

http://www.smith-consulting.com/Forums/forumid/1/threadid/7981/scope/posts.aspx


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
8/17/2011 10:21 PM
 

thanks for that worked a treat

 
New Post
8/18/2011 4:52 PM
 
Glad we could help!
 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartError on updating email templatesError on updating email templates