Failed to update category.

[Guest Mask 9000]

Dear All

I've added an additional field in the database table 'CubeCart_inventory' called 'collectionsyn' which stores values in INTEGER format. It stores values either as 1 or 0 and 0 being a default value.

It is basically for checking whether the product is a collection or no.

Similiarly I've added the field on Administrator - > Add Product ->

<input type="checkbox" name="collectionsyn" id="collectionsyn" value="<?php if(isset($results[0]['collectionsyn'])) echo $results[0]['collectionsyn']; ?>" <?php if(isset($results[0]['collectionsyn']) && $results[0]['collectionsyn']==1) echo "Checked" ?>>

add added in the code:

$record["collectionsyn"] = $db->mySQLSafe($_POST['collectionsyn']);

While adding it works fine. But when I edit it, it gives me the error only on when I check the check box or uncheck the check box of the field 'collectionsyn'

Failed to update category.

I tried to check whether I need to mention it anywhere?

Please let me know how I can get this fixed

Thanks & Regards

Yusuf