search

plenta / contao-jobs-basic-bundle

Contao Job Manager
https://plenta.io/contao-erweiterungen/jobs-basic
GNU Lesser General Public License v3.0
20 stars 6 forks source link

Do not add CHARACTER SET for column type JSON #119

Open akroii opened 10 months ago

akroii commented 10 months ago

Hi all, when you create a database dump via vendor/bin/contao-console contao:backup:create it will contain a complete backup of all tables. But when you import this backup there are a lot of issues:

#1064 - Fehler in der SQL-Syntax. Bitte die korrekte Syntax im Handbuch nachschlagen bei 'CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, `author` INT...' in Zeile 1

tl_plenta_jobs_basic_offer Do not Work: employmentType` JSON CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci

Works: employmentType` JSON DEFAULT NULL COLLATE `utf8mb4_unicode_ci

tl_plenta_jobs_basic_settings_employment_type Do not work: translation` JSON CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci

Works: translation` JSON DEFAULT NULL COLLATE `utf8mb4_unicode_ci

I'm working locally with ddev and phpmyadmin Contao 4.13.29 Jobs Basic 2.4.8