Product Attributes

[atlantis]

Hello, I have installed zencart ok, however for some reason whenever i try to add a product option name I get the following error.

"1264 Out of range value adjusted for column 'products_options_images_per_row' 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', 'Colour', '1', '1', '0', '', '', '' )]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields."

I did not leave any blank fields, and I have done this loads of times before on other zen installs without a problem?

Any help would be great

Thanks

[DrByte]

This is an incompatibility with MySQL 5 on your server.

Easiest way to fix it is to reconfigure your MySQL to not use the STRICT_TRANS_TABLES option.

[atlantis]

Thanks, I am relatively new to MySQL, how would I reconfigure my, MySQL to not use the STRICT_TRANS_TABLES option ?

Thanks

[atlantis]

I found it, I simply removed the entry from the MySQL ini file.

Thanks for your help, its now working great. :)

[DrByte]