Hi,

I am having real problems trying to get a coupon to work. It is a simple 10% off coupon.
 

In ProductList, I add to cart with the coupon code in the box above it. When I click View Cart, I get:
 

A critical error has occurred.
Could not find stored procedure 'I'.
 

When I add to cart without the coupon, there is no error. But with the error the entire shopping session is broken as you cannot view your cart, and the customer needs to close the browser and start a new session.
 

[UPDATE] - When you are NOT logged into your account, you can at least view the cart without the error.
 

What is stored procedure 'I'?
 

Also, is it possible to show the coupon box in the product details page? Now customers have to go back to the product list page to enter the coupon.
 

What would be best is to not have all those boxes on the product list, but a simple "Apply Coupon" box on the View Cart page that will apply the coupon.
 

Also, a special field to show the applied discount would be good in the cart summary. Now, you do not see what the discount is.
 

Thanks,
 

Steve

I am using 4.24.

I do not have a stored procedure with that name. The only extra procedure I call is one that does some extra stuff on the On Checkout Complete event. But that has a Smith prefix in it.

So, something in the View Cart code is calling some stored procedure. When this happens, all I get is the DNN error box, with the productlist beneath it.

Is there some stored procedure you all are calling when a customer is logged in compared to when a customer is not logged in? Maybe the stored procedure is corrupted or something.

Steve

I do not see anything with an unsafe SQL character.

I did confirm that this ONLY happens when a user is logged in. When they are not logged in, there is no error.

I am not sure where to look next. Maybe I will see if my login still works on the www7 site and try it there.

Hi Kevin,

I had tried the test site and I could not produce the error. But I have no idea what could be causing this because I have hardly made any mods to the order. Can you think of any step that create an extra call to a stored procedure when a user is logged in (when the error occurs), compared when they are not logged in?

We have not had to use a coupon yet so we are OK for now. Maybe you can look at the code and see what extra procedure is called for logged in users when they click view cart.

Thanks,

Steve