Ergebnis 1 bis 20 von 20

Thema: Update von 3.5.X nach 4.13.21

  1. #1
    Alter Contao-Hase Avatar von Messa
    Registriert seit
    19.01.2011.
    Ort
    Vorarlberg, Österreich
    Beiträge
    1.423

    Standard Update von 3.5.X nach 4.13.21

    Hallo.

    Ich hatte Gestern das Vergnügen eine Contao 3.5.X Version auf die neueste 4.13.21 updaten.
    Soweit hat alle geklappt nur kann ich neue Datenbankfelder anlegen und Schema ändern klappt auch nicht.
    Nach etwas gegoogle hatte ich das gefunden -> https://github.com/contao/contao/pull/4592/files
    Jetzt meine Frage ist das schon live? Oder muss ich hier selber nachbessern?

    Fehler die ich über das Install Tool erhalte -> (3 Beispiele - es sind ca. 600 Änderungen die Contao machen möchte )

    Code:
    CREATE TABLE tl_search_index (pid INT UNSIGNED NOT NULL, termId INT UNSIGNED NOT NULL, relevance SMALLINT UNSIGNED NOT NULL, INDEX pid (pid), PRIMARY KEY(termid, pid)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_article CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    CREATE INDEX pid_published_incolumn_start_stop ON tl_article (pid, published, incolumn, start, stop)
    lg Matthias

  2. #2
    Community-Moderator
    Wandelndes Contao-Lexikon
    Avatar von Spooky
    Registriert seit
    12.04.2012.
    Ort
    Scotland
    Beiträge
    35.517
    Partner-ID
    10107

    Standard

    Das was du gepostet hast ist kein Fehler. Da du in dem was du gepostet hast aber den Suchindex erwähnst: hast du vor dem Update den Suchindex gelöscht?
    » sponsor me via GitHub or PayPal or Revolut

  3. #3
    Alter Contao-Hase Avatar von Messa
    Registriert seit
    19.01.2011.
    Ort
    Vorarlberg, Österreich
    Beiträge
    1.423

    Standard

    Es sind 3 Meldungen drinnen - Im Moment kann ich im Backend nicht auf Systemwartung klicken.

    Ich erhalten dann im Browser folgende Meldung
    Code:
    An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'xa8431_db17.tl_search' doesn't exist
    Bildschirmfoto 2023-04-28 um 09.11.05.png
    Bildschirmfoto 2023-04-28 um 09.12.10.png
    Full Service Agentur - Grafikdesign, Screendesign, Webdesign, Webentwicklung, SEO, Weiterbildung, persönliches Coaching
    http://www.matthiasgmeiner.com

  4. #4
    Community-Moderator
    Wandelndes Contao-Lexikon
    Avatar von Spooky
    Registriert seit
    12.04.2012.
    Ort
    Scotland
    Beiträge
    35.517
    Partner-ID
    10107

    Standard

    Klicke rechts oben auf <>
    » sponsor me via GitHub or PayPal or Revolut

  5. #5
    Alter Contao-Hase Avatar von Messa
    Registriert seit
    19.01.2011.
    Ort
    Vorarlberg, Österreich
    Beiträge
    1.423

    Standard

    Dann klappt es alle auf - hier 2 Screenshots.

    https://ibb.co/vk4Yc2c
    https://ibb.co/58GgVxV
    Full Service Agentur - Grafikdesign, Screendesign, Webdesign, Webentwicklung, SEO, Weiterbildung, persönliches Coaching
    http://www.matthiasgmeiner.com

  6. #6
    Community-Moderator
    Wandelndes Contao-Lexikon
    Avatar von Spooky
    Registriert seit
    12.04.2012.
    Ort
    Scotland
    Beiträge
    35.517
    Partner-ID
    10107

    Standard

    Die Screenshots zeigen leider nicht die vollständige Ausgabe.
    » sponsor me via GitHub or PayPal or Revolut

  7. #7
    Alter Contao-Hase Avatar von Messa
    Registriert seit
    19.01.2011.
    Ort
    Vorarlberg, Österreich
    Beiträge
    1.423

    Standard

    Ich kann noch aus der Konsole die Sachen kopieren.
    Oder was benötigst du denn genau?

    Code:
    CREATE TABLE tl_mailchimp (id INT UNSIGNED AUTO_INCREMENT NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, listName VARCHAR(255) DEFAULT '' NOT NULL, listApiKey VARCHAR(255) DEFAULT '' NOT NULL, listId VARCHAR(255) DEFAULT '' NOT NULL, fields BLOB DEFAULT NULL, groups BLOB DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    CREATE TABLE tl_pct_themedesigner (id INT UNSIGNED AUTO_INCREMENT NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, theme VARCHAR(128) DEFAULT '' NOT NULL, description VARCHAR(255) DEFAULT '' NOT NULL, active CHAR(1) DEFAULT '' NOT NULL, data BLOB DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    CREATE TABLE tl_search (id INT UNSIGNED AUTO_INCREMENT NOT NULL, pid INT UNSIGNED DEFAULT 0 NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, title TEXT DEFAULT NULL, url VARCHAR(2048) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`, text MEDIUMTEXT DEFAULT NULL, filesize DOUBLE PRECISION DEFAULT '0' NOT NULL, checksum VARCHAR(32) DEFAULT '' NOT NULL, protected CHAR(1) DEFAULT '' NOT NULL, groups BLOB DEFAULT NULL, language VARCHAR(5) DEFAULT '' NOT NULL, vectorLength DOUBLE PRECISION DEFAULT '0' NOT NULL, meta MEDIUMTEXT DEFAULT NULL, UNIQUE INDEX url (url), UNIQUE INDEX checksum_pid (checksum, pid), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    CREATE TABLE tl_search_index (pid INT UNSIGNED NOT NULL, termId INT UNSIGNED NOT NULL, relevance SMALLINT UNSIGNED NOT NULL, INDEX pid (pid), PRIMARY KEY(termid, pid)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    DROP TABLE tl_cfs_map_baselayers
    DROP TABLE tl_cfs_map_locstyles
    DROP TABLE tl_cron
    DROP TABLE tl_extension
    DROP TABLE tl_cfs_map_prof_locstyles
    DROP TABLE tl_cfs_map_prof_services
    DROP TABLE tl_cfs_map_profiles
    DROP TABLE tl_cfs_maps
    DROP TABLE tl_newsletter_recipients_backup
    DROP TABLE tl_crontab
    DROP TABLE tl_member_pages
    DROP TABLE tl_member_to_group
    DROP TABLE tl_nc_gateway
    DROP TABLE tl_nc_language
    DROP TABLE tl_nc_message
    DROP TABLE tl_nc_notification
    DROP TABLE tl_nc_queue
    DROP TABLE tl_repository_installs
    DROP TABLE tl_repository_instfiles
    DROP TABLE tl_session
    DROP TABLE tl_user_to_group
    DROP TABLE tl_videobox
    DROP TABLE tl_videobox_archive
    DROP TABLE tl_videobox_settings
    DROP INDEX pid_start_stop_published_sorting ON tl_article
    ALTER TABLE tl_article CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    ALTER TABLE tl_article CHANGE inColumn inColumn VARCHAR(32) DEFAULT 'main' NOT NULL
    ALTER TABLE tl_article DROP languageMain
    ALTER TABLE tl_article DROP space
    CREATE INDEX pid_published_incolumn_start_stop ON tl_article (pid, published, incolumn, start, stop)
    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 DROP master
    DROP INDEX pid_start_stop_published ON tl_calendar_events
    ALTER TABLE tl_calendar_events CHANGE imageUrl imageUrl VARCHAR(2048) 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 floating floating VARCHAR(32) DEFAULT 'above' NOT NULL
    ALTER TABLE tl_calendar_events CHANGE endTime endTime INT DEFAULT NULL
    ALTER TABLE tl_calendar_events CHANGE startTime startTime INT DEFAULT NULL
    ALTER TABLE tl_calendar_events CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    ALTER TABLE tl_calendar_events DROP videobox_video
    ALTER TABLE tl_calendar_events DROP languageMain
    ALTER TABLE tl_calendar_events DROP cfs_locstyle
    ALTER TABLE tl_calendar_events DROP cfs_loc_label
    ALTER TABLE tl_calendar_events DROP cfs_loc_geoy
    ALTER TABLE tl_calendar_events DROP cfs_loc_geox
    ALTER TABLE tl_calendar_events ADD imageTitle VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_calendar_events ADD address VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_calendar_events ADD description TEXT DEFAULT NULL
    ALTER TABLE tl_calendar_events ADD robots VARCHAR(32) DEFAULT '' NOT NULL
    ALTER TABLE tl_calendar_events ADD pageTitle VARCHAR(255) DEFAULT '' NOT NULL
    CREATE INDEX pid_published_featured_start_stop ON tl_calendar_events (pid, published, featured, start, stop)
    ALTER TABLE tl_calendar_events DROP videobox_addvideo
    ALTER TABLE tl_calendar_events ADD featured CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_calendar_feed CHANGE maxItems maxItems SMALLINT UNSIGNED DEFAULT 25 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 alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    ALTER TABLE tl_calendar_feed ADD imgSize VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_comments ADD notifiedReply CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_comments ADD member INT UNSIGNED DEFAULT 0 NOT NULL
    DROP INDEX source_parent_tokenConfirm ON tl_comments_notify
    ALTER TABLE tl_comments_notify CHANGE url url VARCHAR(2048) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_comments_notify CHANGE email email VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_comments_notify DROP tokenConfirm
    ALTER TABLE tl_comments_notify DROP ip
    CREATE INDEX source_parent_active_email ON tl_comments_notify (source, parent, active, email)
    DROP INDEX pid_ptable_invisible_sorting ON tl_content
    ALTER TABLE tl_content CHANGE overwriteLink overwriteLink CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE overwriteMeta overwriteMeta CHAR(1) CHARACTER SET ascii DEFAULT '' 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 sliderContinuous sliderContinuous CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE playerSize playerSize VARCHAR(64) 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 metaIgnore metaIgnore CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE ptable ptable VARCHAR(64) 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 com_requireLogin com_requireLogin CHAR(1) 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 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 com_template com_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    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 target target CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE imageUrl imageUrl TEXT DEFAULT NULL
    ALTER TABLE tl_content CHANGE url url TEXT DEFAULT 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 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 listtype listtype VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE perRow perRow SMALLINT UNSIGNED DEFAULT 4 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 floating floating VARCHAR(32) CHARACTER SET ascii DEFAULT 'above' 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 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 addImage addImage CHAR(1) CHARACTER SET ascii DEFAULT '' 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 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 invisible invisible CHAR(1) 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_content DROP youtubeStop
    ALTER TABLE tl_content DROP youtubeStart
    ALTER TABLE tl_content DROP videobox_floating
    ALTER TABLE tl_content DROP videobox_video
    ALTER TABLE tl_content DROP movie_order
    ALTER TABLE tl_content DROP audio_order
    ALTER TABLE tl_content DROP audio_ogg
    ALTER TABLE tl_content DROP audio_mp3
    ALTER TABLE tl_content DROP audio_webm
    ALTER TABLE tl_content DROP audio_loop
    ALTER TABLE tl_content DROP audio_autoplay
    ALTER TABLE tl_content DROP audio_preload
    ALTER TABLE tl_content DROP audio_controls
    ALTER TABLE tl_content DROP movie_ogg
    ALTER TABLE tl_content DROP movie_mp4
    ALTER TABLE tl_content DROP movie_webm
    ALTER TABLE tl_content DROP movie_preview
    ALTER TABLE tl_content DROP movie_height
    ALTER TABLE tl_content DROP movie_width
    ALTER TABLE tl_content DROP movie_loop
    ALTER TABLE tl_content DROP movie_autoplay
    ALTER TABLE tl_content DROP movie_preload
    ALTER TABLE tl_content DROP movie_controls
    ALTER TABLE tl_content DROP fullwidth
    ALTER TABLE tl_content DROP fit
    ALTER TABLE tl_content DROP autoplay
    ALTER TABLE tl_content DROP cfs_map_layer_switcher_ext
    ALTER TABLE tl_content DROP cfs_map_layer_switcher_open
    ALTER TABLE tl_content DROP cfs_map_layer_switcher
    ALTER TABLE tl_content DROP cfs_map_default_mapservice
    ALTER TABLE tl_content DROP cfs_map_zoom
    ALTER TABLE tl_content DROP cfs_map_mapsize
    ALTER TABLE tl_content DROP cfs_map_id
    ALTER TABLE tl_content DROP shClass
    ALTER TABLE tl_content DROP space
    ALTER TABLE tl_content ADD useSVG CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_content ADD playerColor VARCHAR(6) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content ADD playerPreload VARCHAR(8) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content ADD splashImage CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content ADD playerAspect VARCHAR(8) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content ADD playerCaption VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_content ADD vimeo VARCHAR(16) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content ADD markdownSource VARCHAR(12) CHARACTER SET ascii DEFAULT 'sourceText' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content ADD inline CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content ADD showPreview CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    CREATE INDEX pid_ptable_invisible_start_stop ON tl_content (pid, ptable, invisible, start, stop)
    CREATE INDEX type ON tl_content (type)
    ALTER TABLE tl_content DROP videobox_description
    ALTER TABLE tl_content ADD data TEXT DEFAULT NULL
    DROP INDEX pid_published_sorting ON tl_faq
    ALTER TABLE tl_faq CHANGE floating floating VARCHAR(12) DEFAULT 'above' NOT NULL
    ALTER TABLE tl_faq CHANGE imageUrl imageUrl VARCHAR(2048) DEFAULT '' NOT NULL
    ALTER TABLE tl_faq CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    ALTER TABLE tl_faq DROP languageMain
    ALTER TABLE tl_faq ADD imageTitle VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_faq ADD description TEXT DEFAULT NULL
    ALTER TABLE tl_faq ADD robots VARCHAR(32) DEFAULT '' NOT NULL
    ALTER TABLE tl_faq ADD pageTitle VARCHAR(255) DEFAULT '' NOT NULL
    CREATE INDEX pid_published ON tl_faq (pid, published)
    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 DROP master
    DROP INDEX path ON tl_files
    ALTER TABLE tl_files CHANGE name name VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    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 ADD lastModified INT UNSIGNED DEFAULT NULL
    CREATE INDEX path ON tl_files (path(768))
    ALTER TABLE tl_form CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    ALTER TABLE tl_form CHANGE format format VARCHAR(12) DEFAULT 'raw' NOT NULL
    ALTER TABLE tl_form CHANGE method method VARCHAR(12) DEFAULT 'POST' NOT NULL
    ALTER TABLE tl_form DROP mcemail
    ALTER TABLE tl_form DROP mcnachname
    ALTER TABLE tl_form DROP mcvorname
    ALTER TABLE tl_form DROP mclists
    ALTER TABLE tl_form DROP tableless
    ALTER TABLE tl_form ADD customTpl VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_form ADD mailerTransport VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_form ADD mailchimpMemberTags LONGBLOB DEFAULT NULL
    ALTER TABLE tl_form ADD mailchimpOptIn TINYINT(1) DEFAULT 0 NOT NULL
    ALTER TABLE tl_form ADD mailchimpConfirmField VARCHAR(128) DEFAULT '' NOT NULL
    ALTER TABLE tl_form ADD mailchimpMergeTags LONGBLOB DEFAULT NULL
    ALTER TABLE tl_form ADD mailchimpGroups LONGBLOB DEFAULT NULL
    ALTER TABLE tl_form ADD enableMailchimp TINYINT(1) DEFAULT 0 NOT NULL
    ALTER TABLE tl_form DROP nc_notification
    ALTER TABLE tl_form ADD mailchimpList INT UNSIGNED DEFAULT 0 NOT NULL
    DROP INDEX pid ON tl_form_field
    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 extensions extensions VARCHAR(255) DEFAULT 'jpg,jpeg,gif,png,pdf,doc,docx,xls,xlsx,ppt,pptx' NOT NULL
    ALTER TABLE tl_form_field CHANGE type type VARCHAR(64) DEFAULT 'text' NOT NULL
    ALTER TABLE tl_form_field DROP countryselect_exclude
    ALTER TABLE tl_form_field DROP countryselect_important
    ALTER TABLE tl_form_field DROP fsType
    ALTER TABLE tl_form_field DROP conditionField
    ALTER TABLE tl_form_field DROP addSubmit
    ALTER TABLE tl_form_field ADD step VARCHAR(10) DEFAULT '' NOT NULL
    ALTER TABLE tl_form_field ADD maxval VARCHAR(10) DEFAULT '' NOT NULL
    ALTER TABLE tl_form_field ADD minval VARCHAR(10) DEFAULT '' NOT NULL
    ALTER TABLE tl_form_field ADD maxImageHeight INT UNSIGNED DEFAULT 0 NOT NULL
    ALTER TABLE tl_form_field ADD maxImageWidth INT UNSIGNED DEFAULT 0 NOT NULL
    ALTER TABLE tl_form_field ADD errorMsg VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_form_field ADD customRgxp VARCHAR(255) DEFAULT '' NOT NULL
    CREATE INDEX pid_invisible ON tl_form_field (pid, invisible)
    ALTER TABLE tl_image_size ADD lazyLoading CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_image_size ADD formats VARCHAR(1024) DEFAULT '' NOT NULL
    ALTER TABLE tl_image_size ADD cssClass VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_layout CHANGE minifyMarkup minifyMarkup CHAR(1) DEFAULT '1' 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 `rows` `rows` VARCHAR(8) DEFAULT '2rwh' NOT NULL
    ALTER TABLE tl_layout CHANGE align align VARCHAR(32) DEFAULT 'center' NOT NULL
    ALTER TABLE tl_layout CHANGE cols cols VARCHAR(8) DEFAULT '2cll' NOT NULL
    ALTER TABLE tl_layout DROP picturefill
    ALTER TABLE tl_layout DROP jSource
    ALTER TABLE tl_layout DROP mooSource
    ALTER TABLE tl_layout DROP sPosition
    ALTER TABLE tl_layout DROP doctype
    ALTER TABLE tl_layout ADD defaultImageDensities VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_layout ADD lightboxSize VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_log DROP ip
    DROP INDEX activation ON tl_member
    DROP INDEX autologin ON tl_member
    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 language language VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_member DROP publicFields
    ALTER TABLE tl_member DROP allowEmail
    ALTER TABLE tl_member DROP autologin
    ALTER TABLE tl_member DROP notes
    ALTER TABLE tl_member DROP jobtitle_bc
    ALTER TABLE tl_member DROP jobtitle
    ALTER TABLE tl_member DROP title_extended
    ALTER TABLE tl_member DROP salutation
    ALTER TABLE tl_member DROP branch
    ALTER TABLE tl_member DROP business_connection
    ALTER TABLE tl_member DROP campaign
    ALTER TABLE tl_member DROP member_pages
    ALTER TABLE tl_member DROP workscope
    ALTER TABLE tl_member DROP resigned
    ALTER TABLE tl_member DROP address2
    ALTER TABLE tl_member DROP joined
    ALTER TABLE tl_member DROP department
    ALTER TABLE tl_member DROP building
    ALTER TABLE tl_member DROP room
    ALTER TABLE tl_member DROP officehours
    ALTER TABLE tl_member DROP description
    ALTER TABLE tl_member DROP title
    ALTER TABLE tl_member DROP activation
    ALTER TABLE tl_member DROP loginCount
    ALTER TABLE tl_member ADD backupCodes TEXT DEFAULT NULL
    ALTER TABLE tl_member ADD secret BINARY(128) DEFAULT NULL
    ALTER TABLE tl_member ADD loginAttempts SMALLINT UNSIGNED DEFAULT 0 NOT NULL
    CREATE INDEX login_disable_start_stop ON tl_member (login, disable, start, stop)
    ALTER TABLE tl_member DROP agreement
    ALTER TABLE tl_member ADD useTwoFactor CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_member DROP createdOn
    ALTER TABLE tl_member ADD trustedTokenVersion INT UNSIGNED DEFAULT 0 NOT NULL
    ALTER TABLE tl_member_group DROP disabledmemberfields
    CREATE INDEX disable_start_stop ON tl_member_group (disable, start, stop)
    ALTER TABLE tl_module CHANGE customTpl customTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE numberOfItems numberOfItems SMALLINT UNSIGNED DEFAULT 3 NOT NULL
    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 news_order news_order VARCHAR(32) CHARACTER SET ascii DEFAULT 'order_date_desc' 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 autologin autologin CHAR(1) 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 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 reg_close reg_close VARCHAR(32) 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 fuzzy fuzzy CHAR(1) 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 list_info_where list_info_where TINYTEXT DEFAULT NULL
    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 cal_ctemplate cal_ctemplate VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE loadFirst loadFirst CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE rss_cache rss_cache INT UNSIGNED DEFAULT 3600 NOT NULL
    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 reg_skipName reg_skipName 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_allowLogin reg_allowLogin CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    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 nl_template nl_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' 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_format news_format VARCHAR(32) CHARACTER SET ascii DEFAULT 'news_month' 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_template news_template 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 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_info list_info TINYTEXT DEFAULT NULL
    ALTER TABLE tl_module CHANGE list_search list_search TINYTEXT DEFAULT NULL
    ALTER TABLE tl_module CHANGE list_sort list_sort TINYTEXT DEFAULT NULL
    ALTER TABLE tl_module CHANGE list_where list_where TINYTEXT DEFAULT NULL
    ALTER TABLE tl_module CHANGE list_fields list_fields TINYTEXT DEFAULT NULL
    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 cal_noSpan cal_noSpan 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_template cal_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    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 disableCaptcha disableCaptcha 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 useCaption useCaption CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE url url TEXT DEFAULT NULL
    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 contextLength contextLength VARCHAR(64) CHARACTER SET ascii DEFAULT '' 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 queryType queryType VARCHAR(8) CHARACTER SET ascii DEFAULT 'and' 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 navigationTpl navigationTpl VARCHAR(64) 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 showHidden showHidden 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 imgSize imgSize VARCHAR(128) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    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 DROP videobox_tpl_reader
    ALTER TABLE tl_module DROP videobox_tpl_list
    ALTER TABLE tl_module DROP videobox_sql
    ALTER TABLE tl_module DROP videobox_jumpTo
    ALTER TABLE tl_module DROP videobox_archives
    ALTER TABLE tl_module DROP mootoolsnavTrigger
    ALTER TABLE tl_module DROP mootoolsnavLevel
    ALTER TABLE tl_module DROP nc_activation_notification
    ALTER TABLE tl_module DROP ml_sort
    ALTER TABLE tl_module DROP ml_fields
    ALTER TABLE tl_module DROP ml_groups
    ALTER TABLE tl_module DROP nc_notification
    ALTER TABLE tl_module DROP memberlist_sort
    ALTER TABLE tl_module DROP randomPageImage
    ALTER TABLE tl_module DROP inheritPageImage
    ALTER TABLE tl_module DROP cfs_map_layer_switcher_ext
    ALTER TABLE tl_module DROP cfs_map_layer_switcher_open
    ALTER TABLE tl_module DROP customLanguageText
    ALTER TABLE tl_module DROP customLanguage
    ALTER TABLE tl_module DROP hideNoFallback
    ALTER TABLE tl_module DROP hideActiveLanguage
    ALTER TABLE tl_module DROP memberlist_where
    ALTER TABLE tl_module DROP cfs_map_layer_switcher
    ALTER TABLE tl_module DROP cfs_map_default_mapservice
    ALTER TABLE tl_module DROP cfs_map_zoom
    ALTER TABLE tl_module DROP cfs_map_mapsize
    ALTER TABLE tl_module DROP cfs_map_id
    ALTER TABLE tl_module DROP tableless
    ALTER TABLE tl_module DROP show_member_name
    ALTER TABLE tl_module DROP singlemember
    ALTER TABLE tl_module DROP memberlist_detailscolumn
    ALTER TABLE tl_module DROP memberlist_showdetailscolumn
    ALTER TABLE tl_module DROP page_editor
    ALTER TABLE tl_module DROP agreement_text
    ALTER TABLE tl_module DROP agreement_headline
    ALTER TABLE tl_module DROP show_agreement
    ALTER TABLE tl_module DROP memberlist_jumpTo
    ALTER TABLE tl_module DROP memberlist_template
    ALTER TABLE tl_module DROP show_searchfield
    ALTER TABLE tl_module DROP member_groups
    ALTER TABLE tl_module DROP member_template
    ALTER TABLE tl_module DROP space
    ALTER TABLE tl_module DROP flashJS
    ALTER TABLE tl_module DROP flashID
    ALTER TABLE tl_module DROP interactive
    ALTER TABLE tl_module DROP transparent
    ALTER TABLE tl_module DROP altContent
    ALTER TABLE tl_module DROP flashvars
    ALTER TABLE tl_module DROP source
    ALTER TABLE tl_module DROP size
    ALTER TABLE tl_module DROP cols
    ALTER TABLE tl_module ADD nl_text TEXT DEFAULT NULL
    ALTER TABLE tl_module ADD cal_featured VARCHAR(16) CHARACTER SET ascii DEFAULT 'all_items' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module ADD cal_hideRunning CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module ADD mailchimpMandatoryInterests BLOB DEFAULT NULL
    ALTER TABLE tl_module ADD mailchimpShowPlaceholder VARCHAR(1) DEFAULT '1' NOT NULL
    ALTER TABLE tl_module ADD mailchimpOptin VARCHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module ADD mailchimpJumpTo INT UNSIGNED DEFAULT 0 NOT NULL
    ALTER TABLE tl_module ADD mailchimpList VARCHAR(128) DEFAULT '' NOT NULL
    ALTER TABLE tl_module ADD rootPageDependentModules BLOB DEFAULT NULL
    ALTER TABLE tl_module ADD data TEXT DEFAULT NULL
    ALTER TABLE tl_module ADD reg_deleteDir CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module ADD overviewPage INT UNSIGNED DEFAULT 0 NOT NULL
    DROP INDEX pid_start_stop_published ON tl_news
    ALTER TABLE tl_news CHANGE imageUrl imageUrl VARCHAR(2048) 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 floating floating VARCHAR(12) DEFAULT 'above' NOT NULL
    ALTER TABLE tl_news CHANGE time time INT DEFAULT 0 NOT NULL
    ALTER TABLE tl_news CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    ALTER TABLE tl_news DROP videobox_video
    ALTER TABLE tl_news DROP videobox_addvideo
    ALTER TABLE tl_news DROP languageMain
    ALTER TABLE tl_news ADD imageTitle VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_news ADD robots VARCHAR(32) DEFAULT '' NOT NULL
    ALTER TABLE tl_news ADD pageTitle VARCHAR(255) DEFAULT '' NOT NULL
    CREATE INDEX pid_published_featured_start_stop ON tl_news (pid, published, featured, start, stop)
    ALTER TABLE tl_news DROP meta_description
    ALTER TABLE tl_news ADD description TEXT DEFAULT NULL
    ALTER TABLE tl_news_archive CHANGE notify notify VARCHAR(16) DEFAULT 'notify_admin' NOT NULL
    ALTER TABLE tl_news_archive CHANGE sortOrder sortOrder VARCHAR(32) DEFAULT 'ascending' NOT NULL
    ALTER TABLE tl_news_archive DROP master
    ALTER TABLE tl_news_feed CHANGE maxItems maxItems SMALLINT UNSIGNED DEFAULT 25 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 alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    ALTER TABLE tl_news_feed ADD imgSize VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_newsletter CHANGE sender sender VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_newsletter CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    ALTER TABLE tl_newsletter ADD mailerTransport VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_newsletter_channel DROP smtpEnc
    ALTER TABLE tl_newsletter_channel DROP smtpPort
    ALTER TABLE tl_newsletter_channel DROP smtpHost
    ALTER TABLE tl_newsletter_channel DROP useSMTP
    ALTER TABLE tl_newsletter_channel ADD sender VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_newsletter_channel ADD mailerTransport VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_newsletter_channel DROP smtpPass
    ALTER TABLE tl_newsletter_channel ADD template VARCHAR(32) DEFAULT '' NOT NULL
    ALTER TABLE tl_newsletter_channel DROP smtpUser
    ALTER TABLE tl_newsletter_channel ADD senderName VARCHAR(128) DEFAULT '' NOT NULL
    DROP INDEX pid ON tl_newsletter_recipients
    ALTER TABLE tl_newsletter_recipients DROP confirmed
    ALTER TABLE tl_newsletter_recipients DROP ip
    ALTER TABLE tl_newsletter_recipients DROP token
    CREATE INDEX active ON tl_newsletter_recipients (active)
    DROP INDEX pid_type_start_stop_published ON tl_page
    DROP INDEX languageMain ON tl_page
    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 useSSL useSSL CHAR(1) DEFAULT '1' NOT NULL
    ALTER TABLE tl_page CHANGE redirect redirect VARCHAR(32) DEFAULT 'permanent' NOT NULL
    ALTER TABLE tl_page CHANGE url url VARCHAR(2048) DEFAULT '' NOT NULL
    ALTER TABLE tl_page CHANGE language language VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_page CHANGE type type VARCHAR(64) DEFAULT 'regular' NOT NULL
    ALTER TABLE tl_page CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    ALTER TABLE tl_page DROP appleTouchIconSRC
    ALTER TABLE tl_page DROP addAppleTouchIcon
    ALTER TABLE tl_page DROP faviconSRC
    ALTER TABLE tl_page DROP addFavicon
    ALTER TABLE tl_page DROP languageQuery
    ALTER TABLE tl_page DROP pageImageTitle
    ALTER TABLE tl_page DROP pageImageAlt
    ALTER TABLE tl_page DROP pageImageJumpTo
    ALTER TABLE tl_page DROP pageImageOrder
    ALTER TABLE tl_page DROP pageImage
    ALTER TABLE tl_page DROP mobileLayout
    ALTER TABLE tl_page DROP languageMain
    ALTER TABLE tl_page DROP languageRoot
    ALTER TABLE tl_page DROP auto_activate_where
    ALTER TABLE tl_page DROP auto_login_activation
    ALTER TABLE tl_page DROP auto_login_registration
    ALTER TABLE tl_page DROP auto_activate_registration
    ALTER TABLE tl_page DROP sitemapName
    ALTER TABLE tl_page DROP createSitemap
    ALTER TABLE tl_page ADD pct_theme_cto INT DEFAULT 0 NOT NULL
    ALTER TABLE tl_page ADD pct_theme_import CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_page ADD pct_theme VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_page ADD twoFactorJumpTo INT UNSIGNED DEFAULT 0 NOT NULL
    ALTER TABLE tl_page ADD enforceTwoFactor CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_page ADD clientCache INT UNSIGNED DEFAULT 0 NOT NULL
    ALTER TABLE tl_page ADD alwaysLoadFromCache CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_page ADD subpageLayout INT UNSIGNED DEFAULT 0 NOT NULL
    ALTER TABLE tl_page ADD validAliasCharacters VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_page ADD canonicalKeepParams VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_page ADD canonicalLink VARCHAR(2048) DEFAULT '' NOT NULL
    ALTER TABLE tl_page ADD enableCanonical CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_page ADD mailerTransport VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_page ADD maintenanceMode CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_page ADD robotsTxt TEXT DEFAULT NULL
    ALTER TABLE tl_page ADD favicon BINARY(16) DEFAULT NULL
    ALTER TABLE tl_page ADD disableLanguageRedirect CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_page ADD redirectBack CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_page ADD routePriority INT DEFAULT 0 NOT NULL
    ALTER TABLE tl_page ADD requireItem CHAR(1) DEFAULT '' NOT NULL
    CREATE INDEX type_dns ON tl_page (type, dns)
    CREATE INDEX pid_published_type_start_stop ON tl_page (pid, published, type, start, stop)
    ALTER TABLE tl_pct_customelement CHANGE alias alias VARCHAR(128) CHARACTER SET utf8 DEFAULT '' NOT NULL COLLATE `utf8_bin`
    ALTER TABLE tl_pct_customelement DROP template_mod
    ALTER TABLE tl_pct_customelement DROP template_cte
    ALTER TABLE tl_pct_customelement ADD isWrapper VARCHAR(8) DEFAULT '' NOT NULL
    ALTER TABLE tl_pct_customelement_attribute CHANGE alias alias VARCHAR(128) CHARACTER SET utf8 DEFAULT '' NOT NULL COLLATE `utf8_bin`
    ALTER TABLE tl_pct_customelement_attribute ADD galleryTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_pct_customelement_group CHANGE alias alias VARCHAR(128) CHARACTER SET utf8 DEFAULT '' NOT NULL COLLATE `utf8_bin`
    ALTER TABLE tl_pct_customelement_vault CHANGE data_blob data_blob LONGBLOB DEFAULT 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 DROP disablePie
    ALTER TABLE tl_undo ADD preview MEDIUMBLOB DEFAULT NULL
    ALTER TABLE tl_user CHANGE protect_pct_customelement_attributes protect_pct_customelement_attributes BLOB DEFAULT NULL
    ALTER TABLE tl_user CHANGE protect_pct_customelement_groups protect_pct_customelement_groups BLOB DEFAULT NULL
    ALTER TABLE tl_user CHANGE useCE useCE CHAR(1) DEFAULT '1' NOT NULL
    ALTER TABLE tl_user CHANGE inherit inherit VARCHAR(12) DEFAULT 'group' NOT NULL
    ALTER TABLE tl_user CHANGE thumbnails thumbnails CHAR(1) DEFAULT '1' NOT NULL
    ALTER TABLE tl_user CHANGE useRTE useRTE CHAR(1) DEFAULT '1' NOT NULL
    ALTER TABLE tl_user CHANGE showHelp showHelp CHAR(1) DEFAULT '1' NOT NULL
    ALTER TABLE tl_user CHANGE language language VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_user CHANGE password password VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_user CHANGE username username VARCHAR(64) DEFAULT NULL COLLATE `utf8mb4_bin`
    ALTER TABLE tl_user DROP videobox_operations
    ALTER TABLE tl_user DROP videobox_archives
    ALTER TABLE tl_user DROP rocksolidFrontendHelperLightbox
    ALTER TABLE tl_user DROP rocksolidFrontendHelper
    ALTER TABLE tl_user DROP rocksolidFrontendHelperOperations
    ALTER TABLE tl_user DROP pct_customelement_pluginsp
    ALTER TABLE tl_user DROP pct_customelement_plugins
    ALTER TABLE tl_user DROP loginCount
    ALTER TABLE tl_user ADD trustedTokenVersion INT UNSIGNED DEFAULT 0 NOT NULL
    ALTER TABLE tl_user ADD backupCodes TEXT DEFAULT NULL
    ALTER TABLE tl_user ADD loginAttempts SMALLINT UNSIGNED DEFAULT 0 NOT NULL
    ALTER TABLE tl_user ADD useTwoFactor CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_user ADD secret BINARY(128) DEFAULT NULL
    ALTER TABLE tl_user ADD amg BLOB DEFAULT NULL
    ALTER TABLE tl_user ADD fields BLOB DEFAULT NULL
    ALTER TABLE tl_user ADD elements BLOB DEFAULT NULL
    ALTER TABLE tl_user DROP protect_pct_customelement_plugins
    ALTER TABLE tl_user ADD fullscreen CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_user_group CHANGE protect_pct_customelement_attributes protect_pct_customelement_attributes BLOB DEFAULT NULL
    ALTER TABLE tl_user_group CHANGE protect_pct_customelement_groups protect_pct_customelement_groups BLOB DEFAULT NULL
    ALTER TABLE tl_user_group DROP videobox_operations
    ALTER TABLE tl_user_group DROP videobox_archives
    ALTER TABLE tl_user_group DROP rocksolidFrontendHelperOperations
    ALTER TABLE tl_user_group DROP pct_customelement_pluginsp
    ALTER TABLE tl_user_group DROP pct_customelement_plugins
    ALTER TABLE tl_user_group DROP protect_pct_customelement_plugins
    ALTER TABLE tl_user_group ADD amg BLOB DEFAULT NULL
    DROP INDEX pid ON tl_version
    DROP INDEX fromTable ON tl_version
    ALTER TABLE tl_version CHANGE editUrl editUrl TEXT DEFAULT NULL
    CREATE UNIQUE INDEX pid_fromtable_version ON tl_version (pid, fromtable, version)
    CREATE INDEX userid ON tl_version (userid)
    DROP INDEX alias ON tl_article
    ALTER TABLE tl_article ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_article CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    ALTER TABLE tl_calendar ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_calendar CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX alias ON tl_calendar_events
    ALTER TABLE tl_calendar_events ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_calendar_events CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX alias ON tl_calendar_feed
    ALTER TABLE tl_calendar_feed ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_calendar_feed CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX source_parent_published ON tl_comments
    DROP INDEX published ON tl_comments
    ALTER TABLE tl_comments ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_comments CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX tokenRemove ON tl_comments_notify
    ALTER TABLE tl_comments_notify ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_comments_notify CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    ALTER TABLE tl_content ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_content CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    ALTER TABLE tl_faq ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_faq CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    ALTER TABLE tl_faq_category ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_faq_category CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX pid ON tl_files
    DROP INDEX extension ON tl_files
    DROP INDEX uuid ON tl_files
    ALTER TABLE tl_files ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_files CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX alias ON tl_form
    ALTER TABLE tl_form ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_form CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    ALTER TABLE tl_form_field ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_form_field CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX pid ON tl_image_size
    ALTER TABLE tl_image_size ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_image_size CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX pid ON tl_image_size_item
    ALTER TABLE tl_image_size_item ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_image_size_item CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    ALTER TABLE tl_layout ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_layout CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    ALTER TABLE tl_log ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_log CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX email ON tl_member
    DROP INDEX username ON tl_member
    ALTER TABLE tl_member ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_member CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    ALTER TABLE tl_member_group ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_member_group CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    ALTER TABLE tl_module ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_module CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX alias ON tl_news
    ALTER TABLE tl_news ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_news CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    ALTER TABLE tl_news_archive ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_news_archive CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX alias ON tl_news_feed
    ALTER TABLE tl_news_feed ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_news_feed CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX pid ON tl_newsletter
    ALTER TABLE tl_newsletter ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_newsletter CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    ALTER TABLE tl_newsletter_channel ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_newsletter_channel CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX email ON tl_newsletter_recipients
    DROP INDEX pid_email ON tl_newsletter_recipients
    ALTER TABLE tl_newsletter_recipients ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_newsletter_recipients CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX alias ON tl_page
    ALTER TABLE tl_page ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_page CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX alias ON tl_pct_customelement
    ALTER TABLE tl_pct_customelement ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_pct_customelement CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX pid ON tl_pct_customelement_attribute
    ALTER TABLE tl_pct_customelement_attribute ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_pct_customelement_attribute CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX tstamp ON tl_pct_customelement_group
    DROP INDEX pid ON tl_pct_customelement_group
    ALTER TABLE tl_pct_customelement_group ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_pct_customelement_group CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    ALTER TABLE tl_pct_customelement_plugin ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_pct_customelement_plugin CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX pid ON tl_pct_customelement_vault
    DROP INDEX source ON tl_pct_customelement_vault
    ALTER TABLE tl_pct_customelement_vault ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_pct_customelement_vault CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX tstamp ON tl_revolutionslider
    ALTER TABLE tl_revolutionslider ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_revolutionslider CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX pid ON tl_revolutionslider_slides
    ALTER TABLE tl_revolutionslider_slides ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_revolutionslider_slides CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX pid ON tl_style
    ALTER TABLE tl_style ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_style CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX name ON tl_style_sheet
    ALTER TABLE tl_style_sheet ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_style_sheet CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    ALTER TABLE tl_theme ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_theme CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    ALTER TABLE tl_undo ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_undo CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX username ON tl_user
    DROP INDEX email ON tl_user
    ALTER TABLE tl_user ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_user CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    ALTER TABLE tl_user_group ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_user_group CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    ALTER TABLE tl_version ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    ALTER TABLE tl_version CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    Full Service Agentur - Grafikdesign, Screendesign, Webdesign, Webentwicklung, SEO, Weiterbildung, persönliches Coaching
    http://www.matthiasgmeiner.com

  8. #8
    Community-Moderator
    Wandelndes Contao-Lexikon
    Avatar von Spooky
    Registriert seit
    12.04.2012.
    Ort
    Scotland
    Beiträge
    35.517
    Partner-ID
    10107

    Standard

    Zitat Zitat von Messa Beitrag anzeigen
    Oder was benötigst du denn genau?
    Die eigentliche Fehlermeldung(en) . Aber ich glaube der Contao Manager zeigt die leider nicht an. Hast du SSH Zugriff?
    » sponsor me via GitHub or PayPal or Revolut

  9. #9
    Alter Contao-Hase Avatar von Messa
    Registriert seit
    19.01.2011.
    Ort
    Vorarlberg, Österreich
    Beiträge
    1.423

    Standard

    Ja habe ich. Was für ein Befehl soll ich ausführen?
    Full Service Agentur - Grafikdesign, Screendesign, Webdesign, Webentwicklung, SEO, Weiterbildung, persönliches Coaching
    http://www.matthiasgmeiner.com

  10. #10
    Community-Moderator
    Wandelndes Contao-Lexikon
    Avatar von Spooky
    Registriert seit
    12.04.2012.
    Ort
    Scotland
    Beiträge
    35.517
    Partner-ID
    10107

    Standard

    Code:
    vendor/bin/contao-console contao:migrate --no-interaction
    » sponsor me via GitHub or PayPal or Revolut

  11. #11
    Alter Contao-Hase Avatar von Messa
    Registriert seit
    19.01.2011.
    Ort
    Vorarlberg, Österreich
    Beiträge
    1.423

    Standard

    Perfekt mit

    Code:
    php vendor/bin/contao-console contao:migrate --no-interaction
    ging's durch sind nur noch die drops offen -das ist perfekt so

    Danke
    Full Service Agentur - Grafikdesign, Screendesign, Webdesign, Webentwicklung, SEO, Weiterbildung, persönliches Coaching
    http://www.matthiasgmeiner.com

  12. #12
    Contao-Nutzer
    Registriert seit
    15.08.2009.
    Beiträge
    188

    Standard

    Wenn ich den Befehl
    Code:
    php vendor/bin/contao-console contao:migrate --no-interaction
    eingebe, erhalte ich über Putty "Command "contao:migrate" is not defined

  13. #13
    Contao-Fan
    Registriert seit
    10.06.2021.
    Beiträge
    255
    Contao-Projekt unterstützen

    Support Contao

    Standard

    Zitat Zitat von derolli Beitrag anzeigen
    Wenn ich den Befehl eingebe, erhalte ich über Putty "Command "contao:migrate" is not defined
    Welche Contao Version?

  14. #14
    Contao-Nutzer
    Registriert seit
    15.08.2009.
    Beiträge
    188

    Standard

    Der Kunde nutz bei seinem Prrojekt noch 4.4.57. Das Update auf 4.9.42 bzw. 4.13.39 durch, aber es wird dann angezeigt, dass es ein Problem mit der Datenbank gibt.
    Ich habe dann ein Backup auf die 4.4.57 eingespielt und dann das Install-Tool ausgeführt.

    Hier können können aber einige Spalten nicht geändert werden:
    Code:
     	
    
    ALTER TABLE tl_article CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8_bin`
    ALTER TABLE tl_form CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8_bin`
    ALTER TABLE tl_member CHANGE username username VARCHAR(64) DEFAULT NULL COLLATE `utf8_bin`
    ALTER TABLE tl_news CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8_bin`
    ALTER TABLE tl_news_feed CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8_bin`
    ALTER TABLE tl_newsletter CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8_bin`
    ALTER TABLE tl_page CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8_bin`
    ALTER TABLE tl_pct_customelement CHANGE alias alias VARCHAR(128) DEFAULT '' NOT NULL COLLATE `utf8_bin`
    ALTER TABLE tl_pct_customelement_attribute CHANGE alias alias VARCHAR(128) DEFAULT '' NOT NULL COLLATE `utf8_bin`
    ALTER TABLE tl_pct_customelement_group CHANGE alias alias VARCHAR(128) DEFAULT '' NOT NULL COLLATE `utf8_bin`
    ALTER TABLE tl_search_index CHANGE word word VARCHAR(64) DEFAULT '' NOT NULL COLLATE `utf8_bin`
    ALTER TABLE tl_user CHANGE username username VARCHAR(64) DEFAULT NULL COLLATE `utf8_bin`
    Wenn man auf Datenbank aktualsieren klickt, passt nichts. Aus diesem Grund habe ich gedacht, ich probiere es über SSH. Leider erfolglos.

  15. #15
    Community-Moderator
    Wandelndes Contao-Lexikon
    Avatar von Spooky
    Registriert seit
    12.04.2012.
    Ort
    Scotland
    Beiträge
    35.517
    Partner-ID
    10107

    Standard

    Du musst auf Contao 4.13 aktualisieren und dann contao:migrate ausführen.
    » sponsor me via GitHub or PayPal or Revolut

  16. #16
    Contao-Nutzer
    Registriert seit
    15.08.2009.
    Beiträge
    188

    Standard

    Stimmt. Hatte das blaue Fenster übersehen, wo vermerkt ist, dass es erst ab 4.9 funktioniert.

    Über Putty erhalte ich nun Undefined constant 'PCT_TABLETREE_VERSION'

  17. #17
    Community-Moderator
    Wandelndes Contao-Lexikon
    Avatar von Spooky
    Registriert seit
    12.04.2012.
    Ort
    Scotland
    Beiträge
    35.517
    Partner-ID
    10107

    Standard

    Zitat Zitat von derolli Beitrag anzeigen
    Über Putty erhalte ich nun Undefined constant 'PCT_TABLETREE_VERSION'
    Für das Update auf 4.13 wirst du auch die Module des PCT Themes aktualisieren müssen.
    » sponsor me via GitHub or PayPal or Revolut

  18. #18
    Contao-Nutzer
    Registriert seit
    15.08.2009.
    Beiträge
    188

    Standard

    Das Modul war damals Bestandteil vom SmallBiz. Für das Modul scheint es keine Updates mehr zu geben.

  19. #19
    Community-Moderatorin & Contao-Urgestein Avatar von mlweb
    Registriert seit
    10.07.2011.
    Beiträge
    7.080
    Contao-Projekt unterstützen

    Support Contao

    Standard

    Dann wirst Du es unter Umständen selbst anpassen oder es Dir gegen Bezahlung anpassen lassen müssen.
    PCT hat glaube ich nur noch ein Theme, dass mit Contao 4 kompatibel ist, die Module sind aber regelmäßig angepasst worden soweit ich weiss ggf. wirst Du im PCT-Forum fündig.
    Ich habe Dir mit meinen Hinweisen geholfen und Du möchtest Dich bedanken?
    Unterstütze bitte das Contao-Projekt (Button Links)
    Weitere Spendenmöglichkeiten
    ------------------------------------------------------------------------------------------------------
    Contao-Dokumentation: Contao-Handbuch und Contao-Entwickler-Doku
    Contao-Online-Video-Kurse: Contao Academy
    Funktionalität erweitern: Contao-Erweiterungen

    Für Dinge die man mit html5 und css3 lösen kann, braucht man kein javascript.




  20. #20
    Contao-Nutzer
    Registriert seit
    15.08.2009.
    Beiträge
    188

    Standard

    @mlweb: vielen Dank. Wir haben die passenden Installationsdateien gefunden und erfolgreich aktualisiert.

Aktive Benutzer

Aktive Benutzer

Aktive Benutzer in diesem Thema: 1 (Registrierte Benutzer: 0, Gäste: 1)

Berechtigungen

  • Neue Themen erstellen: Nein
  • Themen beantworten: Nein
  • Anhänge hochladen: Nein
  • Beiträge bearbeiten: Nein
  •