5.3.x Aufruf sitemap.xml führt zu Contao-Fehler

Aufruf sitemap.xml führt zu Contao-Fehler

Moin Zusammen,

bisher dachte ich, dass Contao die Sitemap automatisch mit der Route https://meine-domain.de/sitemap.xml zur Verfügung stellt.
Der Aufruf https://meine-domain.de/sitemap.xml erzeugt leider einen Contao-Fehler mit Eintrag im Log.

Code:

[2026-06-21T10:06:52.176529+02:00] request.INFO: Matched route "contao_core_sitemap__invoke". {"route":"contao_core_sitemap__invoke","route_parameters":{"_route":"contao_core_sitemap__invoke","_scope":"frontend","_controller":"Contao\\CoreBundle\\Controller\\SitemapController"},"request_uri":"https://www.gewerbe-munster.de/sitemap.xml","method":"GET"} {"request_uri":"https://www.gewerbe-munster.de/sitemap.xml","request_method":"GET"} [2026-06-21T10:06:52.514666+02:00] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\SyntaxErrorException: "An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND cc_jobs.published='1'' at line 1" at ExceptionConverter.php line 88 {"exception":"[object] (Doctrine\\DBAL\\Exception\\SyntaxErrorException(code: 1064): An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND cc_jobs.published='1'' at line 1 at /www/htdocs/w01d017a/gewerbe-munster.de/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:88)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1064): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND cc_jobs.published='1'' at line 1 at /www/htdocs/w01d017a/gewerbe-munster.de/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:24)\n[previous exception] [object] (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 MariaDB server version for the right syntax to use near 'AND cc_jobs.published='1'' at line 1 at /www/htdocs/w01d017a/gewerbe-munster.de/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:71)"} {"request_uri":"https://www.gewerbe-munster.de/sitemap.xml","request_method":"GET"} [2026-06-21T10:06:52.565197+02:00] messenger.INFO: Stopping worker. {"transport_names":["contao_prio_high"]} {"request_uri":"https://www.gewerbe-munster.de/sitemap.xml","request_method":"GET"}

Der Aufruf https://meine-domain.de/sitemap.html funktioniert.

Wird die xml-Sitemap bei Contao 5.3 jetzt anders erzeugt, ist das nicht mehr wichtig oder hab ich irgendwas übersehen?

Contao 5.3.45

Grüße

Wie schon tausend mal erwähnt: nutze den Debug-Modus und poste den Stack Trace ;)

Ich sehe in der Fehlermeldung einen Syntax-Fehler in einer SQL-Abfrage.
Ich sehe außerdem ein PCT-Theme.

Möglicherweise ein spezifischer Fehler von PCT und damit hier im Forum schwer zu beantworten.

SyntaxErrorException

Code:

