Hallo,
ich habe heute versucht mein CMS upzudaten....
Soweit so gut. bis auf 4.9.1 ging auch alles...
dann gecheckt ob alles funktioniert. leider war dies nicht der fall ...
also downgegradet...
cms wieder auf 4.6.9
dann klar der CM wollte aus Install-tool datenbank neuschreiben...
psw eingegeben...
Hurra, geht nicht.... kommt fehler meldung.. soll in die Logs schauen...
gesagt getan das gefunden
Code:
[2020-03-31 23:03:02] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\SyntaxErrorException: "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 = 'server_c4' AND TABLE_NAME = 'tl_layout' ORDER BY ORDINAL_POSITION ASC AND COLUMN_NAME = 'sections'': 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 /usr/www/users/foerdd/C4/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 {"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 = 'server_c4' 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 /usr/www/users/foerdd/C4/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 /usr/www/users/foerdd/C4/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 /usr/www/users/foerdd/C4/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:88)"} []
noch ein weitere Fehler gefunden .. im Backend dann auf Themes und da auf Seitenlayout geklickt, kommt noch eine Fehlermeldung: Was ist das Problem?
An exception occurred while executing 'SELECT DISTINCT `doctype` FROM tl_layout WHERE pid='10'': SQLSTATE[42S22]: Column not found: 1054 Unknown column 'doctype' in 'field list'
was habe ich nun zerschossen ? was muss ich machen damit es wieder funktioniert...
meine seite ist https://www.foerde.news
Vielen Dank
Lesezeichen