4.5.x Install-Tool – Datenbank-Aktualisierung

Install-Tool – Datenbank-Aktualisierung

Hallo zusammen,

ich habe gerade Contao 4.5 installiert. Die Installation hat funktioniert, allerdings verschwinden die SQL-Anweisungen im Install-Tool nicht, nachdem ich auf den Button Datenbank aktualisieren klicke. Trotzdem wurden die Datenbank-Tabellen und Einträge korrekt erstellt, so dass ich mich auch im Contao-Backend ohne Probleme anmelden kann. ich kann auch ganz normal in Contao arbeiten, Inhalte werden also auch korrekt in der Datenbank gespeichert.

Als Datenbank läuft ein MariaDB-Server in Version 10.2 (stable).

Eine Fehlermeldung konnte ich nicht finden, weder in den Contao- noch in den Server-Logs.

Tritt das nur bei mir auf oder hat jemand anders dasselbe Problem?

Vielen Dank und viele Grüße,
Timo

Welche SQL Anweisungen bleiben über?

Diese Anweisungen bleiben über:

Code:

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 '' NOT NULL ALTER TABLE tl_article CHANGE alias alias VARCHAR(128) 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 '' NOT NULL ALTER TABLE tl_calendar CHANGE notify notify VARCHAR(32) DEFAULT '' 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(255) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE source source VARCHAR(32) 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 '' 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(255) 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 endDate endDate INT UNSIGNED DEFAULT NULL ALTER TABLE tl_calendar_events CHANGE startDate startDate INT UNSIGNED DEFAULT NULL ALTER TABLE tl_calendar_events CHANGE endTime endTime INT UNSIGNED DEFAULT NULL ALTER TABLE tl_calendar_events CHANGE startTime startTime INT UNSIGNED DEFAULT NULL ALTER TABLE tl_calendar_events CHANGE addTime addTime CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE alias alias VARCHAR(128) DEFAULT '' NOT NULL COLLATE utf8mb4_bin ALTER TABLE tl_calendar_events CHANGE title title 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 '' NOT NULL ALTER TABLE tl_calendar_feed CHANGE format format VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_feed CHANGE language language VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_feed CHANGE alias alias VARCHAR(128) 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 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 tokenConfirm tokenConfirm VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_comments_notify CHANGE ip ip VARCHAR(64) 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(128) 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 com_template com_template VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE com_requireLogin com_requireLogin CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE com_disableCaptcha com_disableCaptcha CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE com_bbcode com_bbcode CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE com_moderate com_moderate CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE com_order com_order VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE stop stop VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE start start VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE invisible invisible CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE cssID cssID VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE guests guests CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE protected protected CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE sliderContinuous sliderContinuous CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autoplay autoplay CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE playerSize playerSize VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE posterSRC posterSRC BINARY(16) DEFAULT NULL ALTER TABLE tl_content CHANGE vimeo vimeo VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE youtube youtube VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE customTpl customTpl VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE galleryTpl galleryTpl VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE metaIgnore metaIgnore CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE sortBy sortBy VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE useHomeDir useHomeDir CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE useImage useImage CHAR(1) DEFAULT '' NOT NULL 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 target target CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE url url VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE highlight highlight VARCHAR(32) DEFAULT '' NOT NULL 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) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE sortable sortable CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE tleft tleft CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE tfoot tfoot CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE thead thead CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE summary summary VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE listtype listtype VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE floating floating VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE caption caption VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE fullsize fullsize CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE imageUrl imageUrl VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE imagemargin imagemargin VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE size size VARCHAR(64) DEFAULT '' NOT NULL 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) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE addImage addImage CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE headline headline VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE type type VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE ptable ptable VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_cron CHANGE value value VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_cron CHANGE name name VARCHAR(32) DEFAULT NULL 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 '' 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(255) 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 alias alias VARCHAR(128) 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 '' NOT NULL ALTER TABLE tl_faq_category CHANGE notify notify VARCHAR(16) DEFAULT '' 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 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 ALTER TABLE tl_files CHANGE path path VARCHAR(1022) DEFAULT '' NOT NULL 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 '' 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 '' 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 sendViaEmail sendViaEmail CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_form CHANGE alias alias VARCHAR(128) DEFAULT '' NOT NULL COLLATE utf8mb4_bin ALTER TABLE tl_form CHANGE title title VARCHAR(255) 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 '' 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 '' 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 '' NOT NULL ALTER TABLE tl_image_size CHANGE zoom zoom INT DEFAULT NULL ALTER TABLE tl_image_size CHANGE resizeMode resizeMode VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_image_size CHANGE height height INT DEFAULT NULL ALTER TABLE tl_image_size CHANGE width width INT DEFAULT NULL ALTER TABLE tl_image_size CHANGE densities densities VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_image_size CHANGE sizes sizes 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 zoom zoom INT DEFAULT NULL ALTER TABLE tl_image_size_item CHANGE resizeMode resizeMode VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_image_size_item CHANGE height height INT DEFAULT NULL ALTER TABLE tl_image_size_item CHANGE width width INT DEFAULT NULL ALTER TABLE tl_image_size_item CHANGE densities densities 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 media media VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE align align VARCHAR(32) DEFAULT '' 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 picturefill picturefill CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE mooSource mooSource VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE addMooTools addMooTools CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE jSource jSource VARCHAR(16) 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 webfonts webfonts VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE doctype doctype VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE template template VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE combineScripts combineScripts CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE loadingOrder loadingOrder VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE framework framework VARCHAR(255) DEFAULT '' 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 '' 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 '' 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 ip ip VARCHAR(64) 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 activation activation VARCHAR(32) DEFAULT '' NOT 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(5) 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 nl_template nl_template VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE nl_hideChannels nl_hideChannels CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE news_showQuantity news_showQuantity CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE news_order news_order VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE news_format news_format VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE news_template news_template VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE news_metaFields news_metaFields VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE news_jumpToCurrent news_jumpToCurrent VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE news_featured news_featured VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE list_info_layout list_info_layout VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE list_layout list_layout VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE list_info_where list_info_where VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE list_info list_info VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE list_sort list_sort VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE list_search list_search VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE list_where list_where VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE list_fields list_fields VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE list_table list_table VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE com_template com_template VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE com_disableCaptcha com_disableCaptcha CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE com_requireLogin com_requireLogin CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE com_bbcode com_bbcode CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE com_moderate com_moderate CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE com_order com_order VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE cal_showQuantity cal_showQuantity CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE cal_ctemplate cal_ctemplate VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE cal_template cal_template VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE cal_order cal_order VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE cal_ignoreDynamic cal_ignoreDynamic CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE cal_format cal_format VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE cal_hideRunning cal_hideRunning CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE cal_noSpan cal_noSpan CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE cssID cssID VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE guests guests CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE protected protected CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE reg_activate reg_activate CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE reg_homeDir reg_homeDir BINARY(16) DEFAULT NULL ALTER TABLE tl_module CHANGE reg_assignDir reg_assignDir CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE reg_close reg_close VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE reg_skipName reg_skipName CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE reg_allowLogin reg_allowLogin CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE disableCaptcha disableCaptcha CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE rss_template rss_template VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE fullsize fullsize CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE useCaption useCaption CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE imgSize imgSize VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE flashID flashID VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE interactive interactive CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE url url VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE singleSRC singleSRC BINARY(16) DEFAULT NULL ALTER TABLE tl_module CHANGE source source VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE flashvars flashvars VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE transparent transparent CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE size size VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE loadFirst loadFirst CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE inColumn inColumn VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE searchTpl searchTpl VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE searchType searchType VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE fuzzy fuzzy CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE queryType queryType VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE memberTpl memberTpl VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE cols cols VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE redirectBack redirectBack CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE autologin autologin CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE customLabel customLabel VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE showHidden showHidden CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE customTpl customTpl VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE navigationTpl navigationTpl VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE defineRoot defineRoot CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE showProtected showProtected CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE hardLimit hardLimit CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE type type VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE headline headline VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE name name VARCHAR(255) 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 featured featured 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(255) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE source source VARCHAR(12) 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 '' 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(255) 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 alias alias VARCHAR(128) DEFAULT '' NOT NULL COLLATE utf8mb4_bin ALTER TABLE tl_news CHANGE headline headline VARCHAR(255) 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 '' NOT NULL ALTER TABLE tl_news_archive CHANGE notify notify VARCHAR(16) DEFAULT '' 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 feedBase feedBase VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_news_feed CHANGE source source VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_news_feed CHANGE format format VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_news_feed CHANGE language language VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_news_feed CHANGE alias alias VARCHAR(128) 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 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(128) DEFAULT '' NOT NULL COLLATE utf8mb4_bin ALTER TABLE tl_newsletter CHANGE subject subject VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter_blacklist CHANGE hash hash VARCHAR(32) DEFAULT 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 template template VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter_channel CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter_recipients CHANGE token token VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter_recipients CHANGE ip ip VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter_recipients CHANGE confirmed confirmed VARCHAR(10) DEFAULT '' NOT 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_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 requireItem requireItem CHAR(1) 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 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 '' NOT NULL ALTER TABLE tl_page CHANGE sitemapName sitemapName VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE createSitemap createSitemap 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 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(255) 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 '' NOT NULL ALTER TABLE tl_page CHANGE robots robots VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE language language VARCHAR(5) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE pageTitle pageTitle VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE type type VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE alias alias VARCHAR(128) DEFAULT '' NOT NULL COLLATE utf8mb4_bin ALTER TABLE tl_page CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_remember_me CHANGE lastUsed lastUsed DATETIME DEFAULT 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(255) DEFAULT '' NOT NULL ALTER TABLE tl_search CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_search_index CHANGE language language VARCHAR(5) DEFAULT '' NOT NULL ALTER TABLE tl_search_index CHANGE word word VARCHAR(64) DEFAULT '' NOT NULL COLLATE utf8mb4_bin 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 '' 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 defaultImageDensities defaultImageDensities VARCHAR(255) DEFAULT '' NOT 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 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 '' 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 '' NOT NULL ALTER TABLE tl_user CHANGE useRTE useRTE CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_user CHANGE thumbnails thumbnails CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_user CHANGE showHelp showHelp CHAR(1) DEFAULT '' 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(5) 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