Doctrine\DBAL\Exception\SyntaxErrorException: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND cc_jobs.published='1'' at line 1 at vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:88 at Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(object(Exception), object(Query)) (vendor/doctrine/dbal/src/Connection.php:1976) at Doctrine\DBAL\Connection->handleDriverException(object(Exception), object(Query)) (vendor/doctrine/dbal/src/Connection.php:1918) at Doctrine\DBAL\Connection->convertExceptionDuringQuery(object(Exception), 'SELECT cc_jobs.* FROM cc_jobs WHERE business= AND cc_jobs.published=\'1\'', array(), array()) (vendor/doctrine/dbal/src/Connection.php:1111) at Doctrine\DBAL\Connection->executeQuery('SELECT cc_jobs.* FROM cc_jobs WHERE business= AND cc_jobs.published=\'1\'', array(), array()) (vendor/contao/core-bundle/contao/library/Contao/Database/Statement.php:261) at Contao\Database\Statement->query('', array()) (vendor/contao/core-bundle/contao/library/Contao/Database/Statement.php:218) at Contao\Database\Statement->execute() (system/modules/pct_customelements/PCT/CustomElements/Helper/QueryBuilder.php:144) at PCT\CustomElements\Helper\QueryBuilder->fetch(array('table' => 'cc_jobs', 'columns' => array(array('column' => 'id', 'where' => 'business=', 'filter_id' => null, 'columns' => ''), array('column' => 'published', 'operation' => '=', 'value' => 1, 'columns' => '')), 'limit' => array(), 'fields' => array())) (system/modules/pct_customelements_plugin_customcatalog/PCT/CustomElements/Plugins/CustomCatalog/Core/Controller.php:260) at PCT\CustomElements\Plugins\CustomCatalog\Core\Controller->getResult(array('table' => 'cc_jobs', 'columns' => array(array('column' => 'id', 'where' => 'business=', 'filter_id' => null, 'columns' => ''), array('column' => 'published', 'operation' => '=', 'value' => 1, 'columns' => '')), 'limit' => array(), 'fields' => array())) (system/modules/pct_customelements_plugin_customcatalog/PCT/CustomElements/Plugins/CustomCatalog/Core/CustomCatalog.php:149) at PCT\CustomElements\Plugins\CustomCatalog\Core\CustomCatalog->prepare() (system/modules/pct_customelements_plugin_customcatalog/PCT/CustomElements/Plugins/CustomCatalog/Core/Maintenance.php:757) at PCT\CustomElements\Plugins\CustomCatalog\Core\Maintenance->getCatalogEntriesByModule(object(Result)) (system/modules/pct_customelements_plugin_customcatalog/PCT/CustomElements/Plugins/CustomCatalog/Core/Maintenance.php:658) at PCT\CustomElements\Plugins\CustomCatalog\Core\Maintenance->getSearchablePages(array(), array(3593, 3599, 3598, 1665, 3609, 1648, 1662, 1666, 1673, 3541, 3542, 3588, 3589, 3594, 3596, 3601, 3608, 1677, 1675, 3607, 1649, 1664, 1668, 1669, 1670, 1671, 3585, 3586, 3587, 3590, 3595, 3597, 3591, 3592, 3602, 3603, 3605, 3600)) (system/modules/pct_customelements_plugin_customcatalog/PCT/CustomCatalog/EventListener/SitemapListener.php:26) at PCT\CustomCatalog\EventListener\SitemapListener::invoke(object(SitemapEvent), 'contao.sitemap', object(TraceableEventDispatcher)) (vendor/symfony/event-dispatcher/Debug/WrappedListener.php:116) at Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke(object(SitemapEvent), 'contao.sitemap', object(TraceableEventDispatcher)) (vendor/symfony/event-dispatcher/EventDispatcher.php:220) at Symfony\Component\EventDispatcher\EventDispatcher->callListeners(array(object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener)), 'contao.sitemap', object(SitemapEvent)) (vendor/symfony/event-dispatcher/EventDispatcher.php:56) at Symfony\Component\EventDispatcher\EventDispatcher->dispatch(object(SitemapEvent), 'contao.sitemap') (vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:142) at Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch(object(SitemapEvent), 'contao.sitemap') (vendor/contao/core-bundle/src/Controller/SitemapController.php:81) at Contao\CoreBundle\Controller\SitemapController->__invoke(object(Request)) (vendor/symfony/http-kernel/HttpKernel.php:181) at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1) (vendor/symfony/http-kernel/HttpKernel.php:76) at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true) (vendor/symfony/http-kernel/Kernel.php:208) at Symfony\Component\HttpKernel\Kernel->handle(object(Request)) (public/index.php:42)

Exception

