Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13
  1. #11
    Join Date
    Jan 2007
    Location
    Los Angeles, California, United States
    Posts
    10,023
    Plugin Contributions
    32

    Default Re: Created discount coupon but status is empty

    Quote Originally Posted by lat9 View Post
    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
    My Site - Zen Cart & WordPress integration specialist
    I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

  2. #12
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Created discount coupon but status is empty

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

    By default the "coupon_active" field has the following definition:
    Code:
      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?
    .

    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.

  3. #13
    Join Date
    Jan 2007
    Location
    Los Angeles, California, United States
    Posts
    10,023
    Plugin Contributions
    32

    Default Re: Created discount coupon but status is empty

    Quote Originally Posted by DrByte View Post
    What's the schema for the "coupons" table in the database?

    By default the "coupon_active" field has the following definition:
    Code:
      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?? Anyway.. thanks.. this is a great case for why your sometimes need to get another set of eyes on an issue..

    Quote Originally Posted by DrByte View Post
    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"..
    Last edited by DivaVocals; 17 Dec 2014 at 10:58 PM.
    My Site - Zen Cart & WordPress integration specialist
    I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

 

 
Page 2 of 2 FirstFirst 12

Similar Threads

  1. v151 Google says include VAT but Discount coupon comes out wrong
    By dharrison in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 1
    Last Post: 15 Sep 2015, 09:02 AM
  2. v138a Discount coupon applied but not stored in orders_total table
    By rajoo.sharma in forum General Questions
    Replies: 0
    Last Post: 26 Sep 2013, 07:08 AM
  3. v138a what is "Admin Discount Coupon Mail Status"
    By erniejones in forum General Questions
    Replies: 4
    Last Post: 25 May 2012, 02:14 AM
  4. Replies: 4
    Last Post: 12 Apr 2011, 06:32 PM
  5. How do I set a discount coupon for products but NOT shipping?
    By jonnyapples in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 1
    Last Post: 6 Aug 2008, 10:19 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR