Update RC2 to RC3: An exception occurred while executing 'SELECT DISTINCT type FROM tl_page WHERE…

[planepix]

Affected version(s)

Contao 4.10. RC3

Description

This error occurs after updating RC2 to RC3.
No additional bundle are installed.
PHP 7.4
allinkl

The error ist shown when:

• articles
• page structure
  is clicked on the left menu.

3 StackTraces:
PDOException (1/2)

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 ')' at line 1

  at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78
  at PDO->query('SELECT DISTINCT `type` FROM tl_page WHERE id IN()')
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78)
  at Doctrine\DBAL\Driver\PDOConnection->query('SELECT DISTINCT `type` FROM tl_page WHERE id IN()')
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:911)
  at Doctrine\DBAL\Connection->executeQuery('SELECT DISTINCT `type` FROM tl_page WHERE id IN()')
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:274)
  at Contao\Database\Statement->query()
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:248)
  at Contao\Database\Statement->execute(array())
     (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:5698)
  at Contao\DC_Table->filterMenu(1)
     (vendor/contao/core-bundle/src/Resources/contao/classes/DataContainer.php:1170)
  at Contao\DataContainer->panel()
     (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:352)
  at Contao\DC_Table->showAll()
     (vendor/contao/core-bundle/src/Resources/contao/classes/Backend.php:644)
  at Contao\Backend->getBackendModule('page', null)
     (vendor/contao/core-bundle/src/Resources/contao/controllers/BackendMain.php:167)
  at Contao\BackendMain->run()
     (vendor/contao/core-bundle/src/Controller/BackendController.php:48)
  at Contao\CoreBundle\Controller\BackendController->mainAction()
     (vendor/symfony/http-kernel/HttpKernel.php:158)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:80)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:201)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (web/index.php:31)

PDOException (2/2)

Doctrine\DBAL\Driver\PDOException:
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 ')' at line 1

  at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:83
  at Doctrine\DBAL\Driver\PDOConnection->query('SELECT DISTINCT `type` FROM tl_page WHERE id IN()')
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:911)
  at Doctrine\DBAL\Connection->executeQuery('SELECT DISTINCT `type` FROM tl_page WHERE id IN()')
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:274)
  at Contao\Database\Statement->query()
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:248)
  at Contao\Database\Statement->execute(array())
     (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:5698)
  at Contao\DC_Table->filterMenu(1)
     (vendor/contao/core-bundle/src/Resources/contao/classes/DataContainer.php:1170)
  at Contao\DataContainer->panel()
     (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:352)
  at Contao\DC_Table->showAll()
     (vendor/contao/core-bundle/src/Resources/contao/classes/Backend.php:644)
  at Contao\Backend->getBackendModule('page', null)
     (vendor/contao/core-bundle/src/Resources/contao/controllers/BackendMain.php:167)
  at Contao\BackendMain->run()
     (vendor/contao/core-bundle/src/Controller/BackendController.php:48)
  at Contao\CoreBundle\Controller\BackendController->mainAction()
     (vendor/symfony/http-kernel/HttpKernel.php:158)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:80)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:201)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (web/index.php:31)

SyntaxErrorException

Doctrine\DBAL\Exception\SyntaxErrorException:
An exception occurred while executing 'SELECT DISTINCT `type` FROM tl_page WHERE id IN()':

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 ')' at line 1

  at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79
  at Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception occurred while executing \'SELECT DISTINCT `type` FROM tl_page WHERE id IN()\':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 \')\' at line 1', object(PDOException))
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:169)
  at Doctrine\DBAL\DBALException::wrapException(object(Driver), object(PDOException), 'An exception occurred while executing \'SELECT DISTINCT `type` FROM tl_page WHERE id IN()\':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 \')\' at line 1')
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:149)
  at Doctrine\DBAL\DBALException::driverExceptionDuringQuery(object(Driver), object(PDOException), 'SELECT DISTINCT `type` FROM tl_page WHERE id IN()', array())
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:914)
  at Doctrine\DBAL\Connection->executeQuery('SELECT DISTINCT `type` FROM tl_page WHERE id IN()')
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:274)
  at Contao\Database\Statement->query()
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:248)
  at Contao\Database\Statement->execute(array())
     (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:5698)
  at Contao\DC_Table->filterMenu(1)
     (vendor/contao/core-bundle/src/Resources/contao/classes/DataContainer.php:1170)
  at Contao\DataContainer->panel()
     (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:352)
  at Contao\DC_Table->showAll()
     (vendor/contao/core-bundle/src/Resources/contao/classes/Backend.php:644)
  at Contao\Backend->getBackendModule('page', null)
     (vendor/contao/core-bundle/src/Resources/contao/controllers/BackendMain.php:167)
  at Contao\BackendMain->run()
     (vendor/contao/core-bundle/src/Controller/BackendController.php:48)
  at Contao\CoreBundle\Controller\BackendController->mainAction()
     (vendor/symfony/http-kernel/HttpKernel.php:158)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:80)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:201)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (web/index.php:31)
```
Maybe same as here: https://github.com/contao/contao/issues/2109

[aschempp]

This should be fixed by #2105. Too bad this hasn't made it into RC3. Can you try to delete your user session (go to user profile in top right menu and clear the session data from there)?

[planepix]

@aschempp This hint made it. Also editing CE text with TinyMCE works well.