Add new category issue

[cubehelper]

Hello,

I tried to add a new category by entering a category name and description. I got the following error:

MySQL Error Occured

Error Message:

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

There are no place to set the fields: per_ship, item_ship, item_int_ship and per_int_ship.

I modifed the admin/source/categories/index.inc.php to bypass this issue:

$record["per_ship"] = $db->mySQLSafe( !isset($_POST['per_ship']) ? 0.0 : $_POST['per_ship']);

$record["item_ship"] = $db->mySQLSafe( !isset($_POST['item_ship']) ? 0.0 : $_POST['item_ship']);

$record["item_int_ship"] = $db->mySQLSafe( !isset($_POST['item_int_ship']) ? 0.0 : $_POST['item_int_ship']);

$record["per_int_ship"] = $db->mySQLSafe( !isset($_POST['per_int_ship']) ? 0.0 : $_POST['per_int_ship']);

Please advise

[Guest hennaboy]

New install or upgrade?

[Al Brookbanks]

This is because you have MySQL 5 in strict mode. Once strict mode is off it should work.

We will turn it on our our development server so that it is strict compatible in the future.