Nach Update sehr viele ALTER Table bezüglich Unicode utf8mb4_unicode_ci -> Fehler

**Kahmoon** · 06.06.2022, 09:59

Hallo zusammen,

ich habe gerade meine Installation auf die neuste Version gehoben. Im Anschluss wil ldas Installtool wirklich viele Änderungen machen. Leider laufen die alle auf Fehler.

Installtool:

Code:

ALTER TABLE tl_crawl_queue CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX name ON tl_cron_job
	
ALTER TABLE tl_cron_job CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX series ON tl_remember_me
	
DROP INDEX value ON tl_remember_me
	
ALTER TABLE tl_remember_me CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
ALTER TABLE tl_trusted_device CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX pid_published_incolumn_start_stop ON tl_article
	
DROP INDEX alias ON tl_article
	
ALTER TABLE tl_article CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
ALTER TABLE tl_bs_grid CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
ALTER TABLE tl_calendar CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX alias ON tl_calendar_events
	
DROP INDEX pid_published_featured_start_stop ON tl_calendar_events
	
ALTER TABLE tl_calendar_events CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX member ON tl_calendar_events_subscription
	
DROP INDEX pid ON tl_calendar_events_subscription
	
ALTER TABLE tl_calendar_events_subscription CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX alias ON tl_calendar_feed
	
ALTER TABLE tl_calendar_feed CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX source_parent_published ON tl_comments
	
DROP INDEX published ON tl_comments
	
ALTER TABLE tl_comments CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX source_parent_active_email ON tl_comments_notify
	
DROP INDEX tokenremove ON tl_comments_notify
	
ALTER TABLE tl_comments_notify CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX type ON tl_content
	
DROP INDEX pid_ptable_invisible_start_stop ON tl_content
	
ALTER TABLE tl_content CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX pid_published ON tl_cookie
	
ALTER TABLE tl_cookie CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX published ON tl_cookie_config
	
ALTER TABLE tl_cookie_config CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX pid_published ON tl_cookie_group
	
ALTER TABLE tl_cookie_group CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX cid ON tl_cookie_log
	
ALTER TABLE tl_cookie_log CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
ALTER TABLE tl_cookiebar CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
ALTER TABLE tl_db_cache CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX pid ON tl_dlstatdets
	
ALTER TABLE tl_dlstatdets CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX filename ON tl_dlstats
	
ALTER TABLE tl_dlstats CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
ALTER TABLE tl_dlstats_blocker CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX pid_published ON tl_faq
	
ALTER TABLE tl_faq CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
ALTER TABLE tl_faq_category CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX path ON tl_files
	
DROP INDEX extension ON tl_files
	
DROP INDEX pid ON tl_files
	
DROP INDEX uuid ON tl_files
	
ALTER TABLE tl_files CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX leadenabled ON tl_form
	
DROP INDEX leadenabled_leadmaster ON tl_form
	
DROP INDEX leadmaster ON tl_form
	
DROP INDEX alias ON tl_form
	
ALTER TABLE tl_form CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX pid_invisible ON tl_form_field
	
ALTER TABLE tl_form_field CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX pid ON tl_image_size
	
ALTER TABLE tl_image_size CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX pid ON tl_image_size_item
	
ALTER TABLE tl_image_size_item CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
ALTER TABLE tl_layout CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX master_id ON tl_lead
	
ALTER TABLE tl_lead CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX master_id ON tl_lead_data
	
DROP INDEX pid ON tl_lead_data
	
ALTER TABLE tl_lead_data CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX pid ON tl_lead_export
	
ALTER TABLE tl_lead_export CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
ALTER TABLE tl_log CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX email ON tl_member
	
DROP INDEX login_disable_start_stop ON tl_member
	
DROP INDEX username ON tl_member
	
ALTER TABLE tl_member CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX disable_start_stop ON tl_member_group
	
ALTER TABLE tl_member_group CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
ALTER TABLE tl_module CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX queue_croninterval ON tl_nc_gateway
	
ALTER TABLE tl_nc_gateway CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX language ON tl_nc_language
	
