Hello Zenners,
I'm getting a very similar error to http://www.zen-cart.com/forum/showthread.php?t=40052 when trying to enter a 25% discount value for a discount coupon I'm trying to create:
1366 Incorrect decimal value: '25.0000%' for column 'coupon_amount' at row 1
I looked-up the coupon_amount row in the coupons table in MySQL and it is defined as a decimal (8,4). I am able to specify a discount amount in Dollars (such as $25), but NOT a percentage (such as 25%)... that's when I get the error.
I tried 25.00%, tried 25.0000%, tried 25%, always get the error.
Any idea anyone? Dr.Byte??
Thanks
Results 1 to 2 of 2
-
5 Oct 2006, 06:48 PM #1
New Zenner
- Join Date
- Sep 2006
- Posts
- 22
- Plugin Contributions
- 0
Similar error trying to specity a % for a discount coupon
-
Re: Error trying to specify a % for a discount coupon
What version of Zen Cart are you using?
What addons/contributions do you have installed?
What languages are active on your site?
What currencies do you have configured?.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
Similar Threads
-
discount coupon admin error
By headache! in forum Bug ReportsReplies: 3Last Post: 13 Jul 2011, 04:10 PM -
discount coupon tax error
By Soniccc in forum General QuestionsReplies: 0Last Post: 21 Oct 2010, 01:52 PM -
I get this error on my discount coupon at checkout:'This coupon is not available yet'
By WHHammond in forum Discounts/Coupons, Gift Certificates, Newsletters, AdsReplies: 13Last Post: 15 Sep 2010, 03:09 PM -
Ideas/Suggestions for Discount Coupon - How to give a credit and a discount
By vegascoug in forum Discounts/Coupons, Gift Certificates, Newsletters, AdsReplies: 0Last Post: 15 Nov 2007, 05:40 PM -
Discount coupon Error
By lucky__starre in forum General QuestionsReplies: 3Last Post: 17 Apr 2007, 02:04 AM
Bookmarks