For Some Reason i get an error when running this .sql script.
Inventory LONGTEXT NOT NULL DEFAULT '{}',
error:
Error Code: 1101. BLOB, TEXT, GEOMETRY or JSON column 'Inventory' can't have a default value
Any suggestion would be great.
Already followed the suggestions in the comments section regarding "Remove STRICT_TRANS_TABLES from your sql_mode", unfortunately this made no difference.
Perhaps running the wrong mysql version?
Ver 8.0.23-0ubuntu0.20.10.1 for Linux on x86_64 ((Ubuntu))
Zip file contains .sql contained in Git Release.
zombieoutbreak.zip
EDIT: Downgraded to MySQL 5.6 (on ubuntu20.04)
SQL file still results in this error although the login through mysql-async is running now.
For Some Reason i get an error when running this .sql script.
LONGTEXT NOT NULL DEFAULT '{}',error:
Any suggestion would be great.
Already followed the suggestions in the comments section regarding "Remove STRICT_TRANS_TABLES from your sql_mode", unfortunately this made no difference.
Perhaps running the wrong mysql version?
Ver 8.0.23-0ubuntu0.20.10.1 for Linux on x86_64 ((Ubuntu))
Zip file contains .sql contained in Git Release.
zombieoutbreak.zip
EDIT: Downgraded to MySQL 5.6 (on ubuntu20.04)
SQL file still results in this error although the login through mysql-async is running now.