1366 Incorrect integer value Problems with MySQL 5 strict-mode

[calculoso]

It seems that the problem can be summarized as follows:

Have one virtual product in your cart. Hit the Checkout button. The flow should skip past the "Checkout - Step 1" step and go automatically to "Payment Method - Step 2". The shipping text at the bottom should show "Free Shipping".

Here's what looks like happens.

When hitting the checkout button, the flow goes into the "Checkout - Step 1" stage. In here, there is logic that says:

/includes/modules/pages/checkout_shipping/header_php.php

// if the order contains only virtual products, forward the customer to the billing page as
// a shipping address is not needed
  if ($order->content_type == 'virtual') {
    $_SESSION['shipping'] = 'free_free';
    $_SESSION['shipping']['title'] = 'free_free';
    $_SESSION['sendto'] = false;

and then redirects to the next stage in the flow. Eventually it gets to a /includes/modules/order_total/ot_shipping.php file

    function process() {
      ... (snip) ...
      $module = substr($_SESSION['shipping']['id'], 0, strpos($_SESSION['shipping']['id'], '_'));

$_SESSION['shipping'] has a value of 'free_free' from above, but $_SESSION['shipping']['id'] only has a value of 'f'.

in the same function:

      ... (snip) ...
        if ($_SESSION['shipping'] == 'free_free')
        {
            $order->info['shipping_method'] = FREE_SHIPPING_TITLE;
        }

I may be missing something, but for this 'free_free' type, it never sets the "shipping_cost"... and how it gets a shipping cost of 'f' I haven't found yet.

Can anyone give a solution to the issue? Adding $order->info['shipping_cost'] = 0; to that last code snippet seems to work, but I want to know if there are other side-effects that it would cause? Right place for the 'patch'?

[fugalaya]

Was this ever fixed? I have a vanilla installation of v1.3.8a with the demo data and when I add "New v1.2/downloads/Single Download" to the cart and click "confirm the order" on checkout step 3, I get the same error as others:

==================================
1366 Incorrect decimal value: 'f' for column 'value' at row 1
in:
[INSERT INTO orders_total (orders_id, title, text, value, class, sort_order) VALUES ('6', 'Free Shipping:', '$0.00', 'f', 'ot_shipping', '200')]
==================================

Thanks

edit: It happens on both download products.

[DraconPern]

Turning off strict mode fixed the problem. However I have several live orders that never made it past this error. Help! I am using paypal payment pro. From looking at this issue, it doesn't seem to matter which payment method is used, all of them give this error. How to I fix these orders so they show up?

[DrByte]

Two things you might also want to do:
http://www.zen-cart.com/forum/showpo...98&postcount=6
http://www.zen-cart.com/forum/showthread.php?t=115206