MySQL Causing problem in table items

VORPCORE / VORP_txAdmin

tx Admin recipe for VORPcore

Apache License 2.0

9 stars 28 forks source link

Closed cl3i550n closed 10 months ago

cl3i550n commented 10 months ago

Coluns BLOB, TEXT, GEOMETRY or JSON in the case not have default values '{}' in MySQL.

Possible solution

Option 1

`metadata` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_bin',

Option 2

`metadata` LONGTEXT NOT NULL DEFAULT '{}' COLLATE 'utf8mb4_bin',

outsider31000 commented 10 months ago

The solution is for you to update mariaDB version

outsider31000 commented 10 months ago

That only happens on lower versions.