Install Tool oder Systemwartung nicht mehr aufrufbar

**liebling65** · 30.03.2022, 20:08

Diesen Fehler sehe ich im Logfile:

[2022-03-30 20:58:43] request.CRITICAL: Uncaught PHP Exception Symfony\Component\ErrorHandler\Error\UndefinedMeth odError: "Attempted to call an undefined method named "createSchemaManager" of class "Doctrine\DBAL\Connection". Did you mean to call "getSchemaManager"?" at /home/xxx/public_html/vendor/contao/newsletter-bundle/src/Migration/Version410/DenyListMigration.php line 33 {"exception":"[object] (Symfony\\Component\\ErrorHandler\\Error\\Undefine dMethodError(code: 0): Attempted to call an undefined method named "createSchemaManager" of class "Doctrine\\DBAL\\Connection".\nDid you mean to call "getSchemaManager"? at /home/xxx/public_html/vendor/contao/newsletter-bundle/src/Migration/Version410/DenyListMigration.php:33)"}

Wo ist denn da der Fehler?

Achja, wenn ich die Systemwartung aufrufe:
An exception occurred while executing 'SELECT COUNT(*) AS count FROM tl_crawl_queue': SQLSTATE[42S02]: Base table or view not found: 1146 Table 'xxx.tl_crawl_queue' doesn't exist

**Birden** · 30.03.2022, 20:21

Läßt sich der Contao Manager aufrufen?

**cliffparnitzky** · 30.03.2022, 20:30

Also der Teil ...

Zitat von liebling65

"getSchemaManager"? at /home/xxx/public_html/vendor/contao/newsletter-bundle/src/Migration/Version410/DenyListMigration.php:33)"}

... deuted mind. darauf hin, dass das mit Conato 4.9.x nicht ganz passt.

**liebling65** · 30.03.2022, 20:34

Ja, der Manager läßt sich aufrufen (hab auch überall nen grünen Haken), aber z.B. ein Composer Update wirft auch nen Fehler:

21:33:10 CRITICAL [console] Error thrown while running command "cache:warmup --env=prod --no-ansi". Message: "Undefined class constant 'MODE_SORTABLE'" ["exception" => Error { …},"command" => "cache:warmup --env=prod --no-ansi","message" => "Undefined class constant 'MODE_SORTABLE'"]
53
54
In tl_preview_link.php line 8:
55

56
Undefined class constant 'MODE_SORTABLE'

**liebling65** · 30.03.2022, 20:35

Zitat von cliffparnitzky

Also der Teil ...

... deuted mind. darauf hin, dass das mit Conato 4.9.x nicht ganz passt.

Ich habe auch den Eindruck, dass mein Update von 4.9.13 auf 4.9.27 irgendwie nicht ganz fertig geworden ist.

**Birden** · 30.03.2022, 20:37

Aktualisiere nochmal alle Pakete auf einmal

**liebling65** · 30.03.2022, 20:43

Zitat von Birden

Aktualisiere nochmal alle Pakete auf einmal

Contao Manager - Update - Apply changes - Update all packages:

21:33:10 CRITICAL [console] Error thrown while running command "cache:warmup --env=prod --no-ansi". Message: "Undefined class constant 'MODE_SORTABLE'" ["exception" => Error { …},"command" => "cache:warmup --env=prod --no-ansi","message" => "Undefined class constant 'MODE_SORTABLE'"]
53
54
In tl_preview_link.php line 8:
55

56
Undefined class constant 'MODE_SORTABLE'

**Birden** · 30.03.2022, 20:47

Was ist da für eine PHP Version am laufen?

**liebling65** · 30.03.2022, 20:49

Zitat von Birden

Was ist da für eine PHP Version am laufen?

7.4.21

**cliffparnitzky** · 30.03.2022, 20:50

Das "MODE_SORTABLE" ist in Contao 4.13.x Code enthalten. Dh. da ist echt was im Argen.

Ist son bissel stochern und ferndiagnose.