DROP INDEX pid ON tl_nc_language
	
ALTER TABLE tl_nc_language CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX pid ON tl_nc_message
	
ALTER TABLE tl_nc_message CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
ALTER TABLE tl_nc_notification CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX message ON tl_nc_queue
	
DROP INDEX targetgateway ON tl_nc_queue
	
DROP INDEX sourcequeue ON tl_nc_queue
	
ALTER TABLE tl_nc_queue CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX alias ON tl_news
	
DROP INDEX pid_published_featured_start_stop ON tl_news
	
ALTER TABLE tl_news CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
ALTER TABLE tl_news_archive CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX alias ON tl_news_feed
	
ALTER TABLE tl_news_feed CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX pid ON tl_newsletter
	
ALTER TABLE tl_newsletter CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
ALTER TABLE tl_newsletter_channel CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX pid_hash ON tl_newsletter_deny_list
	
ALTER TABLE tl_newsletter_deny_list CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX active ON tl_newsletter_recipients
	
DROP INDEX pid_email ON tl_newsletter_recipients
	
DROP INDEX email ON tl_newsletter_recipients
	
ALTER TABLE tl_newsletter_recipients CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
ALTER TABLE tl_om_backend_element_classes CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
ALTER TABLE tl_om_backend_links_main CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
ALTER TABLE tl_om_backend_links_top CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
ALTER TABLE tl_om_backend_sysinfo CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX removeon ON tl_opt_in
	
DROP INDEX token ON tl_opt_in
	
ALTER TABLE tl_opt_in CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX reltable_relid ON tl_opt_in_related
	
ALTER TABLE tl_opt_in_related CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX alias ON tl_page
	
DROP INDEX type_dns ON tl_page
	
DROP INDEX pid_published_type_start_stop ON tl_page
	
ALTER TABLE tl_page CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX id_published_expiresat ON tl_preview_link
	
ALTER TABLE tl_preview_link CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX pid_member_starttime_endtime ON tl_resource_booking
	
DROP INDEX timeslotid ON tl_resource_booking
	
ALTER TABLE tl_resource_booking CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX published_pid ON tl_resource_booking_resource
	
ALTER TABLE tl_resource_booking_resource CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
ALTER TABLE tl_resource_booking_resource_type CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX pid ON tl_resource_booking_time_slot
	
ALTER TABLE tl_resource_booking_time_slot CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
ALTER TABLE tl_resource_booking_time_slot_type CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX pid ON tl_rocksolid_slide
	
ALTER TABLE tl_rocksolid_slide CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
ALTER TABLE tl_rocksolid_slider CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX checksum_pid ON tl_search
	
DROP INDEX url ON tl_search
	
ALTER TABLE tl_search CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX pid ON tl_search_index
	
ALTER TABLE tl_search_index CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX term ON tl_search_term
	
DROP INDEX documentfrequency ON tl_search_term
	
ALTER TABLE tl_search_term CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX pid ON tl_style
	
ALTER TABLE tl_style CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX name ON tl_style_sheet
	
ALTER TABLE tl_style_sheet CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
ALTER TABLE tl_theme CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
ALTER TABLE tl_undo CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX email ON tl_user
	
DROP INDEX username ON tl_user
	
ALTER TABLE tl_user CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
ALTER TABLE tl_user_group CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
	
DROP INDEX pid_fromtable_version ON tl_version
	
DROP INDEX userid ON tl_version
	
ALTER TABLE tl_version CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci
Spalten ändern
	Alle auswählen
	
ALTER TABLE tl_comments_notify CHANGE url url VARCHAR(2048) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Spalten anlegen
	Alle auswählen
	
CREATE INDEX job_id ON tl_crawl_queue (job_id)
	
CREATE INDEX uri_hash ON tl_crawl_queue (uri_hash)
	
CREATE INDEX processed ON tl_crawl_queue (processed)

Und die Fehlermeldung im System Log

Code:

