Hi all, below my error since i upgrade Ocotbercms to vewrsion 471 "SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column sitessin_sopranacollection.ssinlab_inventory_products.sell_id at row 1 (SQL: update ssinlab_inventory_products set buy_price = 3, sell_id = , sell_price = 0, updated_at = 2021-04-07 14:44:36 where id = 5061)" on line 664 of /var/www/sopranacollection.it/vendor/laravel/framework/src/Illuminate/Database/Connection.php

The only thing i can see is that there are no quotes on all values but I'm not sure if this is the error or this is the way log logger save the sql code. By the way, when i add manually quotes on the database, the query works.

Could you help me?

This error suggests that you should make the sell_id column NULLABLE inside your database.

Here is some code that should do it

Db::select("ALTER TABLE `ssinlab_inventory_products` CHANGE COLUMN `sell_id` `sell_id` INT(10) UNSIGNED NULL;");