Version 1.3.7
MySQL 5.0.10-community-nt via TCP/IP
First Reported in thread:
http://www.zen-cart.com/forum/showthread.php?t=63993
When trying to checkout an order with all virtual products, I got a few errors. The first ones were described and fixed using the modifications in the thread above.
Afterwards, I got this error:
-------------------------
1366 Incorrect decimal value: 'f' for column 'value' at row 1
in:
[INSERT INTO zen2_orders_total (orders_id, title, text, value, class, sort_order) VALUES ('1', 'Free Shipping:', '$0.00', 'f', 'ot_shipping', '200')]
-------------------------
As summarized in the thread above, it looks like the 'shipping_cost' (and possibly other settings) is never set for shipping values of the 'free_free' type.
Adding the line below in red to the /includes/modules/order_total/ot_shipping.php file seems to fix it.
Is this valid or is there more to add?Code:if ($_SESSION['shipping'] == 'free_free') { $order->info['shipping_method'] = FREE_SHIPPING_TITLE; Added: $order->info['shipping_cost'] = 0;