Code:

Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND cc_jobs.published='1'' at line 1 at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:24 at Doctrine\DBAL\Driver\PDO\Exception::new(object(PDOException)) (vendor/doctrine/dbal/src/Driver/PDO/Connection.php:76) at Doctrine\DBAL\Driver\PDO\Connection->query('SELECT cc_jobs.* FROM cc_jobs WHERE business= AND cc_jobs.published=\'1\'') (vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:33) at Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->query('SELECT cc_jobs.* FROM cc_jobs WHERE business= AND cc_jobs.published=\'1\'') (vendor/doctrine/dbal/src/Logging/Connection.php:43) at Doctrine\DBAL\Logging\Connection->query('SELECT cc_jobs.* FROM cc_jobs WHERE business= AND cc_jobs.published=\'1\'') (vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:33) at Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->query('SELECT cc_jobs.* FROM cc_jobs WHERE business= AND cc_jobs.published=\'1\'') (vendor/symfony/doctrine-bridge/Middleware/Debug/DBAL3/Connection.php:58) at Symfony\Bridge\Doctrine\Middleware\Debug\DBAL3\Connection->query('SELECT cc_jobs.* FROM cc_jobs WHERE business= AND cc_jobs.published=\'1\'') (vendor/doctrine/dbal/src/Connection.php:1106) at Doctrine\DBAL\Connection->executeQuery('SELECT cc_jobs.* FROM cc_jobs WHERE business= AND cc_jobs.published=\'1\'', array(), array()) (vendor/contao/core-bundle/contao/library/Contao/Database/Statement.php:261) at Contao\Database\Statement->query('', array()) (vendor/contao/core-bundle/contao/library/Contao/Database/Statement.php:218) at Contao\Database\Statement->execute() (system/modules/pct_customelements/PCT/CustomElements/Helper/QueryBuilder.php:144) at PCT\CustomElements\Helper\QueryBuilder->fetch(array('table' => 'cc_jobs', 'columns' => array(array('column' => 'id', 'where' => 'business=', 'filter_id' => null, 'columns' => ''), array('column' => 'published', 'operation' => '=', 'value' => 1, 'columns' => '')), 'limit' => array(), 'fields' => array())) (system/modules/pct_customelements_plugin_customcatalog/PCT/CustomElements/Plugins/CustomCatalog/Core/Controller.php:260) at PCT\CustomElements\Plugins\CustomCatalog\Core\Controller->getResult(array('table' => 'cc_jobs', 'columns' => array(array('column' => 'id', 'where' => 'business=', 'filter_id' => null, 'columns' => ''), array('column' => 'published', 'operation' => '=', 'value' => 1, 'columns' => '')), 'limit' => array(), 'fields' => array())) (system/modules/pct_customelements_plugin_customcatalog/PCT/CustomElements/Plugins/CustomCatalog/Core/CustomCatalog.php:149) at PCT\CustomElements\Plugins\CustomCatalog\Core\CustomCatalog->prepare() (system/modules/pct_customelements_plugin_customcatalog/PCT/CustomElements/Plugins/CustomCatalog/Core/Maintenance.php:757) at PCT\CustomElements\Plugins\CustomCatalog\Core\Maintenance->getCatalogEntriesByModule(object(Result)) (system/modules/pct_customelements_plugin_customcatalog/PCT/CustomElements/Plugins/CustomCatalog/Core/Maintenance.php:658) at PCT\CustomElements\Plugins\CustomCatalog\Core\Maintenance->getSearchablePages(array(), array(3593, 3599, 3598, 1665, 3609, 1648, 1662, 1666, 1673, 3541, 3542, 3588, 3589, 3594, 3596, 3601, 3608, 1677, 1675, 3607, 1649, 1664, 1668, 1669, 1670, 1671, 3585, 3586, 3587, 3590, 3595, 3597, 3591, 3592, 3602, 3603, 3605, 3600)) (system/modules/pct_customelements_plugin_customcatalog/PCT/CustomCatalog/EventListener/SitemapListener.php:26) at PCT\CustomCatalog\EventListener\SitemapListener::invoke(object(SitemapEvent), 'contao.sitemap', object(TraceableEventDispatcher)) (vendor/symfony/event-dispatcher/Debug/WrappedListener.php:116) at Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke(object(SitemapEvent), 'contao.sitemap', object(TraceableEventDispatcher)) (vendor/symfony/event-dispatcher/EventDispatcher.php:220) at Symfony\Component\EventDispatcher\EventDispatcher->callListeners(array(object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener)), 'contao.sitemap', object(SitemapEvent)) (vendor/symfony/event-dispatcher/EventDispatcher.php:56) at Symfony\Component\EventDispatcher\EventDispatcher->dispatch(object(SitemapEvent), 'contao.sitemap') (vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:142) at Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch(object(SitemapEvent), 'contao.sitemap') (vendor/contao/core-bundle/src/Controller/SitemapController.php:81) at Contao\CoreBundle\Controller\SitemapController->__invoke(object(Request)) (vendor/symfony/http-kernel/HttpKernel.php:181) at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1) (vendor/symfony/http-kernel/HttpKernel.php:76) at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true) (vendor/symfony/http-kernel/Kernel.php:208) at Symfony\Component\HttpKernel\Kernel->handle(object(Request)) (public/index.php:42)

