Installtool wirft Fehlermeldung aus

[kubjo]

Hi Leute ich will eine C4.5.x auf 4.6.x updaten und habe zuerst mal die Erweiterungen upgedatet.

Backend läuft!
Leider komme ich nicht ins Installtoll, nach dem Login kommt die Fehlermeldung, im Log finde ich das hier:

[2018-12-07 11:49:18] app.CRITICAL: An exception occurred. {"exception":"[object] (Doctrine\\DBAL\\Exception\\SyntaxErrorException(code: 0): An exception occurred while executing 'SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'db30616_80' AND TABLE_NAME = 'tl_layout' ORDER BY ORDINAL_POSITION ASC AND COLUMN_NAME = 'sections'':\n\nSQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND COLUMN_NAME = 'sections'' at line 1 at /xxx/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\\DBAL\\Driver\\PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND COLUMN_NAME = 'sections'' at line 1 at /xxx/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:90, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND COLUMN_NAME = 'sections'' at line 1 at /xxx/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:88)"} []

Was machen?

[tab]

Updaten auf die neueste 4.6.10, erst damit ist das Problem behoben. Dann kannst du auch das Installtool fehlerfrei aufrufen.

[kubjo]

Hallo Tab,

vielen Dank, jetzt hat es geklappt! Das Update über den CM auf 4.6.10 hat jetzt nach den dritten oder vieten Anlauf geklappt. Allerdings hat das Installtool jetzt ein paar Probleme:

Tabellen ändern
	Alle auswählen
	
DROP INDEX pid ON tl_iso_product_category
ALTER TABLE tl_iso_product_category CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX pid ON tl_iso_product_pricetier
ALTER TABLE tl_iso_product_pricetier CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX pid ON tl_iso_related_product
ALTER TABLE tl_iso_related_product CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX id_store_id ON tl_iso_requestcache
ALTER TABLE tl_iso_requestcache CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX vid_visitors_date ON tl_visitors_counter
ALTER TABLE tl_visitors_counter CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX vid_v_date_v_s_w_v_s_h_v_s_iw_v_s_ih ON tl_visitors_screen_counter
ALTER TABLE tl_visitors_screen_counter CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

Wenn ich hier alle auswähle und bestätige kommen folgende Meldungen:

Tabellen ändern
	Alle auswählen
ALTER TABLE tl_iso_product_category CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
ALTER TABLE tl_iso_product_pricetier CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
ALTER TABLE tl_iso_related_product CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
ALTER TABLE tl_iso_requestcache CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
ALTER TABLE tl_visitors_counter CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
ALTER TABLE tl_visitors_screen_counter CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

Spalten anlegen
	Alle auswählen
	
CREATE INDEX pid ON tl_iso_product_category (pid)
CREATE INDEX pid ON tl_iso_product_pricetier (pid)
CREATE INDEX pid ON tl_iso_related_product (pid)
CREATE INDEX id_store_id ON tl_iso_requestcache (id, store_id)
CREATE UNIQUE INDEX vid_visitors_date ON tl_visitors_counter (vid, visitors_date)
CREATE UNIQUE INDEX vid_v_date_v_s_w_v_s_h_v_s_iw_v_s_ih ON tl_visitors_screen_counter (
  vid, v_date, v_s_w, v_s_h, v_s_iw, v_s_ih
)

Und diese zwei Änderungen (vorschläge) wechseln dann immer ab!

Die Probleme mit Visitors habe ich bei anderen Installationen auch , aber nicht so viele!

Grüße
JK