Ich habe die Einstellungen für die Datenbankfelder mal geprüft. Die sind alle entsprechend den Anweisungen konfiguriert. Wenn ich die Einstellungen für einzelne Datenbank-Felder ändere und anschließend im Install-Tool die "Datenbank aktualisiere", werden die Anweisungen erneut ausgeführt und die Einstellungen für die Datenbank-Felder werden korrigiert.

Die Anweisungen bleiben trotzdem stehen.

Liegt vermutlich am STRICT mode bei deinem MySQL Server.

Strict mode ist deaktiviert.

MariaDB [psa]> SHOW GLOBAL VARIABLES LIKE "%strict%";
+----------------------------+-------+
| Variable_name | Value |
+----------------------------+-------+
| gtid_strict_mode | OFF |
| innodb_strict_mode | OFF |
| strict_password_validation | ON |
+----------------------------+-------+

MariaDB [psa]> SHOW VARIABLES LIKE 'sql_mode';
+---------------+-----------------------------------------------------------------------+
| Variable_name | Value |
+---------------+-----------------------------------------------------------------------+
| sql_mode | ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ ENGINE_SUBSTITUTION |
+---------------+-----------------------------------------------------------------------+

Geändert hat das auch nichts.

Hat noch jemand eine Idee?

Ich kann das bei mir auch nachvollziehen (MariaDB 10.2 mit MyISAM und InnoDB probiert, PHP7.1, Contao 4.4.12). Die Querys werden ja auch soweit erfolgreich ausgeführt. Nur scheint Contao das beim Schema-Vergleich das nicht zu erkennen.

