Problem bei Wechsel der Datenbank von MySQL zu MariaDB

Hallo,

ich habe eine Webseite bei Ionos und aufgrund von Performanceproblemen die PHP-Version und die Datenbank gewechselt in der Hoffnung auf Besserung (erster Seitenaufruf war langsam, da gibt es hier ja einige Themen dazu).

Ich habe jetzt die aktuelle PHP Version 8.x sowie von einer 5er MySQL zu einer MariaDB 10.5 gewechselt. (Contao 4.13.2)

Die alte Datenbank habe ich gemäß Contao-Anleitung mit PHP-Myadmin exportiert und in MariaDB via PHP-MyAdmin importiert. Soweit alles ohne Fehlermeldungen. Anschließend habe ich im Contao-Manager beide Symfony-Caches neu bauen lassen und das Install-Tool aufgerufen. Dort erhalte ich viele Änderungsvorschläge bei der Datenbank:

Code:

ALTER TABLE tl_remember_me CHANGE expires expires DATETIME DEFAULT NULL ALTER TABLE tl_trusted_device CHANGE device_family device_family VARCHAR(255) DEFAULT NULL ALTER TABLE tl_trusted_device CHANGE os_family os_family VARCHAR(255) DEFAULT NULL ALTER TABLE tl_trusted_device CHANGE ua_family ua_family VARCHAR(255) DEFAULT NULL ALTER TABLE tl_trusted_device CHANGE userClass userClass VARCHAR(255) DEFAULT NULL ALTER TABLE tl_article CHANGE stop stop VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE start start VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE published published CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE cssID cssID VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE guests guests CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE protected protected CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE customTpl customTpl VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE printable printable VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE teaserCssID teaserCssID VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE showTeaser showTeaser CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE inColumn inColumn VARCHAR(32) DEFAULT 'main' NOT NULL ALTER TABLE tl_article CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin` ALTER TABLE tl_article CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_calendar CHANGE disableCaptcha disableCaptcha CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar CHANGE requireLogin requireLogin CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar CHANGE bbcode bbcode CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar CHANGE moderate moderate CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar CHANGE sortOrder sortOrder VARCHAR(32) DEFAULT 'ascending' NOT NULL ALTER TABLE tl_calendar CHANGE notify notify VARCHAR(32) DEFAULT 'notify_admin' NOT NULL ALTER TABLE tl_calendar CHANGE allowComments allowComments CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar CHANGE protected protected CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE stop stop VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE start start VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE published published CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE noComments noComments CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE cssClass cssClass VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE target target CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE url url VARCHAR(2048) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE source source VARCHAR(32) DEFAULT 'default' NOT NULL ALTER TABLE tl_calendar_events CHANGE addEnclosure addEnclosure CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE repeatEach repeatEach VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE recurring recurring CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE floating floating VARCHAR(32) DEFAULT 'above' NOT NULL ALTER TABLE tl_calendar_events CHANGE caption caption VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE fullsize fullsize CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE imageUrl imageUrl VARCHAR(2048) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE imagemargin imagemargin VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE size size VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE imageTitle imageTitle VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE alt alt VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE singleSRC singleSRC BINARY(16) DEFAULT NULL ALTER TABLE tl_calendar_events CHANGE overwriteMeta overwriteMeta CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE addImage addImage CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE address address VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE location location VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE robots robots VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE pageTitle pageTitle VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE addTime addTime CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin` ALTER TABLE tl_calendar_events CHANGE featured featured CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_feed CHANGE imgSize imgSize VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_feed CHANGE feedBase feedBase VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_feed CHANGE source source VARCHAR(32) DEFAULT 'source_teaser' NOT NULL ALTER TABLE tl_calendar_feed CHANGE format format VARCHAR(32) DEFAULT 'rss' NOT NULL ALTER TABLE tl_calendar_feed CHANGE language language VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_feed CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin` ALTER TABLE tl_calendar_feed CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_comments CHANGE notifiedReply notifiedReply CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_comments CHANGE notified notified CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_comments CHANGE ip ip VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_comments CHANGE published published CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_comments CHANGE addReply addReply CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_comments CHANGE website website VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_comments CHANGE email email VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_comments CHANGE name name VARCHAR(64) DEFAULT '' NOT NULL

Dies ist nur ein kurzer Ausschnitt und geht bis tl_versions...

Das Installtool bricht dann mit einem Fehler ab - in den Logs steht folgendes:

Code:

request.INFO: Matched route "contao_install". {"route":"contao_install","route_parameters":{"_route":"contao_install","_scope":"backend","_token_check":true,"_controller":"Contao\\InstallationBundle\\Controller\\InstallationController::installAction"},"request_uri":"https://cms.antenne-langewiesen.de/contao/install","method":"POST"} [] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\SyntaxErrorException: "An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows rows VARCHAR(8) DEFAULT '2rwh' NOT NULL' at line 1" at /homepages/26/dXXXXX/htdocs/cms/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 88 {"exception":"[object] (Doctrine\\DBAL\\Exception\\SyntaxErrorException(code: 1064): An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows rows VARCHAR(8) DEFAULT '2rwh' NOT NULL' at line 1 at /homepages/26/dXXXXX/htdocs/cms/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:88)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1064): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows rows VARCHAR(8) DEFAULT '2rwh' NOT NULL' at line 1 at /homepages/26/dXXXXXX/htdocs/cms/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:30)\n[previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows rows VARCHAR(8) DEFAULT '2rwh' NOT NULL' at line 1 at /homepages/26/dXXXXX/htdocs/cms/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:34)"} []

Frontend scheint zu funktionieren - sauber ist das aber trotzdem nicht.

Woran könnte das liegen und was kann ich hier machen?

Vielen Dank

... kann ich noch Infos beitragen, die bei der Problemlösung helfen könnten? ...
Es sind lediglich Erweiterungen von Rocksolid installiert, die zum Theme benötigt werden (sowie das Rocksolid Antispam-Modul) - Beim Datenbankwechsel wurde daran nichts geändert...

Nutze den Debug-Modus und poste den Stack Trace.

Doctrine\DBAL\Exception\SyntaxErrorException:
An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows rows VARCHAR(8) DEFAULT '2rwh' NOT NULL' at line 1

at vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:88
at Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(object(Exception), object(Query))
(vendor/doctrine/dbal/src/Connection.php:1814)
at Doctrine\DBAL\Connection->handleDriverException(object(Exception), object(Query))
(vendor/doctrine/dbal/src/Connection.php:1749)
at Doctrine\DBAL\Connection->convertExceptionDuringQuery(object(Exception), 'ALTER TABLE tl_layout CHANGE rows rows VARCHAR(8) DEFAULT \'2rwh\' NOT NULL', array(), array())
(vendor/doctrine/dbal/src/Connection.php:1163)
at Doctrine\DBAL\Connection->executeStatement('ALTER TABLE tl_layout CHANGE rows rows VARCHAR(8) DEFAULT \'2rwh\' NOT NULL')
(vendor/contao/installation-bundle/src/Database/Installer.php:84)
at Contao\InstallationBundle\Database\Installer->execCommand('b34869159a36062da3a9e410369e0e38')
(vendor/contao/installation-bundle/src/Controller/InstallationController.php:390)
at Contao\InstallationBundle\Controller\InstallationC ontroller->adjustDatabaseTables()
(vendor/contao/installation-bundle/src/Controller/InstallationController.php:100)
at Contao\InstallationBundle\Controller\InstallationC ontroller->installAction()
(vendor/symfony/http-kernel/HttpKernel.php:152)
at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
(vendor/symfony/http-kernel/HttpKernel.php:74)
at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
(vendor/symfony/http-kernel/Kernel.php:202)
at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
(public/index.php:44)

Doctrine\DBAL\Exception\ SyntaxErrorException
in vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php (line 88)
in vendor/doctrine/dbal/src/Connection.php -> convert (line 1814)
in vendor/doctrine/dbal/src/Connection.php -> handleDriverException (line 1749)
in vendor/doctrine/dbal/src/Connection.php -> convertExceptionDuringQuery (line 1163)
in vendor/contao/installation-bundle/src/Database/Installer.php -> executeStatement (line 84)
in vendor/contao/installation-bundle/src/Controller/InstallationController.php -> execCommand (line 390)
in vendor/contao/installation-bundle/src/Controller/InstallationController.php -> adjustDatabaseTables (line 100)
in vendor/symfony/http-kernel/HttpKernel.php -> installAction (line 152)
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)
in vendor/symfony/http-kernel/Kernel.php -> handle (line 202)
Kernel->handle(object(Request)) in public/index.php (line 44)

$loader = require __DIR__.'/../vendor/autoload.php';
$request = Request::createFromGlobals();
$kernel = ContaoKernel::fromRequest(dirname(__DIR__), $request);
$response = $kernel->handle($request);
$response->send();
if ($kernel instanceof TerminableInterface) {
$kernel->terminate($request, $response);
}

Doctrine\DBAL\Driver\PDO\ Exception

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows rows VARCHAR(8) DEFAULT '2rwh' NOT NULL' at line 1
in vendor/doctrine/dbal/src/Driver/PDO/Exception.php (line 30)
in vendor/doctrine/dbal/src/Driver/PDO/Connection.php :: new (line 40)
in vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php -> exec (line 47)
in vendor/doctrine/dbal/src/Logging/Connection.php -> exec (line 53)
in vendor/doctrine/dbal/src/Connection.php -> exec (line 1161)
in vendor/contao/installation-bundle/src/Database/Installer.php -> executeStatement (line 84)
in vendor/contao/installation-bundle/src/Controller/InstallationController.php -> execCommand (line 390)
in vendor/contao/installation-bundle/src/Controller/InstallationController.php -> adjustDatabaseTables (line 100)
in vendor/symfony/http-kernel/HttpKernel.php -> installAction (line 152)
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)
in vendor/symfony/http-kernel/Kernel.php -> handle (line 202)
Kernel->handle(object(Request)) in public/index.php (line 44)

$loader = require __DIR__.'/../vendor/autoload.php';
$request = Request::createFromGlobals();
$kernel = ContaoKernel::fromRequest(dirname(__DIR__), $request);
$response = $kernel->handle($request);
$response->send();
if ($kernel instanceof TerminableInterface) {
$kernel->terminate($request, $response);
}

Und das passiert mit Contao 4.13.4? Welche PHP Version?

PHP 8.0.18, aber Contao 4.13.2 (laut Contao Manager aktuell: "Neuste Version: 4.13.2 (veröffentlicht am 31. März 2022 um 16:53)")

Die neueste Verison ist 4.13.4. Führe mal eine komplette Paketaktualisierung durch.

Ich habe jetzt einmal auf aktualisieren geklickt und habe nun 4.13.4 installiert. Das Problem bleibt bestehen.

Komischerweise zeigt mit der Contao Manager nun an, dass ein Update vorhanden sei auf die 4.13.2 - das verstehe ich nicht:eek:

Zitat:

Zitat von Multer

Komischerweise zeigt mit der Contao Manager nun an, dass ein Update vorhanden sei auf die 4.13.2 - das verstehe ich nicht:eek:

Geduld haben ;). Contao 4.13.3 und 4.13.4 wurden erst heute vor kurzem veröffentlicht. Es dauert einige Zeit, bis dass der Cache für die Paketversionen aktualisiert ist.

.. habe alles aktualisiert und Prod.-Cache, Dev.-Cache sowie Composer-Cache geleert.

Der Fehler bleibt erhalten, hier nochmal das aktuelle Trace:

Doctrine\DBAL\Exception\SyntaxErrorException:
An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows rows VARCHAR(8) DEFAULT '2rwh' NOT NULL' at line 1

at vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:88
at Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(object(Exception), object(Query))
(vendor/doctrine/dbal/src/Connection.php:1814)
at Doctrine\DBAL\Connection->handleDriverException(object(Exception), object(Query))
(vendor/doctrine/dbal/src/Connection.php:1749)
at Doctrine\DBAL\Connection->convertExceptionDuringQuery(object(Exception), 'ALTER TABLE tl_layout CHANGE rows rows VARCHAR(8) DEFAULT \'2rwh\' NOT NULL', array(), array())
(vendor/doctrine/dbal/src/Connection.php:1163)
at Doctrine\DBAL\Connection->executeStatement('ALTER TABLE tl_layout CHANGE rows rows VARCHAR(8) DEFAULT \'2rwh\' NOT NULL')
(vendor/contao/installation-bundle/src/Database/Installer.php:84)
at Contao\InstallationBundle\Database\Installer->execCommand('b34869159a36062da3a9e410369e0e38')
(vendor/contao/installation-bundle/src/Controller/InstallationController.php:390)
at Contao\InstallationBundle\Controller\InstallationC ontroller->adjustDatabaseTables()
(vendor/contao/installation-bundle/src/Controller/InstallationController.php:100)
at Contao\InstallationBundle\Controller\InstallationC ontroller->installAction()
(vendor/symfony/http-kernel/HttpKernel.php:152)
at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
(vendor/symfony/http-kernel/HttpKernel.php:74)
at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
(vendor/symfony/http-kernel/Kernel.php:202)
at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
(public/index.php:44)

Hi,

das Problem der Fehlermeldung ist eventuell das nicht escapte reservierte Wort 'rows' (seit MariaDB 10.2.4). Ob Contao das automatisch escapen sollte, weiß ich leider nicht.

Viele Grüße
René

... kann ich das irgendwie beheben oder müssen die Contao-Entwickler ran? ...

Das würde ja bedeuten, dass jeder ab MariaDB 10.2.x dieses Problem haben sollte - ich kann bei Ionos nur MySQL 5.X oder diese MariaDB-Version auswählen, demzufolge bin ich ja bestimmt nicht allein damit?

Bei mir unter MariaDB 10.6 tritt das jedenfalls nicht auf.

Hmm... was kann ich nun machen um das Problem zu lösen? Bin leider ratlos.

Im Contao Core wurde das Problem m.E. gefixt https://github.com/contao/core-bundle/issues/918
Vielleicht kommt das aus einer Erweiterung.

Zitat:

Zitat von mlweb

Vielleicht kommt das aus einer Erweiterung.

Laut Stack Trace eigentlich nicht.

Stimmt, Du hast recht, aber ist das Problem nicht eigentlich mit dem oben verlinkten Ticket gelöst worden? Warum taucht das dann jetzt wieder auf.

Keine Ahnung - theoretisch wird das von Doctrine auto-escaped.

.. was heißt das für mich und was kann ich ggf. machen ...

Liest Herr Feyer hier auch mit?

Zitat:

Zitat von Multer

.. was heißt das für mich und was kann ich ggf. machen ...

Aktuell weiß ich nicht was du machen könntest. Du könntest bezahlten Support über das Contao Partner Programm suchen: https://contao.org/de/contao-partner.html

Zitat:

Zitat von Multer

Liest Herr Feyer hier auch mit?

Vermutlich nicht ;)

Naja, Frage wäre, ob ich noch ein Bugreport separat eröffnen muss oder ob der Eintrag hier ausreicht, um Nachforschungen ggf. seitens der Entwickler zu erreichen.

Bezahlten Support könnte ich darüber nachdenken, da aber scheinbar Contao-Plain in dieser Konstellation schon die Probleme verursacht, kann eine Serviceagentur sicherlich auch nicht viel daran ausrichten. Und selbst wenn ich die gewünschten SQL-Änderungen irgendwie manuell erwirken könnte (es sind aber fast 3000 Zeilen (je 3 Leerzeile bei Copy-Paste aus dem Install-Tool - also bleiben ca. 1000 Zeilen übrig), hätte ich bei der nächsten wirklichen Datenbankänderung sicherlich wieder die selben Probleme.

Was wäre die richtige Herangehensweise?

... habe gerade alle Extensions deinstalliert - Problem bleibt bestehen ...

Ich reinstalliere jetzt wieder die Rocksolid-Erweiterungen.

Zitat:

Zitat von Multer

kann eine Serviceagentur sicherlich auch nicht viel daran ausrichten

Warum nicht?

... zaubern die am Quellcode oder am Framework ? ...

Die Agentur analysiert das Problem. Der Quellcode ist offen und die Agentur kann dann entsprechende Maßnahmen setzen. Das kann auch ein Pull Request bei Contao sein, falls ein Problem bei Contao gefunden wird. Oder ein Pull Request bei Doctrine, falls ein Problem bei Doctrine gefunden wird.

Okay,
... ich hatte jedoch gehofft, dass ich das auch gemeinsam mit der interessierten Community schaffe.

Ich liefere gern jede Art von Debug-Informationen bzw. probiere auch Dinge aus - ansonsten bleibt für mich als durchaus fachkundige Person im IT-Bereich (jedoch mit wenig Erfahrung im Contao-Umfeld) ein fader Beigeschmack, wenn noch nicht einmal ein einfacher Datenbankwechsel problemfrei abläuft. Und Ionos ist im deutschsprachigen Raum nicht gerade ein unbekannter Hoster ;)

Normalerweise würde ich vor dem Live-Einsatz auch nochmal ein Komplett-Backup sowie Restore auf neuer Subdomain mit neuer Datenbank und neuem Webspace probieren - hier hapert es aber schon am ersten Mini-Schritt (also ich bin noch lange nicht beim Backup/Restore Probelauf sondern wollte nur die Datenbankverision und PHP-Version auf einen aktuellen Stand heben).

Bin deswegen für jede Hilfe dankbar.

Aktuell habe ich leider keine Idee. Das was ich nun machen würde ist: debuggen, warum nicht escaped wird.

... würde ich gern machen, gibt es eine Handreichung, wie dies am besten geht oder bin ich da mit Ionos Hosting ohne SSH-Zugang schon raus?

Zitat:

Zitat von Multer

... würde ich gern machen, gibt es eine Handreichung, wie dies am besten geht

Dafür wäre dann die Agentur da ;)

Zitat:

Zitat von Multer

oder bin ich da mit Ionos Hosting ohne SSH-Zugang schon raus?

Bei IONOS hast du SSH Zugang.

Zitat:

Zitat von Spooky

Dafür wäre dann die Agentur da ;)

Ich hätte da auf Community-Hilfe gehofft ;) - ich möchte jetzt niemanden auf den Schlips treten, aber scheinbar ist es dann doch nicht gewollt.

Zitat:

Zitat von Spooky

Bei IONOS hast du SSH Zugang.

Habe ich jetzt auch gerade bei den FTP-Zugängen gefunden. Ionos ist nicht mein Haus&Hof Hoster, normalerweise nehme ich gern all-inkl, und dort gibt es das erst ab einem bestimmten Paket.

Mit einer guten Handbuchseite oder Tutorial würde ich es mit dem Debugging auch probieren ...

Zitat:

Zitat von Multer

Ich hätte da auf Community-Hilfe gehofft ;) - ich möchte jetzt niemanden auf den Schlips treten, aber scheinbar ist es dann doch nicht gewollt.

Nicht alle Probleme lassen sich in der Community lösen. Das hat nichts mit "nicht gewollt" zu tun.
Lass Dir gesagt sein - wenn @Spooky hier keine spontane Idee hat, wo man suchen soll, dann will das etwas heißen.

Das Problem was Du hast ist m.E. kein allgemeines Problem von Contao, sonst wäre uns das in der Vergangenheit schon häufiger auf die Füße gefallen.
Wie schon von @Spooky erwähnt müsste das eigentlich von Doctrine auto-escaped werden.

Warum das bei Dir nicht der Fall ist, muss man untersuchen.
Eine solche Untersuchung eines wahrscheinlich individuellen Problems ist sehr aufwendig und sicher nicht ohne Blick in Deine Installation machbar.

Zitat:

Zitat von Multer

Mit einer guten Handbuchseite oder Tutorial würde ich es mit dem Debugging auch probieren ...

Informationen zum Problem würde ich bei Doctrine und/oder Symfony suchen.

Ich kenne Deinen fachlichen Hintergrund nicht. Meine Kenntnisse als Frontendentwickler würden dazu nicht reichen.

... Problem scheint gelöst ...

Ich habe jetzt nochmal alle Caches (incl. Composer Caches, Composer-Class-Loader) gelöscht, obwohl ich dies schon einmal gemacht hatte. Anschließend habe ich den Composer (Composer-Abhängigkeiten) nochmals zwangsweise geupdated (hatte ich zwar anfänglich schoneinmal gemacht, da hatte ich aber die Composer-Caches noch nicht gelöscht).

Nun zeigt das Installtool nur noch 5 Änderungen an, die jetzt auch reibungslos durchlaufen.

Keine Ahnung, was da jetzt quer gehangen hat - vielleicht hilft dies aber nochmal jemand anderem;)

Hmm, ich habe dieselben Auswirkungen auf die Datenbank, allerdings aus einem anderen Kontext: Beim Umzug einer lokalen Installation (MySQL 5.7.34) auf einen Webserver (MariaDB 10.3.34) bricht der Datenbank-Import via phpmyadmin mit einer 504-Fehlermeldung ab. Importiere ich die Datenbank via Konsole, erhalte ich zwar keine Fehlermeldung, aber beim Aufruf des Installations-Tools dieselben Aktualisierungen

Code:

Spalten ändern Alle auswählen ALTER TABLE tl_trusted_device CHANGE device_family device_family VARCHAR(255) DEFAULT NULL ALTER TABLE tl_trusted_device CHANGE os_family os_family VARCHAR(255) DEFAULT NULL ALTER TABLE tl_trusted_device CHANGE ua_family ua_family VARCHAR(255) DEFAULT NULL ALTER TABLE tl_trusted_device CHANGE userClass userClass VARCHAR(255) DEFAULT NULL ALTER TABLE tl_remember_me CHANGE expires expires DATETIME DEFAULT NULL ALTER TABLE tl_article CHANGE background background CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE bgcolor bgcolor VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE bgimage bgimage VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE bgposition bgposition VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE bgrepeat bgrepeat VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE bgsize bgsize VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE size size VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE bgcolor_css bgcolor_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE overlay overlay CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE ol_position ol_position VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE ol_width ol_width VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE ol_height ol_height VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE ol_bgcolor_css ol_bgcolor_css VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE ol_opacity ol_opacity VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE fullscreen fullscreen CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE offsetCssID offsetCssID VARCHAR(196) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE layout_css layout_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE color_css color_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE padding_t padding_t VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE padding_b padding_b VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE visibility_css visibility_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE stop stop VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE start start VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE published published CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE cssID cssID VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE guests guests CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE protected protected CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE customTpl customTpl VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE printable printable VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE teaserCssID teaserCssID VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE showTeaser showTeaser CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE inColumn inColumn VARCHAR(32) DEFAULT 'main' NOT NULL ALTER TABLE tl_article CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin` ALTER TABLE tl_article CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_calendar CHANGE disableCaptcha disableCaptcha CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar CHANGE requireLogin requireLogin CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar CHANGE bbcode bbcode CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar CHANGE moderate moderate CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar CHANGE sortOrder sortOrder VARCHAR(32) DEFAULT 'ascending' NOT NULL ALTER TABLE tl_calendar CHANGE notify notify VARCHAR(32) DEFAULT 'notify_admin' NOT NULL ALTER TABLE tl_calendar CHANGE allowComments allowComments CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar CHANGE protected protected CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE stop stop VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE start start VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE published published CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE noComments noComments CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE cssClass cssClass VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE target target CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE url url VARCHAR(2048) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE source source VARCHAR(32) DEFAULT 'default' NOT NULL ALTER TABLE tl_calendar_events CHANGE addEnclosure addEnclosure CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE repeatEach repeatEach VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE recurring recurring CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE floating floating VARCHAR(32) DEFAULT 'above' NOT NULL ALTER TABLE tl_calendar_events CHANGE caption caption VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE fullsize fullsize CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE imageUrl imageUrl VARCHAR(2048) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE imagemargin imagemargin VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE size size VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE imageTitle imageTitle VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE alt alt VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE singleSRC singleSRC BINARY(16) DEFAULT NULL ALTER TABLE tl_calendar_events CHANGE overwriteMeta overwriteMeta CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE addImage addImage CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE address address VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE location location VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE robots robots VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE pageTitle pageTitle VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE addTime addTime CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin` ALTER TABLE tl_calendar_events CHANGE featured featured CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_feed CHANGE imgSize imgSize VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_feed CHANGE feedBase feedBase VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_feed CHANGE source source VARCHAR(32) DEFAULT 'source_teaser' NOT NULL ALTER TABLE tl_calendar_feed CHANGE format format VARCHAR(32) DEFAULT 'rss' NOT NULL ALTER TABLE tl_calendar_feed CHANGE language language VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_feed CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin` ALTER TABLE tl_calendar_feed CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_cms_content_group CHANGE always_use_this always_use_this CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_cms_content_group CHANGE name name VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_cms_content_group CHANGE type type VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_cms_conversion_item CHANGE name name VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_cms_link_shortener CHANGE fallback fallback VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_cms_link_shortener CHANGE stop stop VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_cms_link_shortener CHANGE active active CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_cms_link_shortener CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_cms_link_shortener CHANGE prefix prefix VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_cms_link_shortener CHANGE domain domain VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_cms_link_shortener CHANGE group_name group_name VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_cms_link_shortener CHANGE target target VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_cms_link_shortener_statistics CHANGE is_bot is_bot VARCHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_cms_link_shortener_statistics CHANGE is_mobile is_mobile VARCHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_cms_link_shortener_statistics CHANGE browser browser VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_cms_link_shortener_statistics CHANGE os os VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_cms_link_shortener_statistics CHANGE user_agent user_agent VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_cms_link_shortener_statistics CHANGE unique_id unique_id VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_cms_link_shortener_statistics CHANGE referer referer VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_cms_marketing_item CHANGE active active CHAR(1) DEFAULT '1' NOT NULL ALTER TABLE tl_cms_marketing_item CHANGE always_page_b always_page_b CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_cms_marketing_item CHANGE page_b page_b VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_cms_marketing_item CHANGE always_page_a always_page_a CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_cms_marketing_item CHANGE page_a page_a VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_cms_marketing_item CHANGE stop_auto_winner stop_auto_winner VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_cms_marketing_item CHANGE auto_winner_after auto_winner_after CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_cms_marketing_item CHANGE content_type content_type VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_cms_marketing_item CHANGE name name VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_cms_marketing_item CHANGE type type VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_cms_marketing_item CHANGE init_step init_step VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_cms_tag CHANGE enable_on_cookie_accept enable_on_cookie_accept CHAR(1) DEFAULT '1' NOT NULL ALTER TABLE tl_cms_tag CHANGE active active CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_cms_tag CHANGE pages_scope pages_scope VARCHAR(64) DEFAULT 'current_and_all_children' NOT NULL ALTER TABLE tl_cms_tag CHANGE customTpl customTpl VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_cms_tag CHANGE fallbackTpl fallbackTpl VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_cms_tag CHANGE alias alias VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_cms_tag CHANGE anonymize_ip anonymize_ip CHAR(1) DEFAULT '1' NOT NULL ALTER TABLE tl_cms_tag CHANGE matomo_siteid matomo_siteid VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_cms_tag CHANGE matomo_url matomo_url VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_cms_tag CHANGE tag tag VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_cms_tag CHANGE name name VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_cms_tag CHANGE type type VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_comments CHANGE notifiedReply notifiedReply CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_comments CHANGE notified notified CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_comments CHANGE ip ip VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_comments CHANGE published published CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_comments CHANGE addReply addReply CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_comments CHANGE website website VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_comments CHANGE email email VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_comments CHANGE name name VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_comments CHANGE date date VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_comments CHANGE source source VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_comments_notify CHANGE tokenRemove tokenRemove VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_comments_notify CHANGE active active CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_comments_notify CHANGE addedOn addedOn VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_comments_notify CHANGE url url VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_comments_notify CHANGE email email VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_comments_notify CHANGE name name VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_comments_notify CHANGE source source VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE cta_title cta_title VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE cta_link cta_link VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE cms_mi_pages_criteria cms_mi_pages_criteria VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE cms_mi_label cms_mi_label VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE cms_mi_isMainTracker cms_mi_isMainTracker CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE cms_tag_visibility cms_tag_visibility CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE cms_tag_fallback_css_class cms_tag_fallback_css_class VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE cms_layout_option cms_layout_option VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE cms_lifetime cms_lifetime VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE cms_pages_scope cms_pages_scope VARCHAR(64) DEFAULT 'none' NOT NULL ALTER TABLE tl_content CHANGE cms_element_style cms_element_style CHAR(1) DEFAULT '1' NOT NULL ALTER TABLE tl_content CHANGE cms_layout_selector cms_layout_selector VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE align_css align_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE color_css color_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE bgcolor_css bgcolor_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE border_css border_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE style_css style_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE format_css format_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE width_css width_css VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE seo seo CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE visibility_css visibility_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid_grid autogrid_grid VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid_bgcolor autogrid_bgcolor VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid_bgimage autogrid_bgimage VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid_bgposition autogrid_bgposition VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid_bgrepeat autogrid_bgrepeat VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid_bgsize autogrid_bgsize VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid_padding autogrid_padding VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid_padding_css autogrid_padding_css VARCHAR(8) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid_styles autogrid_styles VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid_addStyling autogrid_addStyling CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid autogrid CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid_css autogrid_css VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid_mobile autogrid_mobile VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid_tablet autogrid_tablet VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid_offset autogrid_offset VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid_align autogrid_align VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid_align_mobile autogrid_align_mobile VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid_gutter autogrid_gutter VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid_sameheight autogrid_sameheight CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid_class autogrid_class VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE margin_t margin_t VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE margin_b margin_b VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE margin_t_m margin_t_m VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE margin_b_m margin_b_m VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_data_easing revolutionslider_data_easing VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_data_speed revolutionslider_data_speed VARCHAR(8) DEFAULT '0.5' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_data_start revolutionslider_data_start VARCHAR(4) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_data_animation_start revolutionslider_data_animation_start VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_data_animation_end revolutionslider_data_animation_end VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_data_position revolutionslider_data_position VARCHAR(96) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_data_position_m revolutionslider_data_position_m VARCHAR(96) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_data_pos9grid revolutionslider_data_pos9grid VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_data_linktoslide revolutionslider_data_linktoslide VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_data_autoplay revolutionslider_data_autoplay CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_data_nextslideatend revolutionslider_data_nextslideatend CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_OUT revolutionslider_OUT CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_videoType revolutionslider_videoType VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_video_controls revolutionslider_video_controls CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_video_loop revolutionslider_video_loop CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_video_size revolutionslider_video_size VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_video_aspect revolutionslider_video_aspect VARCHAR(8) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_text_bold revolutionslider_text_bold CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_text_italic revolutionslider_text_italic CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_text_fontsize revolutionslider_text_fontsize VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_data_easing_OUT revolutionslider_data_easing_OUT VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_data_speed_OUT revolutionslider_data_speed_OUT VARCHAR(8) DEFAULT '0.5' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_data_start_OUT revolutionslider_data_start_OUT VARCHAR(4) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_frames revolutionslider_frames CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE useSVG useSVG CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_visibility revolutionslider_visibility CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_parallax revolutionslider_parallax CHAR(2) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE privacy_size privacy_size VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE addFontIcon addFontIcon CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE fontIcon fontIcon VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE com_template com_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE com_requireLogin com_requireLogin CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE com_disableCaptcha com_disableCaptcha CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE com_bbcode com_bbcode CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE com_moderate com_moderate CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE com_order com_order VARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE stop stop VARCHAR(10) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE start start VARCHAR(10) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE invisible invisible CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE cssID cssID VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE guests guests CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE protected protected CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE sliderContinuous sliderContinuous CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE playerColor playerColor VARCHAR(6) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE playerPreload playerPreload VARCHAR(8) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE splashImage splashImage CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE playerAspect playerAspect VARCHAR(8) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE playerCaption playerCaption VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE playerSize playerSize VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE posterSRC posterSRC BINARY(16) DEFAULT NULL ALTER TABLE tl_content CHANGE vimeo vimeo VARCHAR(16) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE youtube youtube VARCHAR(16) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE customTpl customTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE galleryTpl galleryTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE metaIgnore metaIgnore CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE sortBy sortBy VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE useHomeDir useHomeDir CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE useImage useImage CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE rel rel VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE embed embed VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE linkTitle linkTitle VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE titleText titleText VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE overwriteLink overwriteLink CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE target target CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE markdownSource markdownSource VARCHAR(12) CHARACTER SET ascii DEFAULT 'sourceText' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE highlight highlight VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE mooClasses mooClasses VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE mooStyle mooStyle VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE mooHeadline mooHeadline VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE sortOrder sortOrder VARCHAR(32) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE sortable sortable CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE tleft tleft CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE tfoot tfoot CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE thead thead CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE summary summary VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE listtype listtype VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE floating floating VARCHAR(32) CHARACTER SET ascii DEFAULT 'above' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE caption caption VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE fullsize fullsize CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE imagemargin imagemargin VARCHAR(128) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE size size VARCHAR(128) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE imageTitle imageTitle VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE alt alt VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE singleSRC singleSRC BINARY(16) DEFAULT NULL ALTER TABLE tl_content CHANGE overwriteMeta overwriteMeta CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE inline inline CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE showPreview showPreview CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE addImage addImage CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE headline headline VARCHAR(255) DEFAULT 'a:2:{s:5:"value";s:0:"";s:4:"unit";s:2:"h2";}' NOT NULL ALTER TABLE tl_content CHANGE ptable ptable VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE type type VARCHAR(128) CHARACTER SET ascii DEFAULT 'text' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_faq CHANGE published published CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_faq CHANGE noComments noComments CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_faq CHANGE addEnclosure addEnclosure CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_faq CHANGE floating floating VARCHAR(12) DEFAULT 'above' NOT NULL ALTER TABLE tl_faq CHANGE caption caption VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_faq CHANGE fullsize fullsize CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_faq CHANGE imageUrl imageUrl VARCHAR(2048) DEFAULT '' NOT NULL ALTER TABLE tl_faq CHANGE imagemargin imagemargin VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_faq CHANGE size size VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_faq CHANGE imageTitle imageTitle VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_faq CHANGE alt alt VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_faq CHANGE singleSRC singleSRC BINARY(16) DEFAULT NULL ALTER TABLE tl_faq CHANGE overwriteMeta overwriteMeta CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_faq CHANGE addImage addImage CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_faq CHANGE robots robots VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_faq CHANGE pageTitle pageTitle VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_faq CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin` ALTER TABLE tl_faq CHANGE question question VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_faq_category CHANGE disableCaptcha disableCaptcha CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_faq_category CHANGE requireLogin requireLogin CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_faq_category CHANGE bbcode bbcode CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_faq_category CHANGE moderate moderate CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_faq_category CHANGE sortOrder sortOrder VARCHAR(12) DEFAULT 'ascending' NOT NULL ALTER TABLE tl_faq_category CHANGE notify notify VARCHAR(16) DEFAULT 'notify_admin' NOT NULL ALTER TABLE tl_faq_category CHANGE allowComments allowComments CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_faq_category CHANGE headline headline VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_faq_category CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_files CHANGE name name VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin` ALTER TABLE tl_files CHANGE found found CHAR(1) DEFAULT '1' NOT NULL ALTER TABLE tl_files CHANGE hash hash VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_files CHANGE extension extension VARCHAR(16) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin` ALTER TABLE tl_files CHANGE path path VARCHAR(1022) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin` ALTER TABLE tl_files CHANGE type type VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_files CHANGE uuid uuid BINARY(16) DEFAULT NULL ALTER TABLE tl_files CHANGE pid pid BINARY(16) DEFAULT NULL ALTER TABLE tl_form CHANGE allowTags allowTags CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_form CHANGE formID formID VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_form CHANGE attributes attributes VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_form CHANGE novalidate novalidate CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_form CHANGE method method VARCHAR(12) DEFAULT 'POST' NOT NULL ALTER TABLE tl_form CHANGE customTpl customTpl VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_form CHANGE targetTable targetTable VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_form CHANGE storeValues storeValues CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_form CHANGE skipEmpty skipEmpty CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_form CHANGE format format VARCHAR(12) DEFAULT 'raw' NOT NULL ALTER TABLE tl_form CHANGE subject subject VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_form CHANGE recipient recipient VARCHAR(1022) DEFAULT '' NOT NULL ALTER TABLE tl_form CHANGE mailerTransport mailerTransport VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_form CHANGE sendViaEmail sendViaEmail CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_form CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin` ALTER TABLE tl_form CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE margin_t margin_t VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE margin_b margin_b VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE margin_t_m margin_t_m VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE margin_b_m margin_b_m VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE autogrid autogrid CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE autogrid_css autogrid_css VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE autogrid_mobile autogrid_mobile VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE autogrid_tablet autogrid_tablet VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE autogrid_offset autogrid_offset VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE autogrid_align autogrid_align VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE autogrid_align_mobile autogrid_align_mobile VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE autogrid_gutter autogrid_gutter VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE autogrid_sameheight autogrid_sameheight CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE autogrid_class autogrid_class VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE visibility_css visibility_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE addFontIcon addFontIcon CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE fontIcon fontIcon VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE invisible invisible CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE singleSRC singleSRC BINARY(16) DEFAULT NULL ALTER TABLE tl_form_field CHANGE imageSubmit imageSubmit CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE slabel slabel VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE customTpl customTpl VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE accesskey accesskey CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE value value VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE class class VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE doNotOverwrite doNotOverwrite CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE useHomeDir useHomeDir CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE uploadFolder uploadFolder BINARY(16) DEFAULT NULL ALTER TABLE tl_form_field CHANGE storeFile storeFile CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE extensions extensions VARCHAR(255) DEFAULT 'jpg,jpeg,gif,png,pdf,doc,docx,xls,xlsx,ppt,pptx' NOT NULL ALTER TABLE tl_form_field CHANGE multiple multiple CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE size size VARCHAR(255) DEFAULT 'a:2:{i:0;i:4;i:1;i:40;}' NOT NULL ALTER TABLE tl_form_field CHANGE step step VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE maxval maxval VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE minval minval VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE errorMsg errorMsg VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE customRgxp customRgxp VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE placeholder placeholder VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE rgxp rgxp VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE mandatory mandatory CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE name name VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE label label VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE type type VARCHAR(64) DEFAULT 'text' NOT NULL ALTER TABLE tl_image_size CHANGE lazyLoading lazyLoading CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_image_size CHANGE skipIfDimensionsMatch skipIfDimensionsMatch CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_image_size CHANGE formats formats VARCHAR(1024) DEFAULT '' NOT NULL ALTER TABLE tl_image_size CHANGE resizeMode resizeMode VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_image_size CHANGE sizes sizes VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_image_size CHANGE densities densities VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_image_size CHANGE cssClass cssClass VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_image_size CHANGE name name VARCHAR(64) DEFAULT NULL ALTER TABLE tl_image_size_item CHANGE invisible invisible CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_image_size_item CHANGE resizeMode resizeMode VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_image_size_item CHANGE sizes sizes VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_image_size_item CHANGE densities densities VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_image_size_item CHANGE media media VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE webfonts_optin webfonts_optin CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE align align VARCHAR(32) DEFAULT 'center' NOT NULL ALTER TABLE tl_layout CHANGE width width VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE static static CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE addMooTools addMooTools CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE addJQuery addJQuery CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE onload onload VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE cssClass cssClass VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE titleTag titleTag VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE viewport viewport VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE defaultImageDensities defaultImageDensities VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE lightboxSize lightboxSize VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE minifyMarkup minifyMarkup CHAR(1) DEFAULT '1' NOT NULL ALTER TABLE tl_layout CHANGE template template VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE combineScripts combineScripts CHAR(1) DEFAULT '1' NOT NULL ALTER TABLE tl_layout CHANGE loadingOrder loadingOrder VARCHAR(16) DEFAULT 'external_first' NOT NULL ALTER TABLE tl_layout CHANGE framework framework VARCHAR(255) DEFAULT 'a:2:{i:0;s:10:"layout.css";i:1;s:14:"responsive.css";}' NOT NULL ALTER TABLE tl_layout CHANGE widthRight widthRight VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE widthLeft widthLeft VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE cols cols VARCHAR(8) DEFAULT '2cll' NOT NULL ALTER TABLE tl_layout CHANGE footerHeight footerHeight VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE headerHeight headerHeight VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE rows rows VARCHAR(8) DEFAULT '2rwh' NOT NULL ALTER TABLE tl_layout CHANGE name name VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_log CHANGE browser browser VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_log CHANGE func func VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_log CHANGE username username VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_log CHANGE action action VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_log CHANGE source source VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE useTwoFactor useTwoFactor CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE secret secret BINARY(128) DEFAULT NULL ALTER TABLE tl_member CHANGE stop stop VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE start start VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE disable disable CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE homeDir homeDir BINARY(16) DEFAULT NULL ALTER TABLE tl_member CHANGE assignDir assignDir CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE password password VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE username username VARCHAR(64) DEFAULT NULL COLLATE `utf8mb4_bin` ALTER TABLE tl_member CHANGE login login CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE language language VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE website website VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE email email VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE fax fax VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE mobile mobile VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE phone phone VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE country country VARCHAR(2) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE state state VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE city city VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE postal postal VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE street street VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE company company VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE gender gender VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE dateOfBirth dateOfBirth VARCHAR(11) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE lastname lastname VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE firstname firstname VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_member_group CHANGE stop stop VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_member_group CHANGE start start VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_member_group CHANGE disable disable CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_member_group CHANGE redirect redirect CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_member_group CHANGE name name VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE cms_tag_visibility cms_tag_visibility CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE cms_tag_fallback_css_class cms_tag_fallback_css_class VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE cms_tag_override_label cms_tag_override_label CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE cms_tag_accept_label cms_tag_accept_label VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE cms_tag_accept_all_label cms_tag_accept_all_label VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE cms_tag_reject_label cms_tag_reject_label VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE cms_tag_set_style cms_tag_set_style CHAR(1) DEFAULT '1' NOT NULL ALTER TABLE tl_module CHANGE cms_layout_selector cms_layout_selector VARCHAR(64) DEFAULT 'light' NOT NULL ALTER TABLE tl_module CHANGE cms_tag_cookie_lifetime cms_tag_cookie_lifetime VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE cms_tag_accept_subdomains cms_tag_accept_subdomains CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE pdir_sf_enableMasonry pdir_sf_enableMasonry CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE pdir_sf_columns pdir_sf_columns VARCHAR(64) DEFAULT 'columns3' NOT NULL ALTER TABLE tl_module CHANGE pdir_sf_enableImages pdir_sf_enableImages CHAR(1) DEFAULT '1' NOT NULL ALTER TABLE tl_module CHANGE align_css align_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE color_css color_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE style_css style_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE layout_css layout_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE news_sysfilter news_sysfilter CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE news_filter_multiple news_filter_multiple CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE bgposition bgposition VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE visibility_css visibility_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE privacy_lbl_1 privacy_lbl_1 VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE privacy_lbl_2 privacy_lbl_2 VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE privacy_lbl_3 privacy_lbl_3 VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE privacy_url_1 privacy_url_1 VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE privacy_url_2 privacy_url_2 VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE privacy_preselect privacy_preselect VARCHAR(96) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE margin_t margin_t VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE margin_b margin_b VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE margin_t_m margin_t_m VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE margin_b_m margin_b_m VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE nl_template nl_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE nl_hideChannels nl_hideChannels CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE cal_featured cal_featured VARCHAR(16) CHARACTER SET ascii DEFAULT 'all_items' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE cal_showQuantity cal_showQuantity CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE cal_ctemplate cal_ctemplate VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE cal_template cal_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE cal_order cal_order VARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE cal_ignoreDynamic cal_ignoreDynamic CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE cal_format cal_format VARCHAR(32) CHARACTER SET ascii DEFAULT 'cal_month' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE cal_hideRunning cal_hideRunning CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE cal_noSpan cal_noSpan CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE list_info_layout list_info_layout VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE list_layout list_layout VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE list_table list_table VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE news_showQuantity news_showQuantity CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE news_order news_order VARCHAR(32) CHARACTER SET ascii DEFAULT 'order_date_desc' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE news_format news_format VARCHAR(32) CHARACTER SET ascii DEFAULT 'news_month' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE news_template news_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE news_metaFields news_metaFields VARCHAR(255) CHARACTER SET ascii DEFAULT 'a:2:{i:0;s:4:"date";i:1;s:6:"author";}' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE news_jumpToCurrent news_jumpToCurrent VARCHAR(16) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE news_featured news_featured VARCHAR(16) CHARACTER SET ascii DEFAULT 'all_items' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE com_template com_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE com_disableCaptcha com_disableCaptcha CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE com_requireLogin com_requireLogin CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE com_bbcode com_bbcode CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE com_moderate com_moderate CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE com_order com_order VARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE cssID cssID VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE guests guests CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE protected protected CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE reg_activate reg_activate CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE reg_homeDir reg_homeDir BINARY(16) DEFAULT NULL ALTER TABLE tl_module CHANGE reg_assignDir reg_assignDir CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE reg_deleteDir reg_deleteDir CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE reg_close reg_close VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE reg_skipName reg_skipName CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE reg_allowLogin reg_allowLogin CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE disableCaptcha disableCaptcha CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE rss_template rss_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE fullsize fullsize CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE useCaption useCaption CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE imgSize imgSize VARCHAR(128) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE singleSRC singleSRC BINARY(16) DEFAULT NULL ALTER TABLE tl_module CHANGE loadFirst loadFirst CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE inColumn inColumn VARCHAR(32) CHARACTER SET ascii DEFAULT 'main' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE searchTpl searchTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE searchType searchType VARCHAR(16) CHARACTER SET ascii DEFAULT 'simple' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE contextLength contextLength VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE fuzzy fuzzy CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE queryType queryType VARCHAR(8) CHARACTER SET ascii DEFAULT 'and' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE memberTpl memberTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE redirectBack redirectBack CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE autologin autologin CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE customLabel customLabel VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE showHidden showHidden CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE customTpl customTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE navigationTpl navigationTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE defineRoot defineRoot CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE showProtected showProtected CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE hardLimit hardLimit CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE type type VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE headline headline VARCHAR(255) DEFAULT 'a:2:{s:5:"value";s:0:"";s:4:"unit";s:2:"h2";}' NOT NULL ALTER TABLE tl_module CHANGE name name VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE cms_publish_facebook cms_publish_facebook CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE cms_facebook_queue_publish cms_facebook_queue_publish CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE social_feed_id social_feed_id VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE social_feed_type social_feed_type VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE social_feed_account social_feed_account VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE social_feed_account_picture social_feed_account_picture BINARY(16) DEFAULT NULL ALTER TABLE tl_news CHANGE addFilter addFilter CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE stop stop VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE start start VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE published published CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE noComments noComments CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE cssClass cssClass VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE target target CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE url url VARCHAR(2048) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE source source VARCHAR(12) DEFAULT 'default' NOT NULL ALTER TABLE tl_news CHANGE addEnclosure addEnclosure CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE floating floating VARCHAR(12) DEFAULT 'above' NOT NULL ALTER TABLE tl_news CHANGE caption caption VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE fullsize fullsize CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE imageUrl imageUrl VARCHAR(2048) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE imagemargin imagemargin VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE size size VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE imageTitle imageTitle VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE alt alt VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE singleSRC singleSRC BINARY(16) DEFAULT NULL ALTER TABLE tl_news CHANGE overwriteMeta overwriteMeta CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE addImage addImage CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE subheadline subheadline VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE robots robots VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE pageTitle pageTitle VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin` ALTER TABLE tl_news CHANGE featured featured CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE headline headline VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_news_archive CHANGE manualSorting manualSorting CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_news_archive CHANGE disableCaptcha disableCaptcha CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_news_archive CHANGE requireLogin requireLogin CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_news_archive CHANGE bbcode bbcode CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_news_archive CHANGE moderate moderate CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_news_archive CHANGE sortOrder sortOrder VARCHAR(32) DEFAULT 'ascending' NOT NULL ALTER TABLE tl_news_archive CHANGE notify notify VARCHAR(16) DEFAULT 'notify_admin' NOT NULL ALTER TABLE tl_news_archive CHANGE allowComments allowComments CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_news_archive CHANGE protected protected CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_news_archive CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_news_feed CHANGE imgSize imgSize VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_news_feed CHANGE feedBase feedBase VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_news_feed CHANGE source source VARCHAR(32) DEFAULT 'source_teaser' NOT NULL ALTER TABLE tl_news_feed CHANGE format format VARCHAR(32) DEFAULT 'rss' NOT NULL ALTER TABLE tl_news_feed CHANGE language language VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_news_feed CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin` ALTER TABLE tl_news_feed CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter CHANGE date date VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter CHANGE sent sent CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter CHANGE senderName senderName VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter CHANGE sender sender VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter CHANGE mailerTransport mailerTransport VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter CHANGE externalImages externalImages CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter CHANGE sendText sendText CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter CHANGE template template VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter CHANGE addFile addFile CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin` ALTER TABLE tl_newsletter CHANGE subject subject VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter_channel CHANGE senderName senderName VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter_channel CHANGE sender sender VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter_channel CHANGE mailerTransport mailerTransport VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter_channel CHANGE template template VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter_channel CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter_deny_list CHANGE hash hash VARCHAR(32) DEFAULT NULL ALTER TABLE tl_newsletter_recipients CHANGE addedOn addedOn VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter_recipients CHANGE active active CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter_recipients CHANGE email email VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_opt_in CHANGE emailSubject emailSubject VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_opt_in CHANGE email email VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_opt_in CHANGE invalidatedThrough invalidatedThrough VARCHAR(24) DEFAULT '' NOT NULL ALTER TABLE tl_opt_in CHANGE token token VARCHAR(24) DEFAULT '' NOT NULL ALTER TABLE tl_opt_in_related CHANGE relTable relTable VARCHAR(64) DEFAULT NULL ALTER TABLE tl_page CHANGE cms_root_license cms_root_license VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE cms_exclude_health_check cms_exclude_health_check CHAR(1) DEFAULT '0' NOT NULL ALTER TABLE tl_page CHANGE ribbon ribbon VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE addImage addImage CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE singleSRC singleSRC BINARY(16) DEFAULT NULL ALTER TABLE tl_page CHANGE style_css style_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE height_css height_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE imgHeadline imgHeadline VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE imgSubheadline imgSubheadline VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE addArticle addArticle CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE visibility_css visibility_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE pct_theme pct_theme VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE pct_theme_import pct_theme_import CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE addFontIcon addFontIcon CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE fontIcon fontIcon VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE enforceTwoFactor enforceTwoFactor CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE stop stop VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE start start VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE published published CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE accesskey accesskey CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE guests guests CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE hide hide CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE sitemap sitemap VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE cssClass cssClass VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE noSearch noSearch CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE chmod chmod VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE includeChmod includeChmod CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE alwaysLoadFromCache alwaysLoadFromCache CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE includeCache includeCache CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE includeLayout includeLayout CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE protected protected CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE autoforward autoforward CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE useSSL useSSL CHAR(1) DEFAULT '1' NOT NULL ALTER TABLE tl_page CHANGE urlSuffix urlSuffix VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE urlPrefix urlPrefix VARCHAR(128) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin` ALTER TABLE tl_page CHANGE useFolderUrl useFolderUrl CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE validAliasCharacters validAliasCharacters VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE datimFormat datimFormat VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE timeFormat timeFormat VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE dateFormat dateFormat VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE adminEmail adminEmail VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE canonicalKeepParams canonicalKeepParams VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE canonicalLink canonicalLink VARCHAR(2048) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE enableCanonical enableCanonical CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE mailerTransport mailerTransport VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE maintenanceMode maintenanceMode CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE favicon favicon BINARY(16) DEFAULT NULL ALTER TABLE tl_page CHANGE disableLanguageRedirect disableLanguageRedirect CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE fallback fallback CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE staticPlugins staticPlugins VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE staticFiles staticFiles VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE dns dns VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE target target CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE url url VARCHAR(2048) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE redirectBack redirectBack CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE redirect redirect VARCHAR(32) DEFAULT 'permanent' NOT NULL ALTER TABLE tl_page CHANGE robots robots VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE language language VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE pageTitle pageTitle VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE requireItem requireItem CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin` ALTER TABLE tl_page CHANGE type type VARCHAR(64) DEFAULT 'regular' NOT NULL ALTER TABLE tl_page CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement CHANGE cssID cssID VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement CHANGE protected protected CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement CHANGE template template VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement CHANGE isWrapper isWrapper VARCHAR(8) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement CHANGE isFMD isFMD CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement CHANGE isCTE isCTE CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin` ALTER TABLE tl_pct_customelement_attribute CHANGE fontIcon fontIcon VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE addFontIcon addFontIcon CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE galleryTpl galleryTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_pct_customelement_attribute CHANGE number_format number_format VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE max_value max_value CHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE min_value min_value CHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE date_rgxp date_rgxp VARCHAR(8) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE date_format date_format VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE include_type include_type VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE size size VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE isRadio isRadio CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE tinyTpl tinyTpl VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE sortBy sortBy VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE isDownload isDownload CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE be_visible be_visible CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_tl_class_long eval_tl_class_long CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_tl_class_m12 eval_tl_class_m12 CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_tl_class_clr eval_tl_class_clr CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_tl_class_w50 eval_tl_class_w50 CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_tl_style eval_tl_style VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_pagepicker eval_pagepicker CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_datepicker eval_datepicker CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_includeBlankOption eval_includeBlankOption CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_attributeType eval_attributeType VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_path eval_path BINARY(16) DEFAULT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_extensions eval_extensions VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_filesOnly eval_filesOnly CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_files eval_files CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_allowHtml eval_allowHtml CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_submitOnChange eval_submitOnChange CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_rte eval_rte CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_size eval_size CHAR(3) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_multiple eval_multiple CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_rowscols eval_rowscols VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_rgxp eval_rgxp VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_mandatory eval_mandatory CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE hidden hidden CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE published published CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE cssID cssID VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE protected protected CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE template template VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE description description VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE type type VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin` ALTER TABLE tl_pct_customelement_attribute CHANGE uuid uuid VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_group CHANGE published published CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_group CHANGE cssID cssID VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_group CHANGE protected protected CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_group CHANGE legend_hide legend_hide CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_group CHANGE hidden hidden CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_group CHANGE allowCut allowCut CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_group CHANGE allowCopy allowCopy CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_group CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_group CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin` ALTER TABLE tl_pct_customelement_plugin CHANGE published published CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_plugin CHANGE protected protected CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_plugin CHANGE exclude exclude CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_plugin CHANGE plugin plugin VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_pct_themedesigner CHANGE active active CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_themedesigner CHANGE description description VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_pct_themedesigner CHANGE theme theme VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_preview_link CHANGE published published CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_preview_link CHANGE showUnpublished showUnpublished CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_preview_link CHANGE url url VARCHAR(2048) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider CHANGE jsTemplate jsTemplate VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider CHANGE sliderTemplate sliderTemplate VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider CHANGE stopAfterLoops stopAfterLoops CHAR(3) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider CHANGE stopAtSlide stopAtSlide CHAR(3) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider CHANGE startWithSlide startWithSlide CHAR(3) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider CHANGE overlay overlay VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider CHANGE stopOnHover stopOnHover CHAR(1) DEFAULT '1' NOT NULL ALTER TABLE tl_revolutionslider CHANGE arrowStyle arrowStyle VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider CHANGE navigationSize navigationSize VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider CHANGE navigationType navigationType VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider CHANGE shuffle shuffle CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider CHANGE transition transition VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider CHANGE fullScreenOffsetContainer fullScreenOffsetContainer VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider CHANGE sliderType sliderType VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider CHANGE sliderBreakPoint sliderBreakPoint VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider CHANGE sliderSize sliderSize VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider CHANGE sliderStyle sliderStyle VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider CHANGE cssID cssID VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE nextslideatend nextslideatend CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE `loop` `loop` CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE videoURL videoURL VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE videoSRC videoSRC BINARY(16) DEFAULT NULL ALTER TABLE tl_revolutionslider_slides CHANGE published published CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE cssID cssID VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE data_ease data_ease VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE data_bgscale data_bgscale VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE data_bgposition_OUT data_bgposition_OUT VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE kenburns kenburns CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE data_bgcolor data_bgcolor VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE data_bgrepeat data_bgrepeat CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE data_bgposition data_bgposition VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE data_bgfit data_bgfit VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE background background VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE size size VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE singleSRC singleSRC BINARY(16) DEFAULT NULL ALTER TABLE tl_revolutionslider_slides CHANGE singleSRC_thumb singleSRC_thumb BINARY(16) DEFAULT NULL ALTER TABLE tl_revolutionslider_slides CHANGE lazyload lazyload CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE delay delay VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE masterspeed masterspeed VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE newWindow newWindow CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE slideUrl slideUrl VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE transition transition VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_search CHANGE language language VARCHAR(5) DEFAULT '' NOT NULL ALTER TABLE tl_search CHANGE protected protected CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_search CHANGE checksum checksum VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_search CHANGE url url VARCHAR(2048) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_social_feed CHANGE linkedin_refresh_token_expires linkedin_refresh_token_expires VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_social_feed CHANGE access_token_expires access_token_expires VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_social_feed CHANGE linkedin_account_picture_size linkedin_account_picture_size VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_social_feed CHANGE linkedin_account_picture linkedin_account_picture BINARY(16) DEFAULT NULL ALTER TABLE tl_social_feed CHANGE twitter_access_token_secret twitter_access_token_secret VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_social_feed CHANGE twitter_access_token twitter_access_token VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_social_feed CHANGE twitter_api_secret_key twitter_api_secret_key VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_social_feed CHANGE twitter_api_key twitter_api_key VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_social_feed CHANGE hashtags_link hashtags_link CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_social_feed CHANGE show_reply show_reply CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_social_feed CHANGE show_retweets show_retweets CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_social_feed CHANGE search search VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_social_feed CHANGE twitter_account twitter_account VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_social_feed CHANGE instagram_account_picture_size instagram_account_picture_size VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_social_feed CHANGE instagram_account_picture instagram_account_picture BINARY(16) DEFAULT NULL ALTER TABLE tl_social_feed CHANGE pdir_sf_fb_news_last_import_date pdir_sf_fb_news_last_import_date VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_social_feed CHANGE pdir_sf_fb_news_cronjob pdir_sf_fb_news_cronjob VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_social_feed CHANGE pdir_sf_fb_posts pdir_sf_fb_posts CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_social_feed CHANGE pdir_sf_fb_news_archive pdir_sf_fb_news_archive VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_social_feed CHANGE pdir_sf_fb_access_token pdir_sf_fb_access_token VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_social_feed CHANGE pdir_sf_fb_app_secret pdir_sf_fb_app_secret VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_social_feed CHANGE pdir_sf_fb_app_id pdir_sf_fb_app_id VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_social_feed CHANGE pdir_sf_fb_account pdir_sf_fb_account VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_social_feed CHANGE socialFeedType socialFeedType VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE invisible invisible CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE liststyleimage liststyleimage VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE liststyletype liststyletype VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE list list CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE wordspacing wordspacing VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE letterspacing letterspacing VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE textindent textindent VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE texttransform texttransform VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE fontstyle fontstyle VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE lineheight lineheight VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE fontcolor fontcolor VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE fontsize fontsize VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE fontfamily fontfamily VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE font font CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE borderspacing borderspacing VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE bordercollapse bordercollapse VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE borderradius borderradius VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE bordercolor bordercolor VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE borderstyle borderstyle VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE borderwidth borderwidth VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE border border CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE gradientColors gradientColors VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE gradientAngle gradientAngle VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE shadowcolor shadowcolor VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE shadowsize shadowsize VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE bgrepeat bgrepeat VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE bgposition bgposition VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE bgimage bgimage VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE bgcolor bgcolor VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE background background CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE whitespace whitespace VARCHAR(8) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE textalign textalign VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE verticalalign verticalalign VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE align align VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE padding padding VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE margin margin VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE alignment alignment CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE display display VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE overflow overflow VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE clear clear VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE floating floating VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE position position VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE trbl trbl VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE positioning positioning CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE maxheight maxheight VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE maxwidth maxwidth VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE minheight minheight VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE minwidth minwidth VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE height height VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE width width VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE size size CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE comment comment VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE category category VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE selector selector VARCHAR(1022) DEFAULT '' NOT NULL ALTER TABLE tl_style_sheet CHANGE media media VARCHAR(255) DEFAULT 'a:1:{i:0;s:3:"all";}' NOT NULL ALTER TABLE tl_style_sheet CHANGE cc cc VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_style_sheet CHANGE name name VARCHAR(64) DEFAULT NULL ALTER TABLE tl_theme CHANGE templates templates VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_theme CHANGE screenshot screenshot BINARY(16) DEFAULT NULL ALTER TABLE tl_theme CHANGE author author VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_theme CHANGE name name VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_undo CHANGE fromTable fromTable VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_user CHANGE cms_pro_mode_enabled cms_pro_mode_enabled CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_user CHANGE backend100 backend100 CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_user CHANGE pct_frontend_quickedit pct_frontend_quickedit CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_user CHANGE useTwoFactor useTwoFactor CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_user CHANGE secret secret BINARY(128) DEFAULT NULL ALTER TABLE tl_user CHANGE stop stop VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_user CHANGE start start VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_user CHANGE disable disable CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_user CHANGE inherit inherit VARCHAR(12) DEFAULT 'group' NOT NULL ALTER TABLE tl_user CHANGE admin admin CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_user CHANGE pwChange pwChange CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_user CHANGE password password VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_user CHANGE useCE useCE CHAR(1) DEFAULT '1' NOT NULL ALTER TABLE tl_user CHANGE useRTE useRTE CHAR(1) DEFAULT '1' NOT NULL ALTER TABLE tl_user CHANGE thumbnails thumbnails CHAR(1) DEFAULT '1' NOT NULL ALTER TABLE tl_user CHANGE showHelp showHelp CHAR(1) DEFAULT '1' NOT NULL ALTER TABLE tl_user CHANGE uploader uploader VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_user CHANGE fullscreen fullscreen CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_user CHANGE backendTheme backendTheme VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_user CHANGE language language VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_user CHANGE email email VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_user CHANGE name name VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_user CHANGE username username VARCHAR(64) DEFAULT NULL COLLATE `utf8mb4_bin` ALTER TABLE tl_user_group CHANGE stop stop VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_user_group CHANGE start start VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_user_group CHANGE disable disable CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_user_group CHANGE name name VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_version CHANGE active active CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_version CHANGE description description VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_version CHANGE username username VARCHAR(64) DEFAULT NULL ALTER TABLE tl_version CHANGE fromTable fromTable VARCHAR(255) DEFAULT '' NOT NULL

Leider lässt sich danach die Datenbank nicht aktualiseren und das Frontend ist nicht mehr zu erreichen (das Backend schon). Logdatei sagt

Code:

[2022-05-06T20:13:35.746064+02:00] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\SyntaxErrorException: "An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows rows VARCHAR(8) DEFAULT '2rwh' NOT NULL' at line 1" at /…/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 88 {"exception":"[object] (Doctrine\\DBAL\\Exception\\SyntaxErrorException(code: 1064): An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows rows VARCHAR(8) DEFAULT '2rwh' NOT NULL' at line 1 at /…/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:88)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1064): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows rows VARCHAR(8) DEFAULT '2rwh' NOT NULL' at line 1 at /…./vendor/doctrine/dbal/src/Driver/PDO/Exception.php:30)\n[previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows rows VARCHAR(8) DEFAULT '2rwh' NOT NULL' at line 1 at /…/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:34)"} []

Stack Trace

Code:

ErrorException: Warning: Undefined array key "target" at system/modules/pct_customelements/PCT/CustomElements/Core/Attribute.php:270 at PCT\CustomElements\Core\Attribute->loadOptionValue() (system/modules/pct_customelements/PCT/CustomElements/Core/TemplateAttribute.php:165) at PCT\CustomElements\Core\TemplateAttribute->optionvalue() (system/modules/pct_customelements/PCT/CustomElements/Core/TemplateAttribute.php:174) at PCT\CustomElements\Core\TemplateAttribute->option() (system/modules/pct_theme_templates/templates/customelements/customelement_onepage_navi.html5:42) at include('/...../system/modules/pct_theme_templates/templates/customelements/customelement_onepage_navi.html5') (vendor/contao/core-bundle/src/Resources/contao/library/Contao/TemplateInheritance.php:108) at Contao\Template->inherit() (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Template.php:295) at Contao\Template->parse() (vendor/contao/core-bundle/src/Resources/contao/classes/FrontendTemplate.php:43) at Contao\FrontendTemplate->parse() (vendor/contao/core-bundle/src/Resources/contao/modules/Module.php:245) at Contao\Module->generate() (system/modules/pct_customelements/PCT/CustomElements/Frontend/ModuleCustomElement.php:122) at PCT\CustomElements\Frontend\ModuleCustomElement->generate() (vendor/contao/core-bundle/src/Resources/contao/elements/ContentModule.php:98) at Contao\ContentModule->generate() (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Controller.php:615) at Contao\Controller::getContentElement() (vendor/contao/core-bundle/src/Resources/contao/modules/ModuleArticle.php:197) at Contao\ModuleArticle->compile() (vendor/contao/core-bundle/src/Resources/contao/modules/Module.php:214) at Contao\Module->generate() (vendor/contao/core-bundle/src/Resources/contao/modules/ModuleArticle.php:70) at Contao\ModuleArticle->generate() (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Controller.php:543) at Contao\Controller::getArticle() (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Controller.php:385) at Contao\Controller::getFrontendModule() (vendor/contao/core-bundle/src/Resources/contao/pages/PageRegular.php:190) at Contao\PageRegular->prepare() (vendor/contao/core-bundle/src/Resources/contao/pages/PageRegular.php:60) at Contao\PageRegular->getResponse() (vendor/contao/core-bundle/src/Resources/contao/controllers/FrontendIndex.php:316) at Contao\FrontendIndex->renderPage() (vendor/symfony/http-kernel/HttpKernel.php:152) at Symfony\Component\HttpKernel\HttpKernel->handleRaw() (vendor/symfony/http-kernel/HttpKernel.php:74) at Symfony\Component\HttpKernel\HttpKernel->handle() (vendor/symfony/http-kernel/Kernel.php:202) at Symfony\Component\HttpKernel\Kernel->handle() (public/index.php:44) at require('/..../public/index.php') (public/app.php:13)

PHP 8.0.18, Contao 4.13.4

Vielleicht hat ja doch jemand eine Idee - Danke ;)
(Das löschen/leeren/aktualisieren) aller Caches hat nichts geändert..)

@sneak du vermischst hier zwei verschiedene Fehler. Der erste Fehler ist der Fehler, um den es hier in diesem Thread geht.

Der zweite Fehler hat nichts damit zu tun. Der zweite Fehler (der dein Frontend kaputt macht) kommt aus einer der Premium Contao Themes Erweiterungen. Stelle sicher, dass du die neueste Versionen der PCT Module installiert hast. Im Zweifelsfall kannst du dich an den PCT Support wenden.

Zitat:

Zitat von Spooky

@sneak du vermischst hier zwei verschiedene Fehler. Der erste Fehler ist der Fehler, um den es hier in diesem Thread geht.

Der zweite Fehler hat nichts damit zu tun. Der zweite Fehler (der dein Frontend kaputt macht) kommt aus einer der Premium Contao Themes Erweiterungen. Stelle sicher, dass du die neueste Versionen der PCT Module installiert hast. Im Zweifelsfall kannst du dich an den PCT Support wenden.

Das habe ich parallel schon gemacht, warten wir mal ab, was kommt. :) Danke

Zitat:

Zitat von Spooky

@sneak du vermischst hier zwei verschiedene Fehler. Der erste Fehler ist der Fehler, um den es hier in diesem Thread geht.

Der zweite Fehler hat nichts damit zu tun. Der zweite Fehler (der dein Frontend kaputt macht) kommt aus einer der Premium Contao Themes Erweiterungen. Stelle sicher, dass du die neueste Versionen der PCT Module installiert hast. Im Zweifelsfall kannst du dich an den PCT Support wenden.

Das ist eine PHP Warning, die in diesem Moment durch den aktiven Debug-Modus aufgezeigt wird. Im normalen produktiven Modus führt dies zu keinem Stop der Ausführung. Mit der MariaDB Problematik steht dies nicht in Verbindung.

All-inkl fährt neuerdings auch MariaDB. Probleme konnte ich dort allerdings noch keine feststellen.

Muss aber dennoch behoben werden, andernfalls macht es den Debug-Modus unbrauchbar.

kurzes Update, in meinem Fall war die Lösung, in der Datenbank

Code:

'0'

gegen

Code:

0

auszutauschen, damit ließ sich die Datenbank entsprechend von MySQL in MariaDB importieren und es gab keine Aktualisierungen im Installations-Tool mehr #füreuchgetest

Danke @spooky und @Tim

Ich ziehe momentan Contao Installationen von einem Server auf einen neuen um und bin auch von dem Problem betroffen. Mittlerweile habe ich das Problem bei 5 Seiten.

Code:

? * ALTER TABLE tl_layout CHANGE rows rows VARCHAR(8) DEFAULT '2rwh' NOT NULL......FAILED [OK] Executed 531 SQL queries. [ERROR] An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows rows VARCHAR(8) DEFAULT '2rwh' NOT NULL' at line 1

Auch hier fällt auf das auf dem alten Server 5.7.38-0ubuntu0.18.04.1 (Ubuntu) lief, auf dem neuen 10.3.34-MariaDB-0ubuntu0.20.04.1

Das manuelle Ausführen vom folgendem Query klappt (also escaped)

Code:

ALTER TABLE tl_layout CHANGE `rows` `rows` VARCHAR(8) DEFAULT '2rwh' NOT NULL

Der Installiert kapiert das aber nicht und möchte den Query trotzdem nochmal ausführen was in besagtem Problem endet.

Ich hatte letzte Woche schon ein paar Seiten von der selben alten Maschine auf die selbe neue Maschine umgezogen, da trat das Problem bisher nicht auf.

Evtl nochmal ein Ticket eröffnen?