1101 - BLOB, TEXT, GEOMETRY or JSON column 'buddylist' can't have a default value
1101 - BLOB, TEXT, GEOMETRY or JSON column 'buddylist' can't have a default value
Hello,
During one query im getting following error:
1101 - BLOB, TEXT, GEOMETRY or JSON column 'buddylist' can't have a default value
then i added
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
at end of mysql.cnf, but problem still exist, how to fix it?
During one query im getting following error:
1101 - BLOB, TEXT, GEOMETRY or JSON column 'buddylist' can't have a default value
then i added
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
at end of mysql.cnf, but problem still exist, how to fix it?