Es wird auch manchmal empfohlen das "vendor" Verzeichnis zu löschen und dann alles zu aktualisieren.

**Birden** · 30.03.2022, 20:52

Weiß nicht was da alles an Erweiterungen drauf ist, wenn möglich würd ich auf PHP8 und Contao 4.13 updaten.

**liebling65** · 30.03.2022, 20:58

Zitat von cliffparnitzky

Das "MODE_SORTABLE" ist in Contao 4.13.x Code enthalten. Dh. da ist echt was im Argen.

Ist son bissel stochern und ferndiagnose.

Es wird auch manchmal empfohlen das "vendor" Verzeichnis zu löschen und dann alles zu aktualisieren.

Aktualisieren über den Contao-Manager?

**cliffparnitzky** · 30.03.2022, 21:04

Jop. Würde ich probieren.

**mlweb** · 30.03.2022, 21:11

Aber dann auch die composer.lock mit löschen/umbenennen

**Spooky** · 31.03.2022, 07:35

Poste außerdem deine composer.json

**thomasr** · 25.07.2023, 10:25

Hallo :-)
Habe das selbe Problem wie oben beschrieben.
nach Update von 4.4.5.7 auf 4.9.42 habe ich auch das Problem mit der «Systemwartung»

Code:

An exception occurred while executing 'SELECT COUNT(*) AS count FROM tl_crawl_queue': SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bernasc2_dbphp8.tl_crawl_queue' doesn't exist

Irgend etwas stimmt mit der Datenbank nicht «dbphp8.tl».
Auch habe ich gemerkt, dass sich die «Datenbankänderungen» im CM x-mal wiederholen lassen
ohne diese auszuführen.

Hier meine composer.json

Code:

{
    "type": "project",
    "require": {
        "contao/calendar-bundle": "4.9.*",
        "contao/comments-bundle": "4.9.*",
        "contao/conflicts": "*@dev",
        "contao/faq-bundle": "4.9.*",
        "contao/listing-bundle": "4.9.*",
        "contao/manager-bundle": "4.9.*",
        "contao/news-bundle": "4.9.*",
        "contao/newsletter-bundle": "4.9.*"
    },
    "extra": {
        "contao-component-dir": "assets"
    },
    "scripts": {
        "post-install-cmd": [
            "Contao\\ManagerBundle\\Composer\\ScriptHandler::initializeApplication"
        ],
        "post-update-cmd": [
            "Contao\\ManagerBundle\\Composer\\ScriptHandler::initializeApplication"
        ]
    }
}

**Spooky** · 25.07.2023, 10:26

Contao 4.9 bekommt keine Bugfixes mehr. Wenn dann solltest du auf Contao 4.13 aktualisieren.

**thomasr** · 25.07.2023, 11:29

OK, hab das Update auf 4.13.28 Gemacht :-)

Wenn ich die Seite aufrufe (Klick auf Startpunkt) kommt die Fehlerseite und im Fehler-Log steht.

Code:

[2023-07-25T12:23:23.935380+02:00] request.INFO: Matched route "tl_page.2369". {"route":"tl_page.2369","route_parameters":{"_token_check":true,"_controller":"Contao\\FrontendIndex::renderPage","_scope":"frontend","_locale":"de","_format":"html","_canonical_route":"tl_page.2369","parameters":"","pageModel":{"Contao\\PageModel":[]},"_route":"tl_page.2369","_route_object":{"Contao\\CoreBundle\\Routing\\Page\\PageRoute":[]}},"request_uri":"https://php8.denkpraxis.ch/preview.php/blog.html","method":"GET"} []
[2023-07-25T12:23:23.937076+02:00] security.INFO: Populated the TokenStorage with an anonymous Token. [] []
[2023-07-25T12:23:24.000753+02:00] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'manualSorting' in 'where clause'" at /home/bernasc2/www/php8.denkpraxis.ch/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 67 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 1054): An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'manualSorting' in 'where clause' at /home/bernasc2/www/php8.denkpraxis.ch/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:67)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1054): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'manualSorting' in 'where clause' at /home/bernasc2/www/php8.denkpraxis.ch/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'manualSorting' in 'where clause' at /home/bernasc2/www/php8.denkpraxis.ch/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:70)"} []

