|
|
 |
 |
Joined: 12/15/2010
Posts: 147
|
|
|
On one of my sites that I was not getting emails for I was instructed to setup the email templates, However When I try to add one. Upon clicking the Submit button I get sent back to the main cart page adn am presented with this error at the bottom of the page:
 |
A critical error has occurred.
The stored procedure 'dbo.DNN_Smith_AddEmailTemplateSC' doesn't exist. |
Any thoughts?
|
|
|
|
 | |
|
|
|
|
Joined: 12/15/2010
Posts: 147
|
|
|
I have tried to reinstall the latest cart software… that did not fix this. The Event viewer lists this error message as well:
7/13/2011 4:42:06 PM Page Load Exception superadmin$cb AssemblyVersion: 5.6.3; PortalID: 0; PortalName< ...
|
AssemblyVersion: 5.6.3
PortalID: 0
PortalName: Ty Cobb - Museum
UserID: 1
ActiveTabID: 75
ActiveTabName: Gift Store
RawURL: /GiftStore/tabid/75/ctl/EmailTemplate/mid/403/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://tycobbmuseum.org/GiftStore/tabid/75/ctl/EmailTemplate/mid/403/Default.aspx
UserAgent: Mozilla/5.0 (Windows NT 6.1; rv:5.0) Gecko/20100101 Firefox/5.0
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 22a7fca4-fbb9-47b2-96ed-bc8a8b379924
InnerException: The stored procedure 'dbo.DNN_Smith_AddEmailTemplateSC' doesn't exist.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlCommand.DeriveParameters
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: The stored procedure 'dbo.DNN_Smith_AddEmailTemplateSC' doesn't exist. ---> System.InvalidOperationException: The stored procedure 'dbo.DNN_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 ---
Source:
Server Name: WEBSERV01
|
Please let me know how to fix this so this client can get their emails… is seems that the stored procedure just needs to be put in place (how can I do this?)
Why would this be missing from when upgrading? This issue also occurs on another site of ours – This is similar as this happened after the 4.42 upgrade.
Let me know. Thanks.
|
|
|
|
| |
|
|
 |
 |
Joined: 8/7/2010
Posts: 15
|
|
|
Use SQL Management Studio and create the stored proc:
CREATE PROCEDURE [Smith_AddEmailTemplateSC]
@TabModuleID int,
@Name nvarchar(50),
@Subject nvarchar(255),
@Template ntext,
@PortalID int
AS
INSERT INTO Smith_EmailTemplateSC (
[TabModuleID],
[Name],
[Subject],
[Template],
PortalID
) VALUES (
@TabModuleID,
@Name,
@Subject,
@Template,
@PortalID
)
select SCOPE_IDENTITY()
|
|
|
|
| |
|
|
|
|
Joined: 12/15/2010
Posts: 147
|
|
|
thank you for this info. I will keep this handy - I reinstalled the store from scratch and fixed this that way, but for future reference I will keep this, Thank you.
|
|
|
|
| |
|
|
|
 |
Joined: 1/28/2011
Posts: 19
|
|
|
I had a similar problem. I also installed the SmithCart module from scratch. I did delete the existing SQLServer tables and stored procs prior to the install. This seemed to fix the problem. But, I am having problems with the 5 star rating system. It appears that the stars are not enabled, i.e. clicking on them produces no results.
|
|
|
|
| |
|
|
|
Joined: 1/1/0001
Posts: 0
|
|
|
Hi Mike,
Do you have Show Customer Reviews enabled? A new tab titled “Review” will be displayed on the product details page. This feature will allow customers to rate products and write reviews about products.
Thanks
|
|
|
|
| |
|
|
|
|
Joined: 1/28/2011
Posts: 19
|
|
|
Hi Kevin - Yes, I do have the reviews enabled. I'm able to write and manage the review, but I'm unable process the click event on the stars. Again, this may be associated with not clearing the desktopmodules with the last install. I'll do the clean install and follow up.
Mike
|
|
|
|
| |
|
|
|
Joined: 1/1/0001
Posts: 0
|
|
|
Hi Mike,
This has been addressed in the latest version of the Cart v.4.46.
Thanks,
|
|
|
|
| |
|
|
|
Joined: 5/20/2011
Posts: 29
|
|
|
Pardon my ignorance...but I am not a developer. So where do I go in the SQL server manager to add this procedure? Any help would be most appreciated!
|
|
|
|
| |
|
|
 |
 |
Joined: 3/11/2010
Posts: 1979
|
|
|
Hi Michelle,
SQL Mgmt Studio is the client program for the SQL Server Database. Do you have it loaded on your system or do you have any IT people at your company?
Scott Kelly
Project Manager
|
|
|
|
| |
|
|
|
Joined: 5/20/2011
Posts: 29
|
|
|
I have direct access to my server and yes I do have the SQL server Mgmt studio...I am just not sure what to do at that point.
|
|
|
|
| |
|
|
|
Joined: 7/28/2009
Posts: 1452
|
|
|
After you load SQL Mgmt Studio do the following:
1. Click on your database in the object explorer
2. Click the plus sign to expand the database
3, Click on the "New Query Button" on the toolbar
4. Cut and paste the stored proc above into the new query window
5. Click the "execute" button on the toolbar to run/save the stored proc
At your service,
Dave Smith
|
|
|
|
| |
|
|
|
Joined: 5/20/2011
Posts: 29
|
|
|
THANKS!!! The emails are working great!!! Again...Thank you for you help!
|
|
|
|