Wenn das bei MariaDB 10.2+ reproduzierbar ist, dann am besten gleich hier als Bug reporten und die genaue MariaDB Version angeben.

Das meine ich ja: die queries werden ausgeführt aber Contao scheint das nicht zu erkennen.

Gesendet von iPad mit Tapatalk

Ticket: https://github.com/contao/installation-bundle/issues/83
Du musst auf Doctrine 2.7 warten.

Erstmal danke für die Hinweise.

Das heißt im Endeffekt, dass ich ein kleines Problem habe, wenn ich Contao 4.4 und 4.5 parallel auf einem Server betreiben möchte? Oder wie kann ich das Problem mit innodb_large_prefix bzw. dem Strict Mode mit MySQL 5.5 umgehen?

Welche DB-Version verwendet ihr auf euren Servern?

Mit innodb_large_prefix hat das Problem ja nichts zu tun, oder? Und was genau meinst du bzgl. dem parallelen Betrieb von Contao 4.4 und 4.5 auf dem gleichen Server? Was für ein Problem hast du mit MySQL 5.5?

Hatte das gleiche Problem.

Wie sich dann herausgestellt hat, war die Ursache ein %-Zeichen im Datenbank-Passwort welches dann als %%-Zeichen gespeichert wird.
Habe es mit einem anderen Sonderzeichen ersetzt und danach hat die Datenbank-Aktualisierung geklappt :-)

https://github.com/contao/contao/iss...ment-560455140