Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2007
    Location
    WAY out West
    Posts
    89
    Plugin Contributions
    0

    Default Coupon error code

    I have Zen 1.3.7

    Trying to set up a coupon on a cart that previously had none.
    I have installed the discount coupons module and get this message
    Warning: Division by zero in /home/xxxxyz/public_html/xxx/admin/includes/classes/split_page_results.php on line 48
    1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-0,' at line 1
    in:
    [select coupon_id, coupon_code, coupon_amount, coupon_type, coupon_start_date,coupon_expire_date,uses_per_user,uses_per_coupon,restrict_to_p roducts, restrict_to_categories, date_created,date_modified, coupon_active, coupon_zone_restriction from zen_coupons where coupon_active='Y' and coupon_type != 'G' limit -0, ]
    If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
    I cant find a zero anywhere near line 48 in the split_page_results.php
    nor can I find the text "select coupon_id" anywhere in that file.

    Removed the module and reinstalled with no change.
    Replaced the file on the server and reinstalled module with no change.

    A clue for the clueless would be appreciated.
    Thanks
    Henrietta


  2. #2
    Join Date
    Mar 2007
    Location
    WAY out West
    Posts
    89
    Plugin Contributions
    0

    Default Re: Coupon error code

    I renamed coupon_admin.php to oldcoupon_admin.php and uploaded coupon_admin.php from the original file set. This gave me a new drop down menu in the Gift Certificate/Coupons tab in the dashboard (which had not been there before.)

    I then deleted oldcoupon_admin.php

    Next I went to the Configuration tab >> GV Coupons and put the number 20 in both Maximum Discount Coupons per page and Maximum Discount Coupon Report Results per page.

    This removed the error message.

    I do not know which of my actions removed the error code.
    Henrietta


  3. #3
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    67,536
    Plugin Contributions
    6

    Default Re: Coupon error code

    If you set the Maximums to 20 and they were 0, that is part of the problem ...

    Reloading the file: coupon_admin.php could have corrected other issues ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.3]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...

  4. #4
    Join Date
    Aug 2009
    Location
    Washington State
    Posts
    52
    Plugin Contributions
    0

    Default Re: Coupon error code

    Hello,

    Using:
    Zen Cart 1.3.8a
    Patch: 1::

    Had the exact error message as original poster.

    I applied the second part of the original poster's solution:
    "Next I went to the Configuration tab >> GV Coupons and put the number 20 in both Maximum Discount Coupons per page and Maximum Discount Coupon Report Results per page."

    And this solved the problem for me.

    Thanks!

 

 

Similar Threads

  1. how can I code in a default coupon code into checkout page redeem, then auto-refresh?
    By lankeeyankee in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 1
    Last Post: 29 Nov 2008, 04:56 AM
  2. 1054 Error - Coupon Code Zones - HELP!!!
    By expresso in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 29 Feb 2008, 08:09 AM
  3. Coupon Code in URL
    By kevinhankens in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 20
    Last Post: 6 Oct 2007, 07:22 PM

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
  •