Created discount coupon but status is empty

Hi,

i have created discount coupon but status shows empty, why has this happened? what can i do now?:no:

I TRULY hate to bump such an old post but the title is EXACTLY the issue my client has reported, and I cannot seem to find ANY other thread reporting a similar issue.. I am stumped because coupons have ALWAYS worked on his site..

Anyone got a HINT of what I might be looking for??

i don't really understand the issue - can you explain in greater detail and provide screenshots?

Honestly it's exactly as the title states.. I create a coupon, save it, and there is NO STATUS for the new coupon.. Not "Y" not "N".. The status is completely empty.. I'll look to get screen shots, but that is the heart of the issue..

Screenprints (click to see):

Coupon details

Coupons list.. Note there is NO status, and I have to use the "All Coupons" filter to see these coupons..

Anyone have ANY idea what the issue MIGHT be?? Right now I have to MANUALLY set the status of coupons for my client..

I just successfully created a coupon using the information you posted on my ZC1.5.3 test site (i.e. it showed 'Y' upon creation). What version of ZC is installed on your client's site? Any debug-log files?

lat9:

I just successfully created a coupon using the information you posted on my ZC1.5.3 test site (i.e. it showed 'Y' upon creation). What version of ZC is installed on your client's site? Any debug-log files?

The client is currently running v1.5.1. What's maddening is that there are NO debug log files.. At least then I'd have a HINT.. :laugh:

Have you compared the file admin/coupon_admin.php to a fresh download of 1.5.1?

Tried it on my v1.5.1 test site, same results (i.e. coupon shows 'Y' in the status column). Let's try a couple of questions:

• Upgrade or fresh install?
• PHP version?
• Database collation and display CHARSET?
• /YOUR_ADMIN/coupon_admin.php unmodified?

You might try installing my Report All Errors (http://www.zen-cart.com/downloads.php?do=file&id=1792) plugin, enabling it for admin and retrying the coupon process just to see if there are "lurking" errors causing your issue.

lat9:

Tried it on my v1.5.1 test site, same results (i.e. coupon shows 'Y' in the status column). Let's try a couple of questions:

• Upgrade or fresh install?
• PHP version?
• Database collation and display CHARSET?
• /YOUR_ADMIN/coupon_admin.php unmodified?

You might try installing my Report All Errors (http://www.zen-cart.com/downloads.php?do=file&id=1792) plugin, enabling it for admin and retrying the coupon process just to see if there are "lurking" errors causing your issue.

• Upgrade or fresh install? Neither.. This is an existing site.. We just did a cosmetic upgrade to the LOOK of the site, but nothing else..
• PHP version? - PHP Version: 5.4.22 (Zend: 2.4.0)
• Database collation and display CHARSET? - UTF-8 (converted tables and data 2 years ago)
• /YOUR_ADMIN/coupon_admin.php unmodified? - Can't post here (code too long) using the one from v1.5.3 -- it made NO DIFFERENCE

What's the schema for the "coupons" table in the database?

By default the "coupon_active" field has the following definition:```
coupon_active char(1) NOT NULL default 'Y',

I'm guessing yours has no "default" for some reason? Perhaps a result of doing some manual manipulation of that database table's structure? Or using 3rd party tools to manipulate coupons?

DrByte:

What's the schema for the "coupons" table in the database?

By default the "coupon_active" field has the following definition:```
coupon_active char(1) NOT NULL default 'Y',

THAT WAS IT!!!! Thank you!!! 

but now that I know it was kinda of an obvious answer huh?? :laugh: Anyway.. thanks.. this is a great case for why your sometimes need to get another set of eyes on an issue..:laugh:

> **DrByte:**
>
> I'm guessing yours has no "default" for some reason? Perhaps a result of doing some manual manipulation of that database table's structure? Or using 3rd party tools to manipulate coupons?

Nope.. Not a change I would have EVER made.. No.. this is the result of inheriting a site from another developer who preferred to modify the Zen Cart defaults (including the DB defaults apparently) to implement features for clients. (usually unnecessarily) I've been managing this site two years.. I had removed most of the most agregious of these hacks, and finally the client allowed me to give the site a makeover which effectively got rid of the rest of her "non-standard" hacks.. The client hadn't created any new coupons until now.. which is why I'm JUST NOW discovering this latest "gotcha".. :ohmy: