ProductCart Shopping Cart Software Forums : 4 Different Coupon Codes not letting customers https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 03:47:59 +0000 Wed, 08 Feb 2012 14:56:32 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=4975 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[4 Different Coupon Codes not letting customers : Yeah, that was my hunch -- that...]]> https://forum.productcart.com/4-different-coupon-codes-not-letting-customers_topic4975_post19050.html#19050 Author: Guests
Subject: 4975
Posted: 08-February-2012 at 2:56pm

Yeah, that was my hunch -- that the issue is not the number of discounts, but the length of the data. I'm sure you're on the right track there.]]> Wed, 08 Feb 2012 14:56:32 +0000 https://forum.productcart.com/4-different-coupon-codes-not-letting-customers_topic4975_post19050.html#19050 <![CDATA[4 Different Coupon Codes not letting customers : I think we might of figured it...]]> https://forum.productcart.com/4-different-coupon-codes-not-letting-customers_topic4975_post19049.html#19049 Author: njessen42
Subject: 4975
Posted: 08-February-2012 at 2:50pm

I think we might of figured it out. The dbo.orders.discountDetails field is only nvarchar(200). It looks like it takes the name, code and price for each code and summarizes it here for the order. I think our name and code is just to long. We are testing it out now. ]]> Wed, 08 Feb 2012 14:50:05 +0000 https://forum.productcart.com/4-different-coupon-codes-not-letting-customers_topic4975_post19049.html#19049 <![CDATA[4 Different Coupon Codes not letting customers : Thanks will try that. We are...]]> https://forum.productcart.com/4-different-coupon-codes-not-letting-customers_topic4975_post19048.html#19048 Author: njessen42
Subject: 4975
Posted: 08-February-2012 at 2:07pm

Thanks will try that. We are getting the same error in our test shopping cart but I did come across a ton of these errors in the help log. This is what happens when we submit an order with more than 4 discounts that automatically apply and can be used with other discounts.

Customer Reference Number: 360380226-93239
Date/Time: 2/8/2012
Session ID: 360380226
Error Number: -2147217833
Source: Microsoft OLE DB Provider for SQL Server
Description: String or binary data would be truncated.

query=SELECT idOrder FROM Orders WHERE pcOrd_OrderKey like 'DEU2958990352';

Request Method: POST
Server Port: 443
HTTPS: on
Local Address: 192.168.1.101
Host Address: 66.162.137.198
User Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:10.0) Gecko/20100101 Firefox/10.0
URL: /cart/pc/SaveOrd.asp
HTTP Headers: southshore.rings-things.com, en-us,en;q=0.5


Each one had this exact same description with a different "like =" ####


Edited by njessen42 - 08-February-2012 at 2:13pm]]> Wed, 08 Feb 2012 14:07:22 +0000 https://forum.productcart.com/4-different-coupon-codes-not-letting-customers_topic4975_post19048.html#19048 <![CDATA[4 Different Coupon Codes not letting customers : Hi Nate,This is curious.Those...]]> https://forum.productcart.com/4-different-coupon-codes-not-letting-customers_topic4975_post19047.html#19047 Author: Guests
Subject: 4975
Posted: 08-February-2012 at 1:53pm

Hi Nate,

This is curious. 

Those error logs are almost never helpful anyways. 

Try this:

Open /includes/opendb.asp

At the top, put an apostrophe before the first line so that it reads like this:
'on error resume next

Save that and try it again. Depending on how the server is configured, we should hopefully get a more meaningful description of the error. If so, please provide that.

And don't forget to reverse the change above so the site will handle errors again.


Edited by Sean@WMS - 08-February-2012 at 1:53pm]]> Wed, 08 Feb 2012 13:53:13 +0000 https://forum.productcart.com/4-different-coupon-codes-not-letting-customers_topic4975_post19047.html#19047 <![CDATA[4 Different Coupon Codes not letting customers : Sean thanks for testing this out....]]> https://forum.productcart.com/4-different-coupon-codes-not-letting-customers_topic4975_post19046.html#19046 Author: njessen42
Subject: 4975
Posted: 08-February-2012 at 12:18pm

Sean thanks for testing this out. We did have pretty long coupon codes, so I shortened them to 5 characters each and it still didn't work. Gave me the error below. It works fine with only 3 different discount codes but 4 seems to be the magical number to error. It doesn't log the error in the Product Cart admin panel either. I even tried two different shipping methods and payment methods. 

Technical Information:

The error has been logged in the store database. The reference ID for this error is: 238528419-91316. To report the problem to our technical support team, please write this # down or copy and paste it.

]]> Wed, 08 Feb 2012 12:18:52 +0000 https://forum.productcart.com/4-different-coupon-codes-not-letting-customers_topic4975_post19046.html#19046 <![CDATA[4 Different Coupon Codes not letting customers : Hi Nate,I just tested this on...]]> https://forum.productcart.com/4-different-coupon-codes-not-letting-customers_topic4975_post19040.html#19040 Author: Guests
Subject: 4975
Posted: 07-February-2012 at 6:35pm

Hi Nate,

I just tested this on one of our sandbox PC 4.1 SP 2 locations, and had 4 various kinds of auto applied, can be used with others discounts, and it worked fine (used offline credit card payment method).

It might not be the number of them, but possibly the length of them all strung together? Are the discount codes long?
]]> Tue, 07 Feb 2012 18:35:00 +0000 https://forum.productcart.com/4-different-coupon-codes-not-letting-customers_topic4975_post19040.html#19040 <![CDATA[4 Different Coupon Codes not letting customers : We use many different coupon codes...]]> https://forum.productcart.com/4-different-coupon-codes-not-letting-customers_topic4975_post19034.html#19034 Author: njessen42
Subject: 4975
Posted: 06-February-2012 at 2:04pm

We use many different coupon codes for different sales we have going on.  Recently we have found out that using more than 3 codes will not let customers submit their order.  We always have the codes flagged to automatically apply and for use with more than one code. Is this a known issue? Also none of our items are included in more than one code, so no duplication.


Nate Jessen
http://www.rings-things.com
ProductCart v4.1 SP 2
]]> Mon, 06 Feb 2012 14:04:36 +0000 https://forum.productcart.com/4-different-coupon-codes-not-letting-customers_topic4975_post19034.html#19034