[2022-06-06T10:56:43.035473+02:00] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_unicode_ci' is not valid for CHARACTER SET 'utf8'" at /homepages/46/xxx/htdocs/xxx-v3/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 119 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 1253): An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_unicode_ci' is not valid for CHARACTER SET 'utf8' at /homepages/46/xxx/htdocs/xxx-v3/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:119)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1253): SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_unicode_ci' is not valid for CHARACTER SET 'utf8' at /homepages/46/xxx/htdocs/xxx-v3/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:30)\n[previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_unicode_ci' is not valid for CHARACTER SET 'utf8' at /homepages/46/xxx/htdocs/xxx-v3/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:34)"} []

**Spooky** · 06.06.2022, 10:16

Poste deine config.yaml

**Kahmoon** · 06.06.2022, 10:21

Ich hatte erst

Code:

doctrine:
    dbal:
        connections:
            default:
                default_table_options:
                    charset: utf8
                    collate: utf8_unicode_ci
                options:
                    1002: "SET SESSION sql_mode=(SELECT CONCAT(@@sql_mode, ',TRADITIONAL'))"
framework:
    session:
        cookie_secure: auto
        
    mailer:
        transports:
            info: 
            anmeldung: 
            admin: 
            webmaster: 
contao:
    localconfig:
        sessionTimeout: 14200
        dateFormat: 'd.m.Y'
        datimFormat: 'd.m.Y H:i'
        timeFormat: 'H:i'
        maxFileSize: 20480000
        imageWidth: 4000
        imageHeight: 2000
        gdMaxImgHeight: 6000
        gdMaxImgWidth: 6000
        timeZone: 'Europe/Berlin'
    mailer:
        transports:
            info:
                from: 
            anmeldung:
                from: 
            admin:
                from: 
            webmaster:
                from: 
    backend:
        custom_css:
            - files/backend/custom.css
    search:
        # Enable indexing of protected pages.
        index_protected: true
contao_cookiebar:
  iframe_types:
    youtube: 
      - ce_youtube
  page_templates:
    - fe_page
    - fe_bootstrap

Habe dann aber durch einen anderen Thread den ganzen Block doctrine entfernt, was aber nicht geholfen hat.

Composer json hat aber noch was mit doctrine drin

Code:

    "conflict": {
        "doctrine/doctrine-bundle": "<1.12.8"
    },

**Spooky** · 06.06.2022, 10:22

Zitat von Kahmoon

Habe dann aber durch einen anderen Thread den ganzen Block doctrine entfernt, was aber nicht geholfen hat.

Hast du den Symfony Application Cache danach neu aufgebaut?

**Kahmoon** · 06.06.2022, 10:23

Systemwartung -> Prod. Cache habe ich geleert ja.

**Spooky** · 06.06.2022, 10:24

Und welcher Fehler tritt dann im Install Tool auf?

**Kahmoon** · 06.06.2022, 10:28

Oben genannte Änderungswünsche an der DB. Beim Aktualisieren steht im

Prod Log.

Code:

[2022-06-06T11:20:16.296470+02:00] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'path'" at /homepages/46/xx/htdocs/xx-v3/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 119 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 1061): An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'path' at /homepages/46/xx/htdocs/xx-v3/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:119)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1061): SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'path' at /homepages/46/xx/htdocs/xx-v3/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:30)\n[previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'path' at /homepages/46/xx/htdocs/xx-v3/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:34)"} []

MySQL 5.7

Weiss nicht warum er trotzdem versucht es in utf8mb4_unicode_ci zu konvertieren

**Spooky** · 06.06.2022, 10:36

Zitat von Kahmoon

Weiss nicht warum er trotzdem versucht es in utf8mb4_unicode_ci zu konvertieren

Tut er ja nicht. Das ist jetzt ein anderer Fehler.

Zitat von Kahmoon

Beim Aktualisieren steht im

Prod Log.

Das heißt beim Aktualisieren tritt nun kein Fehler mehr auf? Dann passt es ja jetzt.

**Kahmoon** · 06.06.2022, 10:48

Doch, sobald ich auf aktualisieren drücke crashed er mit vorher genannten Fehler im Log. Lade ich das Installtool neu, stehen die DB Änderungswünsche unverändert da.