In der Installation habe ich eine zweite Seite mit einer eigenen Domain, diese wird ohne Probleme dargestellt.

PS: habe immer noch PHP 7.4 aktiviert

***lucina*** · 25.07.2023, 11:37

Datenbank-Update und/oder Installtool aufgerufen?

**thomasr** · 25.07.2023, 12:01

Habe beides gemacht, Installtool und Manager. «3 ausstehende Schema-Änderungen» bleiben.

Code:

[2023-07-25T12:55:00.397095+02:00] request.INFO: Matched route "tl_page.2369". {"route":"tl_page.2369","route_parameters":{"_token_check":true,"_controller":"Contao\\FrontendIndex::renderPage","_scope":"frontend","_locale":"de","_format":"html","_canonical_route":"tl_page.2369","parameters":"","pageModel":{"Contao\\PageModel":[]},"_route":"tl_page.2369","_route_object":{"Contao\\CoreBundle\\Routing\\Page\\PageRoute":[]}},"request_uri":"https://php8.xxxxxxx.ch/preview.php/blog.html","method":"GET"} []
[2023-07-25T12:55:00.411118+02:00] security.INFO: Populated the TokenStorage with an anonymous Token. [] []
[2023-07-25T12:55:00.684907+02:00] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'manualSorting' in 'where clause'" at /home/bernasc2/www/php8.xxxxxxx.ch/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 67 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 1054): An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'manualSorting' in 'where clause' at /home/bernasc2/www/php8.xxxxxxx.ch/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:67)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1054): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'manualSorting' in 'where clause' at /home/bernasc2/www/php8.xxxxxxx.ch/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'manualSorting' in 'where clause' at /home/bernasc2/www/php8.xxxxxxx.ch/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:70)"} []

**Spooky** · 25.07.2023, 12:05

Welche Änderungen bleiben?

**thomasr** · 25.07.2023, 12:07

Code:

ALTER TABLE tl_pct_customelement CHANGE alias alias VARCHAR(128) CHARACTER SET utf8 DEFAULT '' NOT NULL COLLATE `utf8_bin`
	
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_group CHANGE alias alias VARCHAR(128) CHARACTER SET utf8 DEFAULT '' NOT NULL COLLATE `utf8_bin`

***lucina*** · 25.07.2023, 12:21

Siehe auch: https://forum.premium-contao-themes....-6-3#post23369

Aktualisierung des Themes fällig?

**thomasr** · 25.07.2023, 12:36

Das habe ich auch schon gesehen, aber im Error-Log steht ja nichts von «PCT»
oder hab ich was übersehen?

***lucina*** · 25.07.2023, 12:37

Zitat von thomasr

Das habe ich auch schon gesehen, aber im Error-Log steht ja nichts von «PCT»
oder hab ich was übersehen?

Nicht? Hmmm, ich sehe da:
tl_pct_customelement

**thomasr** · 25.07.2023, 12:43

ich meine da drin, in der Error-Log ;-)

Code:

[2023-07-25T12:55:00.397095+02:00] request.INFO: Matched route "tl_page.2369". {"route":"tl_page.2369","route_parameters":{"_token_check":true,"_controller":"Contao\\FrontendIndex::renderPage","_scope":"frontend","_locale":"de","_format":"html","_canonical_route":"tl_page.2369","parameters":"","pageModel":{"Contao\\PageModel":[]},"_route":"tl_page.2369","_route_object":{"Contao\\CoreBundle\\Routing\\Page\\PageRoute":[]}},"request_uri":"https://php8.xxxxxxx.ch/preview.php/blog.html","method":"GET"} []
[2023-07-25T12:55:00.411118+02:00] security.INFO: Populated the TokenStorage with an anonymous Token. [] []
[2023-07-25T12:55:00.684907+02:00] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'manualSorting' in 'where clause'" at /home/bernasc2/www/php8.xxxxxxx.ch/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 67 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 1054): An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'manualSorting' in 'where clause' at /home/bernasc2/www/php8.xxxxxxx.ch/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:67)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1054): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'manualSorting' in 'where clause' at /home/bernasc2/www/php8.xxxxxxx.ch/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'manualSorting' in 'where clause' at /home/bernasc2/www/php8.xxxxxxx.ch/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:70)"} []

