hi, please please can someone help..
currently using zencart 1.3.9 and stock by attribute 1.4.14. everything seems to be working fine until we try to add the quantity to a product variant. once we enter in the quantity and click submit we are given this error message

1364 Field 'sort' doesn't have a default value
in:
[insert into `products_with_attributes_stock` (`products_id`,`stock_attributes`,`quantity`) values (486,"1577",2) ON DUPLICATE KEY UPDATE `stock_attributes` = "1577", `quantity` = 2]
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.

another error message for when we select to sync all quantities.

1265 Data truncated for column 'products_quantity' at row 1
in:
[update products set products_quantity="" where products_id="71"]
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.

any help would be much appreciated as we are currently unable to update our stock count.