**Spooky** · 06.06.2022, 10:59

Zitat von Kahmoon

Doch, sobald ich auf aktualisieren drücke crashed er mit vorher genannten Fehler im Log.

Welcher Fehler nun genau? Du hast nun zwei verschiedene Fehler genannt. Nutze außerdem den Debug-Modus, damit du immer den Stack Trace posten kannst.

**Kahmoon** · 06.06.2022, 11:36

Ich habe jetzt mal alle Logs gelöscht. Anscheinend waren da alte Fehler drin.

Wenn ich im Installtool die DB Aktualisieren will kommt: "Es ist ein Fehler aufgetreten". Kein Fehler im system/log bzw. es wird kein neues Log geschrieben.

In der config.yml habe ich alle doctrine Anweisungen entfernt. Deenoch versucht er dieses utf8mb4_unicode_ci zu machen

Code:


ALTER TABLE tl_crawl_queue CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

Debugmodus Stack Trace

Code:

InvalidArgumentException:
Invalid hash: 5daad3179081abf3e69899a14604cd00


  at vendor/contao/installation-bundle/src/Database/Installer.php:90
  at Contao\InstallationBundle\Database\Installer->execCommand('5daad3179081abf3e69899a14604cd00')
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:390)
  at Contao\InstallationBundle\Controller\InstallationController->adjustDatabaseTables()
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:100)
  at Contao\InstallationBundle\Controller\InstallationController->installAction()
     (vendor/symfony/http-kernel/HttpKernel.php:152)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:74)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:202)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (web/index.php:44)

Allerdings sind dort im Reiter "Logs" einige Einträge. Siehe Screenshot.

**Spooky** · 06.06.2022, 11:50

Zitat von Kahmoon

Ich habe jetzt mal alle Logs gelöscht. Anscheinend waren da alte Fehler drin.

Immer Debug-Modus nutzen, wenn du Fehler behandelst.

Zitat von Kahmoon

Wenn ich im Installtool die DB Aktualisieren will kommt: "Es ist ein Fehler aufgetreten". Kein Fehler im system/log bzw. es wird kein neues Log geschrieben.

Immer den Debug-Modus nutzen.

Zitat von Kahmoon

In der config.yml habe ich alle doctrine Anweisungen entfernt. Deenoch versucht er dieses utf8mb4_unicode_ci zu machen

Das ist in diesem Fall normal.

Zitat von Kahmoon

Debugmodus Stack Trace

Code:

InvalidArgumentException:
Invalid hash: 5daad3179081abf3e69899a14604cd00

Da hast du im Install Tool vermutlich einen Browser Refresh versucht. Fange von vorne an.

**Spooky** · 06.06.2022, 11:57

Ansonsten, zum ursprünglichen Fehler: https://github.com/contao/contao/issues/4798

**Kahmoon** · 06.06.2022, 12:05

OK, ich habe von vorne angefangen. Jetzt ist wieder ein Doctrine Fehler im Stack Trace

Zu langer Dateiname bei einer meiner Dateien!?

Code:

Doctrine\DBAL\Exception\DriverException:
An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 3072 bytes


  at vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:119
  at Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(object(Exception), object(Query))
     (vendor/doctrine/dbal/src/Connection.php:1814)
  at Doctrine\DBAL\Connection->handleDriverException(object(Exception), object(Query))
     (vendor/doctrine/dbal/src/Connection.php:1749)
  at Doctrine\DBAL\Connection->convertExceptionDuringQuery(object(Exception), 'ALTER TABLE tl_files CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci', array(), array())
     (vendor/doctrine/dbal/src/Connection.php:1163)
  at Doctrine\DBAL\Connection->executeStatement('ALTER TABLE tl_files CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci')
     (vendor/contao/installation-bundle/src/Database/Installer.php:84)
  at Contao\InstallationBundle\Database\Installer->execCommand('2f4b3d22e21b1f7d6768a7a3b3da2885')
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:390)
  at Contao\InstallationBundle\Controller\InstallationController->adjustDatabaseTables()
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:100)
  at Contao\InstallationBundle\Controller\InstallationController->installAction()
     (vendor/symfony/http-kernel/HttpKernel.php:152)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:74)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:202)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (web/index.php:44)