PDO-Exception

Code:

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND cc_jobs.published='1'' at line 1 at vendor/doctrine/dbal/src/Driver/PDO/Connection.php:71 at PDO->query('SELECT cc_jobs.* FROM cc_jobs WHERE business= AND cc_jobs.published=\'1\'') (vendor/doctrine/dbal/src/Driver/PDO/Connection.php:71) at Doctrine\DBAL\Driver\PDO\Connection->query('SELECT cc_jobs.* FROM cc_jobs WHERE business= AND cc_jobs.published=\'1\'') (vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:33) at Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->query('SELECT cc_jobs.* FROM cc_jobs WHERE business= AND cc_jobs.published=\'1\'') (vendor/doctrine/dbal/src/Logging/Connection.php:43) at Doctrine\DBAL\Logging\Connection->query('SELECT cc_jobs.* FROM cc_jobs WHERE business= AND cc_jobs.published=\'1\'') (vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:33) at Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->query('SELECT cc_jobs.* FROM cc_jobs WHERE business= AND cc_jobs.published=\'1\'') (vendor/symfony/doctrine-bridge/Middleware/Debug/DBAL3/Connection.php:58) at Symfony\Bridge\Doctrine\Middleware\Debug\DBAL3\Connection->query('SELECT cc_jobs.* FROM cc_jobs WHERE business= AND cc_jobs.published=\'1\'') (vendor/doctrine/dbal/src/Connection.php:1106) at Doctrine\DBAL\Connection->executeQuery('SELECT cc_jobs.* FROM cc_jobs WHERE business= AND cc_jobs.published=\'1\'', array(), array()) (vendor/contao/core-bundle/contao/library/Contao/Database/Statement.php:261) at Contao\Database\Statement->query('', array()) (vendor/contao/core-bundle/contao/library/Contao/Database/Statement.php:218) at Contao\Database\Statement->execute() (system/modules/pct_customelements/PCT/CustomElements/Helper/QueryBuilder.php:144) at PCT\CustomElements\Helper\QueryBuilder->fetch(array('table' => 'cc_jobs', 'columns' => array(array('column' => 'id', 'where' => 'business=', 'filter_id' => null, 'columns' => ''), array('column' => 'published', 'operation' => '=', 'value' => 1, 'columns' => '')), 'limit' => array(), 'fields' => array())) (system/modules/pct_customelements_plugin_customcatalog/PCT/CustomElements/Plugins/CustomCatalog/Core/Controller.php:260) at PCT\CustomElements\Plugins\CustomCatalog\Core\Controller->getResult(array('table' => 'cc_jobs', 'columns' => array(array('column' => 'id', 'where' => 'business=', 'filter_id' => null, 'columns' => ''), array('column' => 'published', 'operation' => '=', 'value' => 1, 'columns' => '')), 'limit' => array(), 'fields' => array())) (system/modules/pct_customelements_plugin_customcatalog/PCT/CustomElements/Plugins/CustomCatalog/Core/CustomCatalog.php:149) at PCT\CustomElements\Plugins\CustomCatalog\Core\CustomCatalog->prepare() (system/modules/pct_customelements_plugin_customcatalog/PCT/CustomElements/Plugins/CustomCatalog/Core/Maintenance.php:757) at PCT\CustomElements\Plugins\CustomCatalog\Core\Maintenance->getCatalogEntriesByModule(object(Result)) (system/modules/pct_customelements_plugin_customcatalog/PCT/CustomElements/Plugins/CustomCatalog/Core/Maintenance.php:658) at PCT\CustomElements\Plugins\CustomCatalog\Core\Maintenance->getSearchablePages(array(), array(3593, 3599, 3598, 1665, 3609, 1648, 1662, 1666, 1673, 3541, 3542, 3588, 3589, 3594, 3596, 3601, 3608, 1677, 1675, 3607, 1649, 1664, 1668, 1669, 1670, 1671, 3585, 3586, 3587, 3590, 3595, 3597, 3591, 3592, 3602, 3603, 3605, 3600)) (system/modules/pct_customelements_plugin_customcatalog/PCT/CustomCatalog/EventListener/SitemapListener.php:26) at PCT\CustomCatalog\EventListener\SitemapListener::invoke(object(SitemapEvent), 'contao.sitemap', object(TraceableEventDispatcher)) (vendor/symfony/event-dispatcher/Debug/WrappedListener.php:116) at Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke(object(SitemapEvent), 'contao.sitemap', object(TraceableEventDispatcher)) (vendor/symfony/event-dispatcher/EventDispatcher.php:220) at Symfony\Component\EventDispatcher\EventDispatcher->callListeners(array(object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener)), 'contao.sitemap', object(SitemapEvent)) (vendor/symfony/event-dispatcher/EventDispatcher.php:56) at Symfony\Component\EventDispatcher\EventDispatcher->dispatch(object(SitemapEvent), 'contao.sitemap') (vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:142) at Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch(object(SitemapEvent), 'contao.sitemap') (vendor/contao/core-bundle/src/Controller/SitemapController.php:81) at Contao\CoreBundle\Controller\SitemapController->__invoke(object(Request)) (vendor/symfony/http-kernel/HttpKernel.php:181) at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1) (vendor/symfony/http-kernel/HttpKernel.php:76) at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true) (vendor/symfony/http-kernel/Kernel.php:208) at Symfony\Component\HttpKernel\Kernel->handle(object(Request)) (public/index.php:42)

Grüße

Zitat:

Zitat von mlweb

Ich sehe außerdem ein PCT-Theme.

Möglicherweise ein spezifischer Fehler von PCT und damit hier im Forum schwer zu beantworten.

Ich wusste bisher nicht, dass ein Theme die Sitemap-Erstellung beeinflusst.

Grüße

Ich denke in dem Fall ist es der Custom-Katalog von PCT.

Dürfte an der pct_customelements_plugin_customcatalog Extension liegen.

Der Fehler ist allgemeines SQL

Code:

SELECT cc_jobs.* FROM cc_jobs WHERE business= AND cc_jobs.published=\'1\

Der Wert für das Feld "business" fehlt ggf. durch einen benutzerspezifischen Filter (Frontend-Filter nach Eingabe) oder durch einen manuellen Eintrag mit einem Inserttag. In beiden Fällen ist der Wert leer.

Für die gezielte Sitemap Erstellung kann in den CC-Liste-Modulen die Option "Aus Sitemap ausschließen" gewählt werden. Die Option dient für Listen, die Benutzer-Eingaben voraussetzen bzw. damit können CC-Listen ausschließlich für die Sitemap-Generierung erstellt werden (die anderen werden quasi ausgeschlossen).