Bench upgrade error: _mysql_exceptions.OperationalError: (1048, "Column 'in_dialog' cannot be null")

[Krishna_Das]

Hi,

You can try this:

cd ~/frappe-bench
bench --site sitename mysql
ALTER TABLE tabDocType MODIFY COLUMN in_dialog int(1) NULL;

Then run bench update.

After that you can change the previous mysql command as before:

ALTER TABLE tabDocType MODIFY COLUMN in_dialog int(1) NOT NULL DEFAULT 1;