Code:

Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 3072 bytes


  at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:30
  at Doctrine\DBAL\Driver\PDO\Exception::new(object(PDOException))
     (vendor/doctrine/dbal/src/Driver/PDO/Connection.php:40)
  at Doctrine\DBAL\Driver\PDO\Connection->exec('ALTER TABLE tl_files CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci')
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:47)
  at Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->exec('ALTER TABLE tl_files CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci')
     (vendor/doctrine/dbal/src/Logging/Connection.php:53)
  at Doctrine\DBAL\Logging\Connection->exec('ALTER TABLE tl_files CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci')
     (vendor/doctrine/dbal/src/Connection.php:1161)
  at Doctrine\DBAL\Connection->executeStatement('ALTER TABLE tl_files CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci')
     (vendor/contao/installation-bundle/src/Database/Installer.php:84)
  at Contao\InstallationBundle\Database\Installer->execCommand('2f4b3d22e21b1f7d6768a7a3b3da2885')
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:390)
  at Contao\InstallationBundle\Controller\InstallationController->adjustDatabaseTables()
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:100)
  at Contao\InstallationBundle\Controller\InstallationController->installAction()
     (vendor/symfony/http-kernel/HttpKernel.php:152)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:74)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:202)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (web/index.php:44)

**Spooky** · 06.06.2022, 12:08

Poste mal die Liste an DB Updates, die das Install Tool durchführen will.

**Kahmoon** · 06.06.2022, 12:09

Viele! :-D

Code:

Tabellen ändern
    Alle auswählen
    
ALTER TABLE tl_files CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
DROP INDEX leadmaster ON tl_form
    
DROP INDEX alias ON tl_form
    
DROP INDEX leadenabled ON tl_form
    
DROP INDEX leadenabled_leadmaster ON tl_form
    
ALTER TABLE tl_form CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
DROP INDEX pid_invisible ON tl_form_field
    
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 CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
DROP INDEX pid ON tl_image_size_item
    
ALTER TABLE tl_image_size_item CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
ALTER TABLE tl_layout CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
DROP INDEX master_id ON tl_lead
    
ALTER TABLE tl_lead CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
DROP INDEX pid ON tl_lead_data
    
DROP INDEX master_id ON tl_lead_data
    
ALTER TABLE tl_lead_data CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
DROP INDEX pid ON tl_lead_export
    
ALTER TABLE tl_lead_export CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
ALTER TABLE tl_log CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
DROP INDEX login_disable_start_stop ON tl_member
    
DROP INDEX username ON tl_member
    
DROP INDEX email ON tl_member
    
ALTER TABLE tl_member CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
DROP INDEX disable_start_stop ON tl_member_group
    
ALTER TABLE tl_member_group CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
ALTER TABLE tl_module CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
DROP INDEX queue_croninterval ON tl_nc_gateway
    
ALTER TABLE tl_nc_gateway CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
DROP INDEX pid ON tl_nc_language
    
DROP INDEX language ON tl_nc_language
    
ALTER TABLE tl_nc_language CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
DROP INDEX pid ON tl_nc_message
    
ALTER TABLE tl_nc_message CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
ALTER TABLE tl_nc_notification CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
DROP INDEX targetgateway ON tl_nc_queue
    
DROP INDEX message ON tl_nc_queue
    
DROP INDEX sourcequeue ON tl_nc_queue
    
ALTER TABLE tl_nc_queue CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
DROP INDEX alias ON tl_news
    
DROP INDEX pid_published_featured_start_stop ON tl_news
    
ALTER TABLE tl_news CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
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 CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
DROP INDEX pid ON tl_newsletter
    
ALTER TABLE tl_newsletter CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
ALTER TABLE tl_newsletter_channel CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
DROP INDEX pid_hash ON tl_newsletter_deny_list
    
ALTER TABLE tl_newsletter_deny_list CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
DROP INDEX active ON tl_newsletter_recipients
    
