Aufruf sitemap.xml führt zu Contao-Fehler

**tschero** · 21.06.2026, 09:13

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

**Spooky** · 21.06.2026, 10:14

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

**mlweb** · 21.06.2026, 10:24

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.

**tschero** · 21.06.2026, 10:36

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

**tschero** · 21.06.2026, 10:37

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

**mlweb** · 21.06.2026, 10:40

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

**Spooky** · 21.06.2026, 13:37

Dürfte an der pct_customelements_plugin_customcatalog Extension liegen.

**Tim G** · Heute, 07:07

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).

Thema: Aufruf sitemap.xml führt zu Contao-Fehler

Themen-Optionen

Thema durchsuchen

Aufruf sitemap.xml führt zu Contao-Fehler

Aktive Benutzer

Aktive Benutzer

Berechtigungen