MySQL Error with Insert - Version incompatibility?

[Rowan]

When I try to create a new Product Option on my local test server I get the following error:

1264 Out of range value adjusted for column 'products_options_sort_order' at row 1
in:
[insert into products_options (products_options_id, products_options_name, language_id, products_options_sort_order, products_options_type, products_options_images_per_row, products_options_images_style, products_options_rows) values ('1', 'Test', '1', '', '0', '', '', '' )]

My local test server is running:

Apache/2.0.55 (Win32) PHP/5.1.2
MySQL 5.0.19-nt
PHP: 5.1.2

On the live website however, it does work. The live site is running on:

Apache/2.0.52
MySQL 4.1.15-log
PHP: 4.4.2

Is there anyway I can make some changes to the code on the test server to fix this? Is this even a problem with versions?

[Rowan]

These forums are rediculous, I can't save my post after I start editing. No offense to the mods/admins.

Anyway, I found this solution: http://www.zen-cart.com/forum/showthread.php?t=33118

And it mentions deleting 'STRICT_TRANS_TABLES' from somewhere or rather by using 'MySQL Administrator' which I probably don't have. Would someone be kind enough to give me a few steps to make this fix?

Btw, yes I know I should have searched first, my mistake.

[DrByte]

In your MySQL configuration, you likely have a "my.ini" file.
Find the STRICT_TRANS_TABLES entry there, and remove it.
You might have to restart your MySQL engine and Apache (or just reboot) for it to take effect.

[Rowan]

Thankyou very much, I commented out the line with a hash (#) and it now works perfectly.

I assume a fix is on the backburner?

[DrByte]

I assume a fix is on the backburner?

As we find them, yes. A number of additional MySQL5-compatibility fixes will be in the next release.