DROP INDEX email ON tl_newsletter_recipients
    
DROP INDEX pid_email ON tl_newsletter_recipients
    
ALTER TABLE tl_newsletter_recipients CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
ALTER TABLE tl_om_backend_element_classes CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
ALTER TABLE tl_om_backend_links_main CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
ALTER TABLE tl_om_backend_links_top CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
ALTER TABLE tl_om_backend_sysinfo CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
DROP INDEX token ON tl_opt_in
    
DROP INDEX removeon ON tl_opt_in
    
ALTER TABLE tl_opt_in CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
DROP INDEX reltable_relid ON tl_opt_in_related
    
ALTER TABLE tl_opt_in_related CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
DROP INDEX type_dns ON tl_page
    
DROP INDEX pid_published_type_start_stop ON tl_page
    
DROP INDEX alias ON tl_page
    
ALTER TABLE tl_page CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
DROP INDEX id_published_expiresat ON tl_preview_link
    
ALTER TABLE tl_preview_link CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
DROP INDEX timeslotid ON tl_resource_booking
    
DROP INDEX pid_member_starttime_endtime ON tl_resource_booking
    
ALTER TABLE tl_resource_booking CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
DROP INDEX published_pid ON tl_resource_booking_resource
    
ALTER TABLE tl_resource_booking_resource CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
ALTER TABLE tl_resource_booking_resource_type CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
DROP INDEX pid ON tl_resource_booking_time_slot
    
ALTER TABLE tl_resource_booking_time_slot CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
ALTER TABLE tl_resource_booking_time_slot_type CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
DROP INDEX pid ON tl_rocksolid_slide
    
ALTER TABLE tl_rocksolid_slide CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
ALTER TABLE tl_rocksolid_slider CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
DROP INDEX url ON tl_search
    
DROP INDEX checksum_pid ON tl_search
    
ALTER TABLE tl_search CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
DROP INDEX pid ON tl_search_index
    
ALTER TABLE tl_search_index CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
DROP INDEX documentfrequency ON tl_search_term
    
DROP INDEX term ON tl_search_term
    
ALTER TABLE tl_search_term CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
DROP INDEX pid ON tl_style
    
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 CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
ALTER TABLE tl_theme CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
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 CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
ALTER TABLE tl_user_group CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    
DROP INDEX userid ON tl_version
    
DROP INDEX pid_fromtable_version ON tl_version
    
ALTER TABLE tl_version CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
Spalten ändern
    Alle auswählen
    
ALTER TABLE tl_article CHANGE teaser teaser TEXT DEFAULT NULL
    
ALTER TABLE tl_article CHANGE keywords keywords TEXT DEFAULT NULL
    
ALTER TABLE tl_article CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    
ALTER TABLE tl_calendar_events CHANGE description description TEXT DEFAULT NULL
    
ALTER TABLE tl_calendar_events CHANGE teaser teaser TEXT DEFAULT NULL
    
ALTER TABLE tl_calendar_events CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    
ALTER TABLE tl_calendar_feed CHANGE description description TEXT DEFAULT NULL
    
ALTER TABLE tl_calendar_feed CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    
ALTER TABLE tl_comments CHANGE reply reply TEXT DEFAULT NULL
    
ALTER TABLE tl_comments CHANGE comment comment TEXT DEFAULT NULL
    
ALTER TABLE tl_comments_notify CHANGE url url VARCHAR(2048) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    
ALTER TABLE tl_content CHANGE showPreview showPreview CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    
ALTER TABLE tl_content CHANGE data data TEXT DEFAULT NULL
    
ALTER TABLE tl_content CHANGE markdownSource markdownSource VARCHAR(12) CHARACTER SET ascii DEFAULT 'sourceText' NOT NULL COLLATE `ascii_bin`
    
