How to fix ERROR 1101 (42000) at line 123: BLOB, TEXT, GEOMETRY or JSON column ‘whatever’ can’t have a default value

It’s probably a TEXT column with a default. For example, do this:

user@example:~$ ssh -p 22 [email protected] “MYSQL_PWD=’OwMewBIaeut2fHRVrwoB’ mysql -u db_user db_name -e \”ALTER TABLE tasks MODIFY COLUMN status TEXT;\””