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

[nunos]

Hi everyone,

I am having a problem importing the database of an EspoCRM instalation.

Export via PhPMyadmin and Import via PhPMyadmin.

Several #1101 errors are being displayed:

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

EspoCRM v8.1 / PhP 8.1 / MySql 8.0.37

Anyone with the same problem?

Thanks,

NunoS

Note: I have seen now that the database on the old server was in Server version 10.6.13-MariaDB format, can it be the problem?

[yuri]

> old server was in Server version 10.6.13-MariaDB format, can it be the problem?

Yes. It seem is the reason. MariaDB supports defaults in TEXT columns, MySQL does not.

[yuri]

Maybe consider opting back to MariaDB. EspoCRM works faster with MariaDB.

[nunos]

Thanks Yuri,

I am going to ask the hosting provider to install MariaDB instead of MySql.

Anyway the strange thing is that i had already migrate another account / database / website to a new server with the same specifications (MariaBD to MySql) without any problem.

The only difference with this one is that the Real Estate extension is installed in this new migration.

NunoS