ALTER TABLE tl_content CHANGE splashImage splashImage CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    
ALTER TABLE tl_content CHANGE com_order com_order VARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' 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_bbcode com_bbcode CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    
ALTER TABLE tl_content CHANGE com_disableCaptcha com_disableCaptcha CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    
ALTER TABLE tl_content CHANGE com_requireLogin com_requireLogin CHAR(1) CHARACTER SET ascii DEFAULT '' 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 inline inline CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    
ALTER TABLE tl_content CHANGE vimeo vimeo VARCHAR(16) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    
ALTER TABLE tl_content CHANGE playerAspect playerAspect VARCHAR(8) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    
ALTER TABLE tl_content CHANGE playerPreload playerPreload VARCHAR(8) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    
ALTER TABLE tl_content CHANGE vimeoOptions vimeoOptions TEXT DEFAULT NULL
    
ALTER TABLE tl_content CHANGE playerOptions playerOptions TEXT DEFAULT NULL
    
ALTER TABLE tl_content CHANGE overwriteLink overwriteLink CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    
ALTER TABLE tl_content CHANGE youtubeOptions youtubeOptions TEXT DEFAULT NULL
    
ALTER TABLE tl_content CHANGE overwriteMeta overwriteMeta CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    
ALTER TABLE tl_content CHANGE metaIgnore metaIgnore CHAR(1) 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 sliderContinuous sliderContinuous 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 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 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 playerColor playerColor VARCHAR(6) 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 galleryTpl galleryTpl VARCHAR(64) 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 target target CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    
ALTER TABLE tl_content CHANGE url url TEXT DEFAULT NULL
    
ALTER TABLE tl_content CHANGE code code TEXT DEFAULT NULL
    
ALTER TABLE tl_content CHANGE highlight highlight VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    
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 html html MEDIUMTEXT DEFAULT NULL
    
ALTER TABLE tl_content CHANGE floating floating VARCHAR(32) CHARACTER SET ascii DEFAULT 'above' NOT NULL COLLATE `ascii_bin`
    
ALTER TABLE tl_content CHANGE fullsize fullsize 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 imagemargin imagemargin VARCHAR(128) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    
ALTER TABLE tl_content CHANGE size size VARCHAR(128) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    
ALTER TABLE tl_content CHANGE addImage addImage CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    
ALTER TABLE tl_content CHANGE text text MEDIUMTEXT DEFAULT NULL
    
ALTER TABLE tl_content CHANGE type type VARCHAR(64) CHARACTER SET ascii DEFAULT 'text' NOT NULL COLLATE `ascii_bin`
    
ALTER TABLE tl_content CHANGE invisible invisible CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    
ALTER TABLE tl_cookie CHANGE scriptConfig scriptConfig TEXT DEFAULT NULL
    
ALTER TABLE tl_cookie CHANGE scriptUnconfirmed scriptUnconfirmed TEXT DEFAULT NULL
    
ALTER TABLE tl_cookie CHANGE scriptConfirmed scriptConfirmed TEXT DEFAULT NULL
    
ALTER TABLE tl_cookie CHANGE blockDescription blockDescription MEDIUMTEXT DEFAULT NULL
    
ALTER TABLE tl_cookie CHANGE detailDescription detailDescription MEDIUMTEXT DEFAULT NULL
    
ALTER TABLE tl_cookie CHANGE description description MEDIUMTEXT DEFAULT NULL
    
ALTER TABLE tl_cookie_config CHANGE scriptConfig scriptConfig TEXT DEFAULT NULL
    
ALTER TABLE tl_cookie_group CHANGE description description MEDIUMTEXT DEFAULT NULL
    
ALTER TABLE tl_cookie_log CHANGE config config TEXT DEFAULT NULL
    
ALTER TABLE tl_cookiebar CHANGE infoDescription infoDescription MEDIUMTEXT DEFAULT NULL
    
ALTER TABLE tl_cookiebar CHANGE description description MEDIUMTEXT DEFAULT NULL
    
ALTER TABLE tl_db_cache CHANGE cacheValue cacheValue MEDIUMTEXT DEFAULT NULL
    
ALTER TABLE tl_faq CHANGE description description TEXT DEFAULT NULL
    
ALTER TABLE tl_faq CHANGE answer answer TEXT DEFAULT NULL
    