**Spooky** · 25.07.2023, 13:11

Nutze den Debug-Modus und poste den Stack Trace.

**thomasr** · 25.07.2023, 13:40

Code:

PDOException:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'manualSorting' in 'where clause'

  at vendor/doctrine/dbal/src/Driver/PDO/Connection.php:70
  at PDO->query('SELECT * FROM tl_news_archive WHERE id IN(64,62,63) AND manualSorting=1')
     (vendor/doctrine/dbal/src/Driver/PDO/Connection.php:70)
  at Doctrine\DBAL\Driver\PDO\Connection->query('SELECT * FROM tl_news_archive WHERE id IN(64,62,63) AND manualSorting=1')
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:33)
  at Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->query('SELECT * FROM tl_news_archive WHERE id IN(64,62,63) AND manualSorting=1')
     (vendor/doctrine/dbal/src/Logging/Connection.php:43)
  at Doctrine\DBAL\Logging\Connection->query('SELECT * FROM tl_news_archive WHERE id IN(64,62,63) AND manualSorting=1')
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:33)
  at Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->query('SELECT * FROM tl_news_archive WHERE id IN(64,62,63) AND manualSorting=1')
     (vendor/symfony/doctrine-bridge/Middleware/Debug/Connection.php:63)
  at Symfony\Bridge\Doctrine\Middleware\Debug\Connection->query('SELECT * FROM tl_news_archive WHERE id IN(64,62,63) AND manualSorting=1')
     (vendor/doctrine/dbal/src/Connection.php:1098)
  at Doctrine\DBAL\Connection->executeQuery('SELECT * FROM tl_news_archive WHERE id IN(64,62,63) AND manualSorting=1', array(), array())
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:284)
  at Contao\Database\Statement->query('', array())
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:240)
  at Contao\Database\Statement->execute()
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database.php:198)
  at Contao\Database->execute('SELECT * FROM tl_news_archive WHERE id IN(64,62,63) AND manualSorting=1')
     (system/modules/pct_autogrid/PCT/AutoGrid/AutoGrid.php:1584)
  at PCT\AutoGrid\AutoGrid->applyNewsSorting(array('64', '62', '63'), null, '3', 0, object(ModuleNewsList))
     (vendor/contao/news-bundle/src/Resources/contao/modules/ModuleNewsList.php:210)
  at Contao\ModuleNewsList->fetchItems(array('64', '62', '63'), null, '3', 0)
     (vendor/contao/news-bundle/src/Resources/contao/modules/ModuleNewsList.php:152)
  at Contao\ModuleNewsList->compile()
     (vendor/contao/core-bundle/src/Resources/contao/modules/Module.php:214)
  at Contao\Module->generate()
     (vendor/contao/news-bundle/src/Resources/contao/modules/ModuleNewsList.php:73)
  at Contao\ModuleNewsList->generate()
     (vendor/contao/core-bundle/src/Resources/contao/elements/ContentModule.php:98)
  at Contao\ContentModule->generate()
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Controller.php:622)
  at Contao\Controller::getContentElement(object(ContentModel), 'right')
     (vendor/contao/core-bundle/src/Resources/contao/modules/ModuleArticle.php:197)
  at Contao\ModuleArticle->compile()
     (vendor/contao/core-bundle/src/Resources/contao/modules/Module.php:214)
  at Contao\Module->generate()
     (vendor/contao/core-bundle/src/Resources/contao/modules/ModuleArticle.php:70)
  at Contao\ModuleArticle->generate(false)
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Controller.php:550)
  at Contao\Controller::getArticle(object(ArticleModel), false, false, 'right')
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Controller.php:392)
  at Contao\Controller::getFrontendModule('0', 'right')
     (vendor/contao/core-bundle/src/Resources/contao/pages/PageRegular.php:190)
  at Contao\PageRegular->prepare(object(PageModel))
     (vendor/contao/core-bundle/src/Resources/contao/pages/PageRegular.php:60)
  at Contao\PageRegular->getResponse(object(PageModel), true)
     (vendor/contao/core-bundle/src/Resources/contao/controllers/FrontendIndex.php:320)
  at Contao\FrontendIndex->renderPage(object(PageModel))
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:75)
  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/preview.php:46)

