Jump to content
dev osCommerce
Forum
  • Checkout
  • Login
  • Contact Us
  • Get in touch

osCommerce

The e-commerce.

New Demo
Our Partners

FLIBIU

Archived
 View Profile  See their activity

  • Posts

    19

  • Joined

  • Last visited

 Content Type 

Posts posted by FLIBIU

    Credit Class/Gift Vouchers/Discount Coupons 5.10

    in General Add-Ons Support

    Posted

    It doesn't work for me. :-"

     

    the part of the code section is :

    // #################### Begin Added CGV JONYO ######################

  $gv_query=tep_db_query("select amount from " . TABLE_COUPON_GV_CUSTOMER . " where customer_id = '" . $customer_id . "'");
  $gv_result=tep_db_fetch_array($gv_query);
  $gv_payment_amount = $gv_result['amount'];


//		if ($order->info['total'] - $total_deductions <= 0 ) {
	if ($order->info['total'] - $gv_payment_amount <= 0 ) {
if(!tep_session_is_registered('credit_covers')) tep_session_register('credit_covers');
	  $credit_covers = true;
	}
else{   // belts and suspenders to get rid of credit_covers variable if it gets set once and they put something else in the cart
	if(tep_session_is_registered('credit_covers')) tep_session_unregister('credit_covers');
}
// #################### End Added CGV JONYO ######################

     

    So, we can see in this code that the test only includes the amount of the gift vouchers and not the redeemed coupons.

    So we have to recuperate the amount of the redeemed coupons in the "if condition".

     

     

    Hey loic_425,

     

    I'm using CCGV Trad, so maybe that's why my 'fix' worked for me and not for you...hope this helps you.

     

    FLIBIU

    Credit Class/Gift Vouchers/Discount Coupons 5.10

    in General Add-Ons Support

    Posted

    no it doesn't work.

     

    I think the error is here :

    catalog/includes/classes/order_total.php around line 268

    if ($order->info['total'] - $gv_payment_amount <= 0 ) {
if(!tep_session_is_registered('credit_covers')) tep_session_register('credit_covers');
	  $credit_covers = true;
	}

     

    when i manually do if ($order->info['total'] - $gv_payment_amount -5.99 <= 0, it works.

    so it needs to have the value of this var.

     

    I tried to use this function : calculate_credit($amount), but it returns "null".

     

    Hey loic_425,

     

    I've been working on this for hours...I'm also teaching myself php...so I have a 'fix'.

    As you already know, 'catalog/includes/classes/order_total.php ' contains the code that is suppose to keep $0 orders from being passed to a payment gateway. I've been staring at that code and I can't find anything wrong...but I'm new to php.

    I then looked at 'catalog/checkout_confirmation'.....Here's what I noticed. If the code in 'catalog/checkout_confirmation' is executed twice, then $0 orders are not being passed to a payment gateway. Any order greater than $0 is being passed to a payment gateway. Perfect, everything work as it should.

     

    This is how I modified 'catalog/checkout_confirmation'

     

    replace this code:

     

    <head>

    <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">

     

    with this code:

     

    <head>

    <script>

    var reloaded = false;

    var loc=""+document.location;

    loc = loc.indexOf("?reloaded=")!=-1?loc.substring(loc.indexOf("?reloaded=")+10,loc.length):"";

    loc = loc.indexOf("&")!=-1?loc.substring(0,loc.indexOf("&")):loc;

    reloaded = loc!=""?(loc=="true"):reloaded;

     

    function reloadOnceOnly() {

    if (!reloaded)

    window.location.replace(window.location+"?reloaded=true");

    }

    reloadOnceOnly();

    </script>

    <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">

     

    I know this isn't a real fix, but it works for me and I hope it works for you! Let me know what happens when you try it.

     

    FLIBIU

    Credit Class/Gift Vouchers/Discount Coupons 5.10

    in General Add-Ons Support

    Posted

    Hi,

     

    there's a problem in this case :

     

    - you have a basket of 15€ of products

    - the costs of your carriage is 5.99€

    - you have a Discount Coupon which gives the free carriage costs so you have -5.99€ to balance.

    - you have 17€ of Gift Voucher

     

    the total amount is 0.00€ but the error "ERROR_NO_PAYMENT_MODULE_SELECTED" appears

    cause the total of the amount is 20.99€ (15+5.99) before the -5.99€.

     

    i'm almost sure that the error is here

    in "catalog/checkout_confirmation.php".

    (around line 70)

    // ################# Added CGV Contribution ##################"

    // if ( ( is_array($payment_modules->modules) && (sizeof($payment_modules->modules) > 1) && !is_object($$payment) ) || (is_object($$payment) && ($$payment->enabled == false)) ) {

    if ( (is_array($payment_modules->modules)) && (sizeof($payment_modules->modules) > 1) && (!is_object($$payment)) && (!$credit_covers) ) {

    // ################# End Added CGV Contribution ##################"

    tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, 'error_message=' . urlencode(ERROR_NO_PAYMENT_MODULE_SELECTED), 'SSL'));

    }

     

    thanks a lot

    Loic

     

    Hey loic_425,

     

    Did you find a fix for "No payment method selected" message?

    If I don't select a payment method, then I can't checkout. If I do select Paypal and the order is $0.00 after the Gift Certificate is applied then Paypal gives me this error, "The link you have used to enter the PayPal system contains an incorrectly formatted item amount."

     

    99% there,

    FLIBIU

    Credit Class/Gift Vouchers/Discount Coupons 5.10

    in General Add-Ons Support

    Posted

    Hi,

     

    there's a problem in this case :

     

    - you have a basket of 15€ of products

    - the costs of your carriage is 5.99€

    - you have a Discount Coupon which gives the free carriage costs so you have -5.99€ to balance.

    - you have 17€ of Gift Voucher

     

    the total amount is 0.00€ but the error "ERROR_NO_PAYMENT_MODULE_SELECTED" appears

    cause the total of the amount is 20.99€ (15+5.99) before the -5.99€.

     

    i'm almost sure that the error is here

    in "catalog/checkout_confirmation.php".

    (around line 70)

    // ################# Added CGV Contribution ##################"

    // if ( ( is_array($payment_modules->modules) && (sizeof($payment_modules->modules) > 1) && !is_object($$payment) ) || (is_object($$payment) && ($$payment->enabled == false)) ) {

    if ( (is_array($payment_modules->modules)) && (sizeof($payment_modules->modules) > 1) && (!is_object($$payment)) && (!$credit_covers) ) {

    // ################# End Added CGV Contribution ##################"

    tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, 'error_message=' . urlencode(ERROR_NO_PAYMENT_MODULE_SELECTED), 'SSL'));

    }

     

    thanks a lot

    Loic

     

    I have the same problem and what's worst is that when the order is $0.00 (Example: Order is $20 and the Gift Certificate is $20) and the customer wants to pay by Paypal, Paypal gives an error since Paypal is expecting some sort of dollar amount.

     

    FLIBIU :'(

    [Contribution] Admin Specials by Category

    in General Add-Ons Support

    Posted

    Hi Josh,

     

    I added this mod yesterday, and the EXACT same thing happened to me...I have removed it and installed my backed up files and just like you, my site is REALLY slow...for sure, I'm losing orders because of this...were you able to find the solution? Please let me know either way...I'm panicing!!!

     

    Randal

     

     

    UPDATE - To fix the slow condition: Add the "Optimize Database" Mod and run it. At least that fixed the problem for me...I haven't reinstalled the "Special by Category" Mod to see how fast my site runs together with the "Optimize Database" Mod together. Good luck everyone...

     

    Randal

    [Contribution] Admin Specials by Category

    in General Add-Ons Support

    Posted

    Hi. I successfully installed this contribution and I think it's great (very easy to use)! One problem however (big problem), and I don't know if it's the contribution causing the problem or something else related to specials, but now when I have any number of specials, even just 1, my main index page slows down to a crawl. The category pages are just slightly better, though still very slow, and the product pages and shipping/contact/etc... are just fine). Any help would be greatly appreciated.

     

    Thanks!

     

    Hi Josh,

     

    I added this mod yesterday, and the EXACT same thing happened to me...I have removed it and installed my backed up files and just like you, my site is REALLY slow...for sure, I'm losing orders because of this...were you able to find the solution? Please let me know either way...I'm panicing!!!

     

    Randal

    [Contribution] Admin Specials by Category

    in General Add-Ons Support

    Posted

    Firstly i'd like to say thanks Carine for a fantastic contibution [exactly what i needed].Installed easily and worked perfectly....except... i have had the same problem as Josh Friedman.My site was running lighting fast until i installed this contibution.I hate to say it,but...the lack of speed is directly related to this contibution. I have removed it and installed my backed up files and my site still runs like a snail on quaaludes [reeeeaaallly slow]...any idea how to keep your contibuton and keep my site speed up?

     

    Thanks

    Danny

     

     

    Danny,

     

    I added this mod yesterday, and the EXACT same thing happened to me...I have removed it and installed my backed up files and just like you, my site is REALLY slow...for sure, I'm losing orders because of this...were you able to find the solution? Please let me know either way...I'm panicing!!!

     

    Randal

    1136 - Column count doesn't match value count at r

    in General Add-Ons Support

    Posted

    :huh:  :huh: I uploaded my products and I thought I had it all configured correctly but I guess not, one product was added I guess but I don't know where to find it.  I really need help fast and appreciate any you can give. here is what my screen said after i uploaded the product.

     

    File uploaded.

    Temporary filename: /tmp/phpZP5JFO

    User filename: EP2004Apr07-1604.txt

    Size: 4914

    | A | CDG-LC001 | graphics/0 | 24.95 | 0.2 | 0 | 9999 | Priddis | CLSROCK,LC !New Product!

    1136 - Column count doesn't match value count at row 1

     

    INSERT INTO products ( products_image, products_model, products_price, products_tax_class_id, products_weight, products_quantity, manufacturers_id) VALUES ( 'graphics/00000001/lc_sm.gif', 'CDG-LC001', '24.95', CURRENT_TIMESTAMP, '0', '0.2', '9999', 'Priddis' 'CLSROCK,LCCD')

     

    I have the same problem and I haven't been able to find the reason it's happening...I ended up starting fresh with an unmodified version of oscommerce and added the Canada Post Mod & easypopulate Mod & the Extra fields mod and it works now.

    problem with canada post module

    in Shipping Modules

    Posted · Edited by FLIBIU

    Cath,

     

    Which module are you using ?

     

    WW

     

    www.callibo.com

     

    :'( Hey WW,

     

    I am getting the exact same error as Cath (see below). Do you know how to fix it? Anything you can do to help a fellow Canadian would be greatly appreciated.

     

    Thanks,

    Randal

     

    Error I'm getting -->

     

    1054 - Unknown column 'p.products_dim_type' in 'field list'

     

    select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_dim_type, p.products_weight_type, p.products_length, p.products_width, p.products_height, p.products_ready_to_ship, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from products p, products_description pd where p.products_id = '73' and p.products_id = pd.products_id and pd.language_id = '1'

     

    [TEP STOP]

    problem with canada post module

    in Shipping Modules

    Posted

    I am getting an error on the page:

    1054 - Unknown column 'p.products_dim_type' in 'field list'

     

    select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_dim_type, p.products_weight_type, p.products_length, p.products_width, p.products_height, p.products_ready_to_ship, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from products p, products_description pd where p.products_id = '47' and p.products_id = pd.products_id and pd.language_id = '1'

    This seems to be in the shoppingcart file.

    Whats happening?

     

    :'( Hey Cath,

     

    I have the exact error you listed above. How exactly did you fix this 1054 error? This is one of the last things holding my store up and I've been racking my brains (or lack there of) to figure this out. Any help would be greatly, greatly, greatly apprieciated!

     

    Randal

×
×
  • Create New...