Howdy....

We've been seeing some issues with the email confirmation, so I went into the Cart Admin and our current list of "Templates" are blank. (We've been upgrading the cart software since v 3.04 - now on version v 4.52.) "Text" emails are going out, but field level data is not always correct for Billing and Shipping fields when the shipping is different than the billing.

So I tried to create a new Template, and when I click "save" for the generic template (e.g. User Email Tempalte), I get the following error:

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

Looks like this SP was added in on version 4.32, but didn't get into our installation. I tried installing the new v4.58 on our test server and that didn't fix the issue.

Short of manually adding each SP as I encounter errors, is there a way for me to verify that all the expected SPs are installed?

Hi Anthony,

You can rename the sproc to Smith_AddEmailTemplateSC. Then you will be able to add templates to the database and the emails will work.
You can also run thiis script in Host|SQL (paste code, check Run As Script, then execute)
-- remove bad sproc
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'{databaseOwner}{objectQualifier}Smith_Smith_AddEmailTemplateSC'))
drop procedure {databaseOwner}{objectQualifier}Smith_Smith_AddEmailTemplateSC
GO
-- remove renamed sproc
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'{databaseOwner}{objectQualifier}Smith_AddEmailTemplateSC'))
drop procedure {databaseOwner}{objectQualifier}Smith_AddEmailTemplateSC
GO
-- add proper sproc
CREATE PROCEDURE {databaseOwner}{objectQualifier}Smith_AddEmailTemplateSC
@TabModuleID int,
@Name nvarchar(50),
@Subject nvarchar(255),
@Template ntext,
@PortalID int
AS
INSERT INTO {objectQualifier}Smith_EmailTemplateSC (
[TabModuleID],
[Name],
[Subject],
[Template],
PortalID
) VALUES (
@TabModuleID,
@Name,
@Subject,
@Template,
@PortalID
)
select SCOPE_IDENTITY()
GO
Now you should be able to add email templates and the emails will not be blank.

Thanks,

Hi Anthony,

Could you please provide more details as to where the information differs and also how your Cart Settings have been configured.

Thanks,

FYI - New templates are finally activated. Client is very happy. Good change / enhancement.