1366 Incorrect integer value Problems with MySQL 5 strict-mode

[Max70]

Hi
I use
mysql 5.0.37
zen cart 1.3.7.

acquiring a gift certificate and confirming the order I have the following error

1366 Incorrect integer value: '' for column 'delivery_address_format_id' at row 1
in:
[INSERT INTO orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, payment_module_code, shipping_method, shipping_module_code, coupon_code, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, order_total, order_tax, currency, currency_value, ip_address) VALUES ('4',.........

someone can help me
Thanks

[DrByte]

The address-format-id should never be blank like that.

1. What payment method was used to complete the purchase?
2. How did the customer get into the cart? Did you use the normal create-account screen? Or did you use some third-party customer-import tool?
3. How did you come up with the ship-to address?
4. When you created the gift-certificate product, what settings did you select related to shipping? Was it set to "always free shipping"? Was it set to "virtual"? Was it set to require a shipping address?

[Max70]

Hi thanks for your reply

1) The payment method is Check/Money Order or Credit card
2) I use the normal create-account screen
3) The customer get into the cart with the link in the right column.
4) In the payment Information (Step 2 of 3) there's only billing address
5) I select "Yes, Skip Shipping Address"
6) I select No, Normal Shipping Rules

I use the The store Demo (gift certificate in store demo)

Thanks

[DrByte]

That appears to be a bug that only shows up on MySQL 5 when running in strict mode.

The workaround is to edit the /includes/classes/order.php file and change these lines:

                            'format_id' => $customer_address->fields['address_format_id'],

to:

                            'format_id' => (int)$customer_address->fields['address_format_id'],

and:

                            'format_id' => $shipping_address->fields['address_format_id']);

to:

                            'format_id' => (int)$shipping_address->fields['address_format_id']);

and:

                           'format_id' => $billing_address->fields['address_format_id']);

to:

                           'format_id' => (int)$billing_address->fields['address_format_id']);

[Max70]

thanks

now follow me this error

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 ('1', 'Spedizione gratuita:', '0.00EUR', 'f', 'ot_shipping', '200')]

did you now why?
Thanks

Sorry if my english is not good

[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?

[Max70]

I have just installed the zen cart in English
The curriences is Euro and i have don't change the settings
Modules and addons only the pre installed
I don't added taxes
the languages is only english

[Max70]

I comment out the following in the my.ini file(Mysql)

Code:
#sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

like this post http://www.zen-cart.com/forum/showth...+decimal+value

now is all right

You think is the right solutions?
Thanks

[Max70]

Thank you DrByte for help me

now the Gift Certificate is ok.

Max

[calculoso]

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

I have had the same errors as Max70 did, but using the English language. The code changes (adding (int) to the statements) helped above. I now get this, same as he did:

------------------------
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')]
------------------------

This was when test ordering a product that had:

------------------------
Product is Virtual: Yes, Skip Shipping Address
Warning: This product is marked - Free Shipping and Skips Shipping Address
No shipping will be requested when all products in the order are Virtual Products
------------------------

and

------------------------
Always Free Shipping:
No, Normal Shipping Rules
------------------------
(reason for this is because I didn't want the "FREE SHIPPING" icon shown, since there was no product to ship)


My shipping modules:

FREE SHIPPING
Enable Free Shipping
True

Free Shipping Cost
0.00

Handling Fee
0

Tax Class
--none--

Shipping Zone
--none--

Sort Order
0


I'll try to figure out where the 'f' comes from.