ALTER TABLE tl_faq CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    
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_form CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    
ALTER TABLE tl_member CHANGE username username VARCHAR(64) DEFAULT NULL COLLATE `utf8mb4_bin`
    
ALTER TABLE tl_news CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    
ALTER TABLE tl_news_feed CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    
ALTER TABLE tl_newsletter CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    
ALTER TABLE tl_page CHANGE urlPrefix urlPrefix VARCHAR(128) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    
ALTER TABLE tl_page CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    
ALTER TABLE tl_search_term CHANGE term term VARCHAR(64) NOT NULL COLLATE `utf8mb4_bin`
    
ALTER TABLE tl_user CHANGE username username VARCHAR(64) DEFAULT NULL COLLATE `utf8mb4_bin`
Spalten anlegen
    Alle auswählen
    
CREATE INDEX job_id ON tl_crawl_queue (job_id)
    
CREATE INDEX uri_hash ON tl_crawl_queue (uri_hash)
    
CREATE INDEX processed ON tl_crawl_queue (processed)
    
CREATE INDEX name ON tl_cron_job (name)
    
CREATE INDEX series ON tl_remember_me (series)
    
CREATE UNIQUE INDEX value ON tl_remember_me (value)
    
CREATE INDEX alias ON tl_article (alias)
    
CREATE INDEX pid_published_incolumn_start_stop ON tl_article (
  pid, published, incolumn, start, stop
)
    
CREATE INDEX alias ON tl_calendar_events (alias)
    
CREATE INDEX pid_published_featured_start_stop ON tl_calendar_events (
  pid, published, featured, start, stop
)
    
CREATE INDEX pid ON tl_calendar_events_subscription (pid)
    
CREATE INDEX member ON tl_calendar_events_subscription (member)
    
CREATE INDEX alias ON tl_calendar_feed (alias)
    
CREATE INDEX published ON tl_comments (published)
    
CREATE INDEX source_parent_published ON tl_comments (source, parent, published)
    
CREATE INDEX source_parent_active_email ON tl_comments_notify (source, parent, active, email)
    
CREATE INDEX tokenremove ON tl_comments_notify (tokenremove)
    
CREATE INDEX pid_ptable_invisible_start_stop ON tl_content (
  pid, ptable, invisible, start, stop
)
    
CREATE INDEX type ON tl_content (type)
    
CREATE INDEX pid_published ON tl_cookie (pid, published)
    
CREATE INDEX published ON tl_cookie_config (published)
    
CREATE INDEX pid_published ON tl_cookie_group (pid, published)
    
CREATE INDEX cid ON tl_cookie_log (cid)
    
CREATE INDEX pid ON tl_dlstatdets (pid)
    
CREATE INDEX filename ON tl_dlstats (filename)
    
CREATE INDEX pid_published ON tl_faq (pid, published)
    
CREATE INDEX pid ON tl_files (pid)
    
CREATE UNIQUE INDEX uuid ON tl_files (uuid)
    
CREATE INDEX extension ON tl_files (extension)
    
CREATE INDEX path ON tl_files (
  path(768)
)

Aber der FEhler passiert offenbar bei tl_files

Code:

'ALTER TABLE tl_files CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci', array(), array())

**Spooky** · 06.06.2022, 12:12

Lass

Code:

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`

ausführen und sonst nichts. Dann

Code:

ALTER TABLE tl_files CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

ausführen lassen.

**Kahmoon** · 06.06.2022, 12:16

Das hat geklappt. Danach kam dann noch mal eine riesige Liste mit Änderungen. Ist jetzt alles durchgelaufen. Schaut soweit ok aus.

Thema: Nach Update sehr viele ALTER Table bezüglich Unicode utf8mb4_unicode_ci -> Fehler

Themen-Optionen

Thema durchsuchen

Nach Update sehr viele ALTER Table bezüglich Unicode utf8mb4_unicode_ci -> Fehler

Aktive Benutzer

Aktive Benutzer

Lesezeichen

Lesezeichen

Berechtigungen

Contao

Empfohlene Webdesign-Bücher