Cube Cart 3.0.11 Strange Issues

[Guest dhosting]

Right is anyone else experiencing the following issue

When going to view categories then clicking edit on the test category which belongs to the default cubecart setup

Changed the name and click edit to update the name and i get

MySQL Error Occured

1366: Incorrect decimal value: '' for column 'per_ship' at row 1

QUERY = UPDATE store_CubeCart_category SET `cat_name`='Test Category', `cat_father_id`= '0', `cat_image`= '', `per_ship`= '', `item_ship`= '', `item_int_ship`= '', `per_int_ship`= '' WHERE cat_id='1'

Same goes for adding a new subcategory for the Test Category, also get the same result for adding a totally new category, looks like a db setup bug?

MySQL Error Occured

1366: Incorrect decimal value: '' for column 'per_ship' at row 1

QUERY = INSERT INTO store_CubeCart_category (`cat_name`, `cat_father_id`, `cat_image`, `per_ship`, `item_ship`, `item_int_ship`, `per_int_ship`) VALUES ('test', '1', '', '', '', '', '')

Looks like `cat_image`, `per_ship`, `item_ship`, `item_int_ship`, `per_int_ship' arent getting any values

Were running

Win 2k3 STD SP1

IIS6

PHP 5.1.2

MySQL 5.0.24

[goober999]

Right is anyone else experiencing the following issue

When going to view categories then clicking edit on the test category which belongs to the default cubecart setup

Changed the name and click edit to update the name and i get

MySQL Error Occured

1366: Incorrect decimal value: '' for column 'per_ship' at row 1

QUERY = UPDATE store_CubeCart_category SET `cat_name`='Test Category', `cat_father_id`= '0', `cat_image`= '', `per_ship`= '', `item_ship`= '', `item_int_ship`= '', `per_int_ship`= '' WHERE cat_id='1'

Same goes for adding a new subcategory for the Test Category, also get the same result for adding a totally new category, looks like a db setup bug?

MySQL Error Occured

1366: Incorrect decimal value: '' for column 'per_ship' at row 1

QUERY = INSERT INTO store_CubeCart_category (`cat_name`, `cat_father_id`, `cat_image`, `per_ship`, `item_ship`, `item_int_ship`, `per_int_ship`) VALUES ('test', '1', '', '', '', '', '')

Looks like `cat_image`, `per_ship`, `item_ship`, `item_int_ship`, `per_int_ship' arent getting any values

Were running

Win 2k3 STD SP1

IIS6

PHP 5.1.2

MySQL 5.0.24

This error is a result of MySQL v5 configuration. If you have access and are able to comment out the following line in my.ini:

# Set the SQL mode to strict

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_E NGINE_SUBSTITUTION"

it will resolve this problem.

[Guest dhosting]

..............

This error is a result of MySQL v5 configuration. If you have access and are able to comment out the following line in my.ini:

# Set the SQL mode to strict

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_E NGINE_SUBSTITUTION"

it will resolve this problem.

Will give it a try but will have to see what effect it will have on the other users on our servers!

Actually sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_E NGINE_SUBSTITUTION" is already set!

Any other ideas?

[goober999]

..............

This error is a result of MySQL v5 configuration. If you have access and are able to comment out the following line in my.ini:

# Set the SQL mode to strict

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_E NGINE_SUBSTITUTION"

it will resolve this problem.

Will give it a try but will have to see what effect it will have on the other users on our servers! Actually sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_E NGINE_SUBSTITUTION" is already set! Any other ideas?

That's the problem. the fact that it is set. make it like this.

Thanks

/Goober

# Set the SQL mode to strict

# sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_E NGINE_SUBSTITUTION"