Hi Giles,

Need your help on this one. If you set up a coupon as Single Use, then when the user enters it during checkout you usually get the following error:

"A critical error has occurred. An unexpected error has occurred."

We went through a number of different permutations in testing the coupons and on one occassion got this error message:

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

This is important to our customer who wants to send out some special one time use discounts to specific clients in the media. One thing that wasn't clear is if the one time use is per customer or if it can only be used once regardless of who uses it. We had hoped to figure this out during testing.

Giles, the customer really likes the product as its a great fit for their specific product line.

Cheers,
Larry

The problem is inside 03.01.04.SqlDataProvider there are missing one "GO" after

CREATE PROCEDURE {databaseOwner}[{objectQualifier}Store_Orders_UpdateOrderDetails]

so this automatically apply

IF EXISTS (SELECT * FROM {databaseOwner}[sysobjects] WHERE id = object_id(N'{databaseOwner}[{objectQualifier}Store_Orders_CountCouponUsage]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)

DROP PROCEDURE {databaseOwner}[{objectQualifier}Store_Orders_CountCouponUsage]

GO

and drop the procedure.

Solution:

Go to procedure "Store_Orders_UpdateOrderDetails" in your database and delete  from the bottom of it

IF EXISTS (SELECT * FROM {databaseOwner}[sysobjects] WHERE id = object_id(N'{databaseOwner}[{objectQualifier}Store_Orders_CountCouponUsage]') and OBJECTPROPERTY(id, N'IsProcedure') = 1

DROP PROCEDURE {databaseOwner}[{objectQualifier}Store_Orders_CountCouponUsage]

after that re-create the "Store_Orders_CountCouponUsage" procedure like below:

CREATE PROCEDURE [dbo].[dnn_Store_Orders_CountCouponUsage]

@PortalID int,

@UserID int,

@CouponID int,

@OrderID int

AS

SET NOCOUNT ON

SELECT COUNT(*) FROM dbo.dnn_Store_Orders o

WHERE o.PortalID = @PortalID AND o.UserID = @UserID AND o.CouponID = @CouponID AND o.OrderID <> @OrderID AND o.OrderIsPlaced = 1