Mysql error BLOB, TEXT, GEOMETRY or JSON colum cant have default value

Question

My vps linux ubuntu is Server type: MySQL Server version: 5.7.33 ubuntu0.18.04.1 - (Ubuntu) Apache/2.4.29 (Ubuntu) Database client version: libmysql - mysqlnd 5.0.12-dev - 20150407 - PHP version: 7.2.24-

Trying to add a column in my database but im getting error I tried that on windows xampp its work without any problem

ALTER TABLE users ADD COLUMN house LONGTEXT NOT NULL DEFAULT '{"owns":false,"furniture":[],"houseId":0}';

Error

SQL query:


ALTER TABLE users ADD COLUMN house LONGTEXT NOT NULL DEFAULT '{"owns":false,"furniture":[],"houseId":0}'
MySQL said: Documentation

#1101 - BLOB, TEXT, GEOMETRY or JSON column 'house' can't have a default value

Answer 1

Remove the default value:

ALTER TABLE users ADD COLUMN house LONGTEXT NOT NULL;