fernyburn Posted October 16, 2008 Share Posted October 16, 2008 Hi I have recently upgraded to version rc2, and use with fast easy checkout ms2.2 has always worked - but since upgrading discount coupons has stopped working totally I have been through the code about 5 times, and checked everythin is in place. the coupon box shows on checkout_shipping (this is where it needs to go with fec) but the discount doesn't show on checkout_confirmation. can anyone shed any light on this - as to what the problem could be Quote Link to comment Share on other sites More sharing options...
mafiouso Posted October 18, 2008 Share Posted October 18, 2008 i have this problem, when i add a product to card, then update the quantity. the coupon won't work? any ideas? thanks Quote Link to comment Share on other sites More sharing options...
inveritas Posted October 24, 2008 Share Posted October 24, 2008 Hi there, Since a few days i'm getting the following error in my checkout_confirmation.php Fatal error: Using $this when not in object context in /var/www/vhosts/beauty7.be/httpdocs/includes/classes/discount_coupon.php on line 165 I would really appreciate any help. The weird thing is that it just happened, I didn't change anything or didn't install anything else you know. I get the same error (most likely php 5.xx vs. 4.xx issue). Did yuo fix this yet and if so, how? Quote Link to comment Share on other sites More sharing options...
Stitch20 Posted October 24, 2008 Share Posted October 24, 2008 I have contri 3.31 installed I have a problem, i have "the minimum order total for this coupon is $100,-" set. But when i put items in my shopping cart over $100,- i get an error. That the minimum order total $100,- is. But i have more than $100,- in my shoppingcart! Could someone help me? Quote Link to comment Share on other sites More sharing options...
zeroxxorez Posted October 25, 2008 Share Posted October 25, 2008 (edited) I'm having problems. I'm getting 1062 - Duplicate entry 'test-0' for key 1 insert into discount_coupons_to_orders (coupons_id, orders_id) values (test', '') [TEP STOP] on checkout_confirmation.php this is only happening with IE though. On firefox it works great. Any help? Thanks! EDIT: well now its doing it for firefox too.... Edited October 25, 2008 by zeroxxorez Quote Link to comment Share on other sites More sharing options...
zeroxxorez Posted October 25, 2008 Share Posted October 25, 2008 ok well now it seems that firefox ocassionally will work...but IE never does...it throws the error every time and stops loading the page I really need help with this and I am also willing to pay for help. The store that is running this is SpiceWorld420.com It shouldn't be too hard of a fix but it seems like nobody ever answered it when other people asked the same question. Quote Link to comment Share on other sites More sharing options...
antonitus Posted October 26, 2008 Share Posted October 26, 2008 Hi, Can anyone help me with this issue. I just installed Discount Coupon Codes and what a powerful contribution. Everything works fine, however when the customer and admin receives the order email, the discount is not in the email. Also it is not shown in the admin area under customers' orders, i.e. invoice, etc. I have re-checked the code time and time again and it all looks good. What I really want to know is what file is responsible for this so that I can debug it or something. Just to let you know I'm not a PHP guru, just a novice or trying to be and I cannot just add this file direct into my server as I have added other contributions. Instead, I edited most of the files and some I copied direct as they did not have a contribution added to that file. Thanks for your help. antonitus Quote Link to comment Share on other sites More sharing options...
Bambino Posted October 26, 2008 Share Posted October 26, 2008 (edited) I get the same error (most likely php 5.xx vs. 4.xx issue). Did yuo fix this yet and if so, how? I didn't mate, definitely php 5 prob, didn't have it on php 4.3. my shop is still not functioning, handling sales through mail currently. let me know if you find out how. Edited October 26, 2008 by Bambino Quote Link to comment Share on other sites More sharing options...
inveritas Posted October 27, 2008 Share Posted October 27, 2008 I didn't mate, definitely php 5 prob, didn't have it on php 4.3. my shop is still not functioning, handling sales through mail currently. let me know if you find out how. I can't believe we're the only ones with this issue. Hundreds if not thousands of ppl are using this contribution. Quote Link to comment Share on other sites More sharing options...
antonitus Posted October 27, 2008 Share Posted October 27, 2008 Man there should be a forum just for this contribution. It's all messed up here and so confusing. KGT if you're listening, which I don't think you are any more, you need to create another forum on another website dedicated to this contribution only. If you want, I can help with the web server side. As you can see there are many types of problems with no specific topic attached to them. So how can we find a specific issue through over 100 pages? antonitus Quote Link to comment Share on other sites More sharing options...
Bambino Posted October 27, 2008 Share Posted October 27, 2008 I can't believe we're the only ones with this issue. Hundreds if not thousands of ppl are using this contribution. If there's no one out here who can help, its probably just changing 2 lines of code i'm gonna hire on tonight to do the job for 15$ :) Quote Link to comment Share on other sites More sharing options...
mattalt Posted October 27, 2008 Share Posted October 27, 2008 Is there a way to add a payment exclusion when a customer wants to pay with credit card? Quote Link to comment Share on other sites More sharing options...
inveritas Posted October 29, 2008 Share Posted October 29, 2008 If there's no one out here who can help, its probably just changing 2 lines of code i'm gonna hire on tonight to do the job for 15$ :) Yeah, this line must be altered to php5 standards: $order_total = $this->cart_info['total_products']['total']; Quote Link to comment Share on other sites More sharing options...
Bambino Posted October 29, 2008 Share Posted October 29, 2008 Yeah, this line must be altered to php5 standards: $order_total = $this->cart_info['total_products']['total']; change: $order_total = $this->cart_info['total_products']['total']; to: $order_total = $cart_info['total_products']['total']; and its solved. Quote Link to comment Share on other sites More sharing options...
inveritas Posted October 29, 2008 Share Posted October 29, 2008 change:$order_total = $this->cart_info['total_products']['total']; to: $order_total = $cart_info['total_products']['total']; and its solved. See, i had this good feeling some program wizz such as yourself would be hinted by my snippet, rather than getting inside the script;-) I'll go try. Thanks. Quote Link to comment Share on other sites More sharing options...
jrd1mra Posted October 29, 2008 Share Posted October 29, 2008 (edited) Hiya. I have just installed Discount Coupon codes, but when i add a product to my cart, then checkout, i get the following error! Any ideas how to fix it? Thanks, Andy 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 ) 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="10% Off" [TEP STOP] I had this same problem and I found a "duct tape" fix. I am no programming expert but this worked for me. It removes your shipping zone exclusions completely so if you need to use that part of this contribution this fix will not work for you. This is what I did: open: admin\includes\languages\english\coupons_exclusions.php around line 42 find: //shipping zone exclusions case 'zones' : $heading_available = 'This coupon may be used in these shipping zones.'; $heading_selected = 'This coupon may <b>not</b> be used in these shipping zones.'; break; //end zone exclusions Replace with: /*** //shipping zone exclusions case 'zones' : $heading_available = 'This coupon may be used in these shipping zones.'; $heading_selected = 'This coupon may <b>not</b> be used in these shipping zones.'; break; //end zone exclusions **/ open: catalog\includes\classes\discount_coupons.php Around line 71 find: //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 Replace with: /*** //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 ***/ Open admin\coupons.php around line 293 find: '<a href="' . tep_href_link(FILENAME_DISCOUNT_COUPONS_EXCLUSIONS, 'cID='.$cInfo->coupons_id.'&type=zones') . '">' . tep_image_button('button_shipping_zone_exclusions.gif', IMAGE_SHIPPING_ZONE_EXCLUSIONS, 'hspace="2" vspace="2"') . '</a> ' Replace with: /** .'<a href="' . tep_href_link(FILENAME_DISCOUNT_COUPONS_EXCLUSIONS, 'cID='.$cInfo->coupons_id.'&type=zones') . '">' . tep_image_button('button_shipping_zone_exclusions.gif', IMAGE_SHIPPING_ZONE_EXCLUSIONS, 'hspace="2" vspace="2"') . '</a> ' **/ This just comments out the code which executes the shipping zones script. Thats what I did and I do not receive the sql syntax error any longer. . I actually dont receive it after I fix the catalog\includes\classes\discount_coupons.php file. The rest of the code is simply to remove the shipping zones from view so that It is not used since removing the code in the discount_coupons.php file breaks that portion of the module. I hope this helps, use at your own risk it has not been extensively tested. This contribution is OK. It does not work out of the box for most people. I suggest that it be removed as the original creator has obviously given up on it. Edited October 29, 2008 by jrd1mra Quote Link to comment Share on other sites More sharing options...
antonitus Posted October 30, 2008 Share Posted October 30, 2008 You're right jrd1mra, the creator doesn't seem to be interested no more, however there are smart PHP programmers out there who can take on this project. It has a few problems for me and I will be removing it from my system, although it's a powerful contribution, but I can live without it, it's no big deal, there are other discount contributions out there. Quote Link to comment Share on other sites More sharing options...
Guest Posted November 4, 2008 Share Posted November 4, 2008 sorry if this is answered already but i did have a quick look through this topic and couldnt find a solution, I have installed this contribution before and it worked fine, but i recently reinstalled my shop and have now started adding my addons, i installed this but now all of a sudden I have no modules, Quote Link to comment Share on other sites More sharing options...
Guest Posted November 4, 2008 Share Posted November 4, 2008 sorry if this is answered already but i did have a quick look through this topic and couldnt find a solution, I have installed this contribution before and it worked fine, but i recently reinstalled my shop and have now started adding my addons, i installed this but now all of a sudden I have no modules, sorry I am a complete and utter noob, i sorted it, it was nothing to do with the contribution, its because a setting was out in the admin config file..... doh! but I am having a little problem now, everything seems to work, but when i add a product to my cart and click checkout i just get a white screen, any ideas what i have done wrong? I do not use table rates for shipping... instead I use this contribution - http://addons.oscommerce.com/info/2571 thanks peeps! ;) Quote Link to comment Share on other sites More sharing options...
geoffwin Posted November 5, 2008 Share Posted November 5, 2008 I am using 3.3.1 Contribution has been working OK I think. I have now discovered that none of the exclusion work. When I create a discount coupon it can be used with any purchase. I wish to apply the coupon code to specific products and categories. Any suggestions? thanks Geoff Quote Geoff Telegraph Point 2441 Australia Link to comment Share on other sites More sharing options...
ssnb Posted November 8, 2008 Share Posted November 8, 2008 (edited) Thanks for this great contribution. I've searched the forums but can't find anyone with a similar issue, so I'm posting here. I have Discount Coupon Codes installed and was working perfectly fine. I have just installed Get 1 Free contribution - which also works fine. BUT when entering a discount code the order total is wrong (shows a negative total amount). I'm guessing the discount coupons code needs to be told to ignore the free items? but where and how!? I have found a temporary fix - which is to exclude the free product from the discount code - but obviously not ideal - at least it works ok for the time being! I hope someone here can help. Cheers SSNB Edited November 8, 2008 by ssnb Quote Link to comment Share on other sites More sharing options...
antonitus Posted November 8, 2008 Share Posted November 8, 2008 A suggestion to everyone. Don't bother trying to use this forum for this contribution as nobody will help any more and the creator has vanished and doesn't care at all or has kicked the bucket, one or the other. I'm quite annoyed with this contribution if there aren't people to help so in my eyes it's crap and very buggy. Because of this I decided to use Joomla. Quote Link to comment Share on other sites More sharing options...
clemptor Posted November 8, 2008 Share Posted November 8, 2008 I think I should have the multiple coupon modification done in a week, but I'm slow at documenting what I do so I may not have it posted here in the same time frame. Tapuahk, Something like this would be extremely useful for me. Did you get this to work with multiple coupons? Thanks in advance... Quote Link to comment Share on other sites More sharing options...
ejda Posted November 9, 2008 Share Posted November 9, 2008 I have a problem. I have installed the contrib and it works with fixed amount. But the problem is that i can't use the exclude part. I'm trying to exclude all manufacturers except one. Buying a product with that included manufacturer works with the discount but i'f i'm trying to buy from another manufacturer i don't receive any error message, i just proceed to the next checkout without any discount. I'f i'm buying from both an included and excluded manufacturer i do receive the discount. Anyone who knows what the problem might be? Quote Link to comment Share on other sites More sharing options...
Amrahp Posted November 11, 2008 Share Posted November 11, 2008 Hi, First of all: Wonderful contribution! Now... I recieve an error just out of nowhere and have no clue how where it came from. Have searched and it seems like I am alone on this??!! 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 'AND coupons_id="testcode"' at line 4 SELECT dc2u.customers_id FROM discount_coupons_to_customers dc2u WHERE customers_id= AND coupons_id="testcode" [TEP STOP] Any help is highly appreciated since this is "quite" urgent. Thanks! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.