Jump to content


  • Content count

  • Joined

  • Last visited

About sitefever

  • Birthday 06/27/1982

Profile Information

  1. Ive installed the newest version, everything seems good. No errors, I can create coupons, etc with no problems. However, in the admin area under Modules > Order Total > Discount Coupon, any changes I make are never saved. I can change any paremeters, enable or disable the module, but nothing is ever saved. I never get any errors. Any thoughts??? Any help would be appreciated! Thanks.
  2. Sorry if this has been touched on already, but I searched this topic and could not find anything pertaining to this. I have the newest version of your contribution installed- 3.3. Everything is working flawlessly. When the customer gets to checkout_confirmation.php, their shopping cart total is displayed with the coupon discount. In the upper right hand corner I have boxes/shopping_cart.php, and the total shows there without the coupon discount. This has been confusing to some of my customers. What updates do I have to do to boxes/shopping_cart.php in order for it to display the discounted price? Thank you! BTW- I have never seen anybody support their mod/contribution like KG does- for ANY script I have used in the past. GREAT SUPPORT!
  3. UPDATE: I found a temporary solution to the problem. In includes/classes/discount_coupon.php, I commented out all the lines dealing with zone exclusions: //shipping zone exclusions // $check_user_query = tep_db_query($sql = 'SELECT dc2z.geo_zone_id // FROM '.TABLE_DISCOUNT_COUPONS_TO_ZONES.' dc2z // LEFT JOIN '.TABLE_ZONES_TO_GEO_ZONES.' z2g // USING( geo_zone_id ) // WHERE ( z2g.zone_id='.$delivery['zone_id'].' or z2g.zone_id = 0 or z2g.zone_id IS NULL ) // AND ( z2g.zone_country_id='.$delivery['country_id'].' or z2g.zone_country_id = 0 ) // AND dc2z.coupons_id="'.tep_db_input( $code ).'"' ); // // if (tep_db_num_rows( $check_user_query ) > 0 ) { // $this->message( ENTRY_DISCOUNT_COUPON_ERROR ); //display the error message //use this to debug exclusions: //$this->message( 'Shipping Zones exclusion check failed' ); // } //end shipping zone exclusions Now the discount coupon mod works with my digital items, only I will have to remember that I can no longer make coupons with zone exclusions :) Its strange that I only had that error when using digital products. There must be an error in the syntax of the above code somewhere...
  4. P.S.- I just noticed that I only get the above error when checking out with downloadable items (all of the items in my store are downloadable). If I use a product that is not downloadable, everything with this mod works fine. Any thoughts as to why this error is happening when attempting to checkout with downloadable items? Thank you!
  5. I have installed this mod for other people before, and I have to say that it's great! I went ahead and installed it on my own store this morning and I am getting the following SQL error on checkout_payment.php: 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 'or z2g.zone_id = 0 or z2g.zone_id IS NULL ) ' at line 5 SELECT dc2z.geo_zone_id FROM discount_coupons_to_zones dc2z LEFT JOIN zones_to_geo_zones z2g USING( geo_zone_id ) WHERE ( z2g.zone_id= or z2g.zone_id = 0 or z2g.zone_id IS NULL ) AND ( z2g.zone_country_id= or z2g.zone_country_id = 0 ) AND dc2z.coupons_id="w8663m" Any thoughts? Thanks.