[Done v1.3.7.1]Checking out virtual products leads to SQL error (MySQL 5)

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.

        if ($_SESSION['shipping'] == 'free_free')
        {
            $order->info['shipping_method'] = FREE_SHIPPING_TITLE;
[I][B]Added:                  $order->info['shipping_cost'] = 0;
[/B][/I]

Is this valid or is there more to add?

Have you loaded the Cart with the Demo product set?

Try it as there are virtual products there and you can view the admin settings for these

Same problem.

I just did a fresh install (in a separate directory and Sql server), and installed the demo product set.

I tried to purchase a $5 gift certificate - a virtual product.

Ran into the same problems as before. Had to follow the first instructions (add the '(int)' in front of the format id values), and then witnessed this same error:

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

Did you read th post by DrByte?

DrByte:

'f' should never be in the "value" field, as the "value" field is supposed to contain a numeric value.

Starting from installation, how exactly have you configured your shop?
What modules have you installed?
What addons have you installed?
What currencies have you edited? What did you change in currency settings?
What taxes have you added?
Which languages have you installed?
Do the errors stop if you switch back to English?
'f' seems to be the issue....

I agree that the 'f' is the issue.. but I was trying to figure out where the 'f' came from.

It seems to come from the 'free_free' shipping that was automatically set in the script. I don't think that everything that needs to be set is actually set.

Adding the line below in red to the /includes/modules/order_total/ot_shipping.php file seems to fix it.

        if ($_SESSION['shipping'] == 'free_free') {
            $order->info['shipping_method'] = FREE_SHIPPING_TITLE;
[I][B]Added:                  $order->info['shipping_cost'] = 0;
[/B][/I]
         }

Yes, I added the same extra line and it fixed the problem. I cant see any side affects anywhere so it seems to solve the problem.

(I just added the closing bracket to your code to make it clearer to others)

Thanks for posting your solution.

Murray

Just for giggles and grins, what happens if you install a test copy into a test database with the demo products of the current version of Zen Cart v1.3.7.1 ...
http://www.zen-cart.com/forum/showthread.php?t=69769

Great post, thanks everybody, had the same problem but now fixed.

However now the new orders made are not shown in user account and admin. I've checked the database and the orders are there. Think I'll do some search on the forum for this problem.

If you do a Search on orders_id do they show?

If so, check the Modules ... Order Total ... and make sure Total ot_total is installed and enabled ...

Yes they show and yes ot_total has been enabled...

Ah but the problem has been fixed in zen-cart 1.3.7.1

thanks ;)

I'm having the same problem and this isn't working"
$order->info['shipping_cost'] = 0;
Any suggestions?
Thanks everone.

I'm having the same problem and this isn't working:
$order->info['shipping_cost'] = 0;
Thanks everyone.

I have done all of this and now it goes to the checkout success page but the product does not download. Any suggestions? Thanks.

When you look at the Order, what is the orders_status?

If the orders_status is not between the values set in the Attributes Settings, >= 2 (Processing) and <= 4 (Upgraded) then you will not be able to download the Download until the Order is updated for the orders_status ...

The orders_status can be configured on the Payment Module on a per Payment Module basis ...