Cannot create categories

[Guest shroom]

Hi,

I just installed a copy of CCV3.020. The setup went fine, and I can navigate the store with no problems. I logged into admin, and when I went to create a category, I received the following error:

MySQL Error Occured

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

QUERY = INSERT INTO CubeCart_category (`cat_name`, `cat_father_id`, `cat_image`, `per_ship`, `item_ship`, `item_int_ship`, `per_int_ship`) VALUES ('Clothing', '0', '', '', '', '', '')

The column per_ship is defined as decimal(20,2), not null, default 0.00. But the SQL is trying to insert '' (empty string).

Looking for ideas. Thanks.

edit: Also cannot updating the existing 'Test Category', I get the same error:

MySQL Error Occured

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

QUERY = UPDATE 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'

[vokf]

This sounds a like a possible problem with the ship-by-category shipping module.

Have you installed any mods/tweaks? ie - is this a clean install?

[Guest shroom]

No mods or tweaks. It's a fresh out-of-the-box install. I also cannot do much with the shipping modules. IE:

MySQL Error Occured

1366: Incorrect integer value: '' for column 'default' at row 1

QUERY = INSERT INTO CubeCart_Modules (`status`, `default`, `folder`, `module`) VALUES ('0', '', 'Per_Category', 'shipping')

What am I missing?

Thanks