Code:

Doctrine\DBAL\Exception\InvalidFieldNameException:
An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'manualSorting' in 'where clause'

  at vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:67
  at Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(object(Exception), object(Query))
     (vendor/doctrine/dbal/src/Connection.php:1935)
  at Doctrine\DBAL\Connection->handleDriverException(object(Exception), object(Query))
     (vendor/doctrine/dbal/src/Connection.php:1878)
  at Doctrine\DBAL\Connection->convertExceptionDuringQuery(object(Exception), 'SELECT * FROM tl_news_archive WHERE id IN(64,62,63) AND manualSorting=1', array(), array())
     (vendor/doctrine/dbal/src/Connection.php:1103)
  at Doctrine\DBAL\Connection->executeQuery('SELECT * FROM tl_news_archive WHERE id IN(64,62,63) AND manualSorting=1', array(), array())
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:284)
  at Contao\Database\Statement->query('', array())
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:240)
  at Contao\Database\Statement->execute()
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database.php:198)
  at Contao\Database->execute('SELECT * FROM tl_news_archive WHERE id IN(64,62,63) AND manualSorting=1')
     (system/modules/pct_autogrid/PCT/AutoGrid/AutoGrid.php:1584)
  at PCT\AutoGrid\AutoGrid->applyNewsSorting(array('64', '62', '63'), null, '3', 0, object(ModuleNewsList))
     (vendor/contao/news-bundle/src/Resources/contao/modules/ModuleNewsList.php:210)
  at Contao\ModuleNewsList->fetchItems(array('64', '62', '63'), null, '3', 0)
     (vendor/contao/news-bundle/src/Resources/contao/modules/ModuleNewsList.php:152)
  at Contao\ModuleNewsList->compile()
     (vendor/contao/core-bundle/src/Resources/contao/modules/Module.php:214)
  at Contao\Module->generate()
     (vendor/contao/news-bundle/src/Resources/contao/modules/ModuleNewsList.php:73)
  at Contao\ModuleNewsList->generate()
     (vendor/contao/core-bundle/src/Resources/contao/elements/ContentModule.php:98)
  at Contao\ContentModule->generate()
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Controller.php:622)
  at Contao\Controller::getContentElement(object(ContentModel), 'right')
     (vendor/contao/core-bundle/src/Resources/contao/modules/ModuleArticle.php:197)
  at Contao\ModuleArticle->compile()
     (vendor/contao/core-bundle/src/Resources/contao/modules/Module.php:214)
  at Contao\Module->generate()
     (vendor/contao/core-bundle/src/Resources/contao/modules/ModuleArticle.php:70)
  at Contao\ModuleArticle->generate(false)
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Controller.php:550)
  at Contao\Controller::getArticle(object(ArticleModel), false, false, 'right')
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Controller.php:392)
  at Contao\Controller::getFrontendModule('0', 'right')
     (vendor/contao/core-bundle/src/Resources/contao/pages/PageRegular.php:190)
  at Contao\PageRegular->prepare(object(PageModel))
     (vendor/contao/core-bundle/src/Resources/contao/pages/PageRegular.php:60)
  at Contao\PageRegular->getResponse(object(PageModel), true)
     (vendor/contao/core-bundle/src/Resources/contao/controllers/FrontendIndex.php:320)
  at Contao\FrontendIndex->renderPage(object(PageModel))
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:75)
  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/preview.php:46)

