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

I am trying to upload mysql database from local to production server. I am getting this error.

Any help ?

Best Answer

Level 75

Also check the mysql version host is using.

1 like

Level 5

@jlrdw Thanks for sharing.

I finally upgraded mysql 5.7 on my server to latest version of MariaDB 10.3 and it solved the issues.

Thanks.

Please or to participate in this conversation.