TinyMCE funktioniert nach Update 4.10.0-RC2 > 4.10.0-RC3 nicht mehr

**peter.fl** · 06.08.2020, 14:56

Guten Tag

Nach dem Update 4.10.0-RC2 > 4.10.0-RC3 via Manager funktioniert TinyMCE nicht mehr. Wenn ich es recht gesehen habe, ist mit dem Update auch eine Wechsel TinyMCE4 > TinyMCE5 verbunden. In .../assets steht immer noch der Ordner TinyMCE4. Im BE > Profil ist "Rich Text Editor verwenden" aktiviert. Das Datenbankupdate ist gemacht, ebenso die Systemwartung.

Beim Klick auf "Seitenstruktur" im BE bekam ich nach dem Update ab und zu die unten angehängte Meldung. Neuerdings ist "Seitenstruktur" im BE gar nicht mehr zugänglich - die Fehlermeldung erscheint bei jedem Aufruf.

In var/logs steht als neuster Eintrag:

[2020-08-06 15:39:02] request.CRITICAL: Uncaught PHP Exception 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 MariaDB server version for the right syntax to use near ')' at line 1" at /home/xxx/www/archiv.xxx.ch/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 {"exception":"[object] (Doctrine\\DBAL\\Exception\\SyntaxErrorException(c ode: 0): An exception occurred while executing 'SELECT DISTINCT `type` FROM tl_page WHERE id IN()':\n\nSQLSTATE[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 ')' at line 1 at /home/xxx/www/archiv.xxx.ch/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 MariaDB server version for the right syntax to use near ')' at line 1 at /home/xxx/www/archiv.xxx.ch/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:83, 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 ')' at line 1 at /home/xxx/www/archiv.xxx.ch/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78)"} []

fehlermeldung.PNG

Beide Meldungen haben offensichtlich etwas mit Datenbank/SQL/Syntax zu tun. Wo soll ich mit der Suche nach der Problemlösung anfangen?

Nachtrag: StackTrace

[1/3] PDOException

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 ')' 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)
at require('/home/peterfl/www/archiv.peter-flueckiger.ch/web/index.php')
(web/app.php:4)

[2/3] PDOException

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 MariaDB 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)
at require('/home/peterfl/www/archiv.peter-flueckiger.ch/web/index.php')
(web/app.php:4)

[3/3] 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 MariaDB 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 MariaDB 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 MariaDB 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::driverExceptionDuring Query(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)
at require('/home/peterfl/www/archiv.peter-flueckiger.ch/web/index.php')
(web/app.php:4)

**Spooky** · 06.08.2020, 15:03

Poste beide Dinge separat als Issues auf GitHub. Nutze den Debug-Modus um zum zweiten Problem den genauen Stack Trace posten zu können.

**planepix** · 06.08.2020, 15:23

Hänge mich mal dran…

Beim Aufruf von „Artikel” kommt folgende Fehlerausgabe:

Code:

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

.

Somit komme ich noch nicht mal bis zum Inhaltselement Text

.
Auch beim Aufruf der Seitenstruktur wird der Fehler ausgegeben.

Update von RC2 auf RC3. PHP 7.4.
Datenbankupdate läuft ohne Fehler durch.

Eigens Issue eröffnet:
https://github.com/contao/contao/issues/2111

StackTrace ( 1/ 3 ):
SyntaxErrorException

Code:

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)

PDOException 1

Code:

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)

PDOException 2

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

**Spooky** · 06.08.2020, 15:39

@peter.fl du hast nun ein Ticket angelegt für zwei verschiedene Probleme. Du solltest immer separate Tickets für separate Probleme anlegen, genau so solltest du hier im Forum immer separate Threads für separate Themen anlegen.

**peter.fl** · 06.08.2020, 15:42

@spooky: Uff, eben habe ich auf GitHub den zweiten Eintrag meines Lebens gemacht. Der erste war vor etwa 6 Jahren... https://github.com/contao/contao/issues/2109. Schau bitte mal, ob der ok ist. Wenn ja, werde ich den zweiten zum Thema TinyMCE auch machen.

**planepix** · 06.08.2020, 15:42

Jupp: https://github.com/contao/contao/issues/2109

Ich mache auch eins - sieht sehr ähnlich aus…

**peter.fl** · 06.08.2020, 15:47

Zitat von Spooky

@peter.fl du hast nun ein Ticket angelegt für zwei verschiedene Probleme. Du solltest immer separate Tickets für separate Probleme anlegen, genau so solltest du hier im Forum immer separate Threads für separate Themen anlegen.

Äxgüsi, ich dachte das sei ein und dasselbe Problem. Soll ich aus meinem Startbeitrag zwei machen? Allerdings weiss ich dann nicht, wie unterschiedlich betiteln.

**planepix** · 06.08.2020, 16:14

Andreas hat auf das Ticket geantwortet:
In den Benutzereinstellungen den Cache leeren ( alle drei Checkboxen ) und danach konnte ich Artikel und die Seitenstruktur öffnen und auch in einem CE Text den TinyMCE nutzen.

-> https://github.com/contao/contao/iss...ment-669985545

**peter.fl** · 06.08.2020, 20:17

Zitat von planepix

Andreas hat auf das Ticket geantwortet:
In den Benutzereinstellungen den Cache leeren ( alle drei Checkboxen ) und danach konnte ich Artikel und die Seitenstruktur öffnen und auch in einem CE Text den TinyMCE nutzen.

Ich habe den Cache wie beschrieben geleert. Dann konnte ich wieder auf die Seitenstruktur zugreifen, aber in Textelementen von Artikeln fehlt TinyMCE weiterhin. Nachdem ich die Seitenstruktur verlassen habe, muss ich erneut die drei Caches im Benutzerprofil leeren, sonst bekomme ich beim Zugriff auf die Seitenstruktur wieder die in #1 angehängte Fehlermeldung.

Habe ich da etwas übersehen?

**Seefahrer** · 07.08.2020, 10:26

Moin,

geht mir genauso, ich habe aber ein angepasstes be_tiny template in Verwendung. Auf den ersten Blick wird der tinymce5 wohl etwas anders parametriert, wird also Anpassungsarbeit nötig sein...

**BugBuster** · 08.08.2020, 17:03

Der Vollständigkeit halber, falls jemand danach sucht:

Code:

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

~~Auch hier hat es geholfen in den Benutzereinstellungen den Cache leeren ( alle drei Checkboxen ) und danach konnte ich Artikel wieder aufrufen.~~
Ne doch nicht :-(
https://github.com/contao/contao/issues/2125