ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Hallo zusammen,
ich habe gerade Contao 4.6.3 installiert. So weit hat alles geklappt, aber im Install-Tool bleiben Datenbank-Anweisungen scheinbar unausgefürt und werde immer wieder angezeigt. Das war bei der Installation von Contao 4.6.1 nicht der Fall. Die gesamte sonstige Konfiguration ist identisch.
Code:
ALTER TABLE tl_article ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_calendar ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_calendar_events ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_calendar_feed ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_comments ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_comments_notify ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_content ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_cron ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_faq ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_faq_category ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_files ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_form ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_form_field ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_image_size ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_image_size_item ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_layout ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_log ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_member ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_member_group ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_module ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_news ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_news_archive ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_news_feed ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_newsletter ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_newsletter_blacklist ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_newsletter_channel ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_newsletter_recipients ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_page ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_remember_me ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_search ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_search_index ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_style ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_style_sheet ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_theme ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_undo ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_user ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_user_group ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_version ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Kann ich irgendwo die Einstellungen ändern, damit es funktioniert? Oder mache ich was falsch?
Vielen Dank und viele Grüße
Timo
Liste der Anhänge anzeigen (Anzahl: 1)
ALTER TABLE tl_content ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Ich möchte hier das Problem noch einmal aufgreifen. Ich habe meine letzte Website von 3.5.40 auf 4.4. umgestellt und nachdem dies gelungen ist, sofort auf 4.9.1. Leider lässt mir oben genannter Fehler im Installtool die DB nicht ändern:
ALTER TABLE tl_content ENGINE = InnoDB ROW_FORMAT = DYNAMIC
CREATE INDEX pid_ptable_invisible_sorting ON tl_content (pid, ptable, invisible, sorting)
Die Datenbank selbst sieht an dieser Stelle wie folgt aus:
Anhang 23273
myadmin bei Alfahosting:
Server: alfa3205.alfahosting-server.de (Localhost via UNIX socket)
Server-Typ: MySQL
Server-Version: 5.7.25 - MySQL Community Server (GPL)
Die Error_log bei Alfahosting ist 0.
Was ist da zu ändern?
Freue mich auf Antwort
Monika