Code:

Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'manualSorting' in 'where clause'

  at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28
  at Doctrine\DBAL\Driver\PDO\Exception::new(object(PDOException))
     (vendor/doctrine/dbal/src/Driver/PDO/Connection.php:75)
  at Doctrine\DBAL\Driver\PDO\Connection->query('SELECT * FROM tl_news_archive WHERE id IN(64,62,63) AND manualSorting=1')
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:33)
  at Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->query('SELECT * FROM tl_news_archive WHERE id IN(64,62,63) AND manualSorting=1')
     (vendor/doctrine/dbal/src/Logging/Connection.php:43)
  at Doctrine\DBAL\Logging\Connection->query('SELECT * FROM tl_news_archive WHERE id IN(64,62,63) AND manualSorting=1')
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:33)
  at Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->query('SELECT * FROM tl_news_archive WHERE id IN(64,62,63) AND manualSorting=1')
     (vendor/symfony/doctrine-bridge/Middleware/Debug/Connection.php:63)
  at Symfony\Bridge\Doctrine\Middleware\Debug\Connection->query('SELECT * FROM tl_news_archive WHERE id IN(64,62,63) AND manualSorting=1')
     (vendor/doctrine/dbal/src/Connection.php:1098)
  at Doctrine\DBAL\Connection->executeQuery('SELECT * FROM tl_news_archive WHERE id IN(64,62,63) AND manualSorting=1', array(), array())
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:284)
  at Contao\Database\Statement->query('', array())
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:240)
  at Contao\Database\Statement->execute()
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database.php:198)
  at Contao\Database->execute('SELECT * FROM tl_news_archive WHERE id IN(64,62,63) AND manualSorting=1')
     (system/modules/pct_autogrid/PCT/AutoGrid/AutoGrid.php:1584)
  at PCT\AutoGrid\AutoGrid->applyNewsSorting(array('64', '62', '63'), null, '3', 0, object(ModuleNewsList))
     (vendor/contao/news-bundle/src/Resources/contao/modules/ModuleNewsList.php:210)
  at Contao\ModuleNewsList->fetchItems(array('64', '62', '63'), null, '3', 0)
     (vendor/contao/news-bundle/src/Resources/contao/modules/ModuleNewsList.php:152)
  at Contao\ModuleNewsList->compile()
     (vendor/contao/core-bundle/src/Resources/contao/modules/Module.php:214)
  at Contao\Module->generate()
     (vendor/contao/news-bundle/src/Resources/contao/modules/ModuleNewsList.php:73)
  at Contao\ModuleNewsList->generate()
     (vendor/contao/core-bundle/src/Resources/contao/elements/ContentModule.php:98)
  at Contao\ContentModule->generate()
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Controller.php:622)
  at Contao\Controller::getContentElement(object(ContentModel), 'right')
     (vendor/contao/core-bundle/src/Resources/contao/modules/ModuleArticle.php:197)
  at Contao\ModuleArticle->compile()
     (vendor/contao/core-bundle/src/Resources/contao/modules/Module.php:214)
  at Contao\Module->generate()
     (vendor/contao/core-bundle/src/Resources/contao/modules/ModuleArticle.php:70)
  at Contao\ModuleArticle->generate(false)
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Controller.php:550)
  at Contao\Controller::getArticle(object(ArticleModel), false, false, 'right')
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Controller.php:392)
  at Contao\Controller::getFrontendModule('0', 'right')
     (vendor/contao/core-bundle/src/Resources/contao/pages/PageRegular.php:190)
  at Contao\PageRegular->prepare(object(PageModel))
     (vendor/contao/core-bundle/src/Resources/contao/pages/PageRegular.php:60)
  at Contao\PageRegular->getResponse(object(PageModel), true)
     (vendor/contao/core-bundle/src/Resources/contao/controllers/FrontendIndex.php:320)
  at Contao\FrontendIndex->renderPage(object(PageModel))
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:75)
  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/preview.php:46)

**Spooky** · 25.07.2023, 13:46

Hast du die PCT Module schon auf den neuesten Stand gebracht? Soweit überhaupt möglich.

**thomasr** · 25.07.2023, 13:56

So wie es aussieht, sind sie nicht auf aktuellem Stand. Diese liefen mit Contao 4.4.5.

Ich versuche ein Upgrade einer Seite mit viel Inhalt zu machen.
Gibt es eine Möglichkeit ein Contao 4.9.42 mit einem frischen Theme (könnte auch Rocksolid sein)
zu installieren und dann nur die Inhalte von Contao-Modulen, Seitenstruktur mit Artikeln aus der Datenbank zu importieren?
Die Inhaltselemente müsste man dann von Hand anpassen.

**mlweb** · 25.07.2023, 17:18

Das kommt drauf an wie exzessiv von den spezifischen PCT-Elementen Gebrauch gemacht wurde. Bei allen Core-Elementen kannst Du den Inhalt in der Regel übernehmen und dann neu stylen. Alles was themespezifisch mit eigenenen Inhaltselementen und Modulen gemacht wurde ist Fleißarbeit.

**thomasr** · 26.07.2023, 09:03

Hallo mlweb, danke für die Antwort :-)

Wäre das ein mögliches Scenario?
1) Eine neue Contao 4.9.42 Installation mit einem Theme installieren (ev. Rocksolid)
2) Dateien «files-Ordner»
3) Datenbank-Export* ohne PCT ohne DROP TABLE
4) Datenbak-Import in neue Contao-Installation
5) Importierte Seiten, Artikel etc. anpassen

*Könnte der Datenbank Export so aussehen?

tl_article
tl_calendar
tl_calendar_events
tl_calendar_feed
tl_comments
tl_comments_notify
tl_content
tl_cron
tl_faq
tl_faq_category
tl_files
tl_form
tl_form_field
tl_image_size
tl_image_size_item
tl_layout
tl_log
tl_member
tl_member_group
tl_module
tl_news
tl_newsletter
tl_newsletter_blacklist
tl_newsletter_channel
tl_newsletter_recipients
tl_news_archive
tl_news_feed
tl_page
tl_pct_customelement
tl_pct_customelement_attribute
tl_pct_customelement_group
tl_pct_customelement_plugin
tl_pct_customelement_vault
tl_pct_themedesigner
tl_revolutionslider
tl_revolutionslider_slides
tl_search
tl_search_index
tl_session
tl_style
tl_style_sheet
tl_theme
tl_undo
tl_user
tl_user_group
tl_version

**mlweb** · 26.07.2023, 10:07

Ich habe bei solchen Umstellungen die komplette Datenbank ohne folgende Tabellen genutzt:

tl_log
tl_search
tl_search_index
tl_session
tl_undo
tl_version

Die PCT-Tabellen habe ich erst später gelöscht. Ich glaube damit konnte ich im Backend gut sehen, wo so ein Spezial-Element platziert war.
Aber so etwas teste ich in der Regel an der Installation as bzw. schau schon mal vorher im Backend, wie viele Elemente das betrifft.

Die Templates und ggf. Konfigurationen wirst Du auch übernehmen müssen.

Außerdem würde ich für diesen Zweck mindestens Contao 4.13 verwenden - wahrscheinlich würde ich sogar mal mit Contao 5 testen.

Kleiner Nachtrag: Bei einer der letzten Umstellungen PCT auf anderes Theme habe ich in zwei Seitenbäumen gearbeitet. Ich hatte also einen Seitenbaum mit komplett funktionierendem und aktualisiertem PCT und habe dann seitenweise in den neuen Seitenbaum kopiert und angepasst. Ein Patenrezept gibt es m.E. nicht. Hängt von der Installation, der eigenen Arbeitsweise und Experimentierfreudigkeit ab.