Contao/Isotope Datenbank-Fehler bei Produktoptions Änderung

**conter** · 31.01.2024, 09:44

Guten Morgen zusammen,

ich habe einen Fehler in meiner contao/isotope Seite im Aufbau.

Ich wollte bei dem Produkt-Attribut Größe-Select eine weitere Größe hinzufügen und bekomme nach klick auf den Bleistift
backend_isotope_select_groesse.png

Im Manager System-Log

Code:

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 'WHERE pid='5' AND language=''' at line 1" at /var/www/clients/client2/web352/web/v3/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 86

Im Backend Debug-Modus

Code:

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 'WHERE pid='5' AND language=''' at line 1

Stacktraces

Code:

[3/3] SyntaxErrorException 

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 'WHERE pid='5' AND language=''' at line 1

  at vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:86
  at Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert()
     (vendor/doctrine/dbal/src/Connection.php:1938)
  at Doctrine\DBAL\Connection->handleDriverException()
     (vendor/doctrine/dbal/src/Connection.php:1880)
  at Doctrine\DBAL\Connection->convertExceptionDuringQuery()
     (vendor/doctrine/dbal/src/Connection.php:1105)
  at Doctrine\DBAL\Connection->executeQuery()
     (vendor/doctrine/dbal/src/Connection.php:901)
  at Doctrine\DBAL\Connection->fetchAllAssociative()
     (vendor/terminal42/dcawizard/src/Widget/DcaWizard.php:414)
  at Terminal42\DcawizardBundle\Widget\DcaWizard->getRecords()
     (vendor/terminal42/dcawizard/src/Widget/DcaWizard.php:175)
  at Terminal42\DcawizardBundle\Widget\DcaWizard->generate()
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Widget.php:661)
  at Contao\Widget->generateWithError()
     (vendor/contao/core-bundle/src/Resources/contao/templates/backend/be_widget.html5:3)
  at include('/var/www/clients/client2/web352/web/v3/vendor/contao/core-bundle/src/Resources/contao/templates/backend/be_widget.html5')
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/TemplateInheritance.php:108)
  at Contao\Widget->inherit()
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Widget.php:608)
  at Contao\Widget->parse()
     (vendor/contao/core-bundle/src/Resources/contao/classes/DataContainer.php:804)
  at Contao\DataContainer->row()
     (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:1985)
  at Contao\DC_Table->edit()
     (vendor/isotope/isotope-core/system/modules/isotope/library/Isotope/BackendModule/BackendOverview.php:245)
  at Isotope\BackendModule\BackendOverview->getModule()
     (vendor/isotope/isotope-core/system/modules/isotope/library/Isotope/BackendModule/BackendOverview.php:84)
  at Isotope\BackendModule\BackendOverview->generate()
     (vendor/contao/core-bundle/src/Resources/contao/classes/Backend.php:439)
  at Contao\Backend->getBackendModule()
     (vendor/contao/core-bundle/src/Resources/contao/controllers/BackendMain.php:168)
  at Contao\BackendMain->run()
     (vendor/contao/core-bundle/src/Controller/BackendController.php:49)
  at Contao\CoreBundle\Controller\BackendController->mainAction()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:75)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:202)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (web/index.php:44)
  at require('/var/www/clients/client2/web352/web/v3/web/index.php')
     (web/app.php:13)   


[2/3] Exception

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 'WHERE pid='5' AND language=''' at line 1

  at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28
  at Doctrine\DBAL\Driver\PDO\Exception::new()
     (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:132)
  at Doctrine\DBAL\Driver\PDO\Statement->execute()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:69)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute()
     (vendor/doctrine/dbal/src/Logging/Statement.php:98)
  at Doctrine\DBAL\Logging\Statement->execute()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:69)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute()
     (vendor/symfony/doctrine-bridge/Middleware/Debug/DBAL3/Statement.php:78)
  at Symfony\Bridge\Doctrine\Middleware\Debug\DBAL3\Statement->execute()
     (vendor/doctrine/dbal/src/Connection.php:1098)
  at Doctrine\DBAL\Connection->executeQuery()
     (vendor/doctrine/dbal/src/Connection.php:901)
  at Doctrine\DBAL\Connection->fetchAllAssociative()
     (vendor/terminal42/dcawizard/src/Widget/DcaWizard.php:414)
  at Terminal42\DcawizardBundle\Widget\DcaWizard->getRecords()
     (vendor/terminal42/dcawizard/src/Widget/DcaWizard.php:175)
  at Terminal42\DcawizardBundle\Widget\DcaWizard->generate()
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Widget.php:661)
  at Contao\Widget->generateWithError()
     (vendor/contao/core-bundle/src/Resources/contao/templates/backend/be_widget.html5:3)
  at include('/var/www/clients/client2/web352/web/v3/vendor/contao/core-bundle/src/Resources/contao/templates/backend/be_widget.html5')
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/TemplateInheritance.php:108)
  at Contao\Widget->inherit()
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Widget.php:608)
  at Contao\Widget->parse()
     (vendor/contao/core-bundle/src/Resources/contao/classes/DataContainer.php:804)
  at Contao\DataContainer->row()
     (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:1985)
  at Contao\DC_Table->edit()
     (vendor/isotope/isotope-core/system/modules/isotope/library/Isotope/BackendModule/BackendOverview.php:245)
  at Isotope\BackendModule\BackendOverview->getModule()
     (vendor/isotope/isotope-core/system/modules/isotope/library/Isotope/BackendModule/BackendOverview.php:84)
  at Isotope\BackendModule\BackendOverview->generate()
     (vendor/contao/core-bundle/src/Resources/contao/classes/Backend.php:439)
  at Contao\Backend->getBackendModule()
     (vendor/contao/core-bundle/src/Resources/contao/controllers/BackendMain.php:168)
  at Contao\BackendMain->run()
     (vendor/contao/core-bundle/src/Controller/BackendController.php:49)
  at Contao\CoreBundle\Controller\BackendController->mainAction()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:75)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:202)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (web/index.php:44)
  at require('/var/www/clients/client2/web352/web/v3/web/index.php')
     (web/app.php:13)                

[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 'WHERE pid='5' AND language=''' at line 1

  at vendor/doctrine/dbal/src/Driver/PDO/Statement.php:130
  at PDOStatement->execute()
     (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:130)
  at Doctrine\DBAL\Driver\PDO\Statement->execute()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:69)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute()
     (vendor/doctrine/dbal/src/Logging/Statement.php:98)
  at Doctrine\DBAL\Logging\Statement->execute()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:69)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute()
     (vendor/symfony/doctrine-bridge/Middleware/Debug/DBAL3/Statement.php:78)
  at Symfony\Bridge\Doctrine\Middleware\Debug\DBAL3\Statement->execute()
     (vendor/doctrine/dbal/src/Connection.php:1098)
  at Doctrine\DBAL\Connection->executeQuery()
     (vendor/doctrine/dbal/src/Connection.php:901)
  at Doctrine\DBAL\Connection->fetchAllAssociative()
     (vendor/terminal42/dcawizard/src/Widget/DcaWizard.php:414)
  at Terminal42\DcawizardBundle\Widget\DcaWizard->getRecords()
     (vendor/terminal42/dcawizard/src/Widget/DcaWizard.php:175)
  at Terminal42\DcawizardBundle\Widget\DcaWizard->generate()
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Widget.php:661)
  at Contao\Widget->generateWithError()
     (vendor/contao/core-bundle/src/Resources/contao/templates/backend/be_widget.html5:3)
  at include('/var/www/clients/client2/web352/web/v3/vendor/contao/core-bundle/src/Resources/contao/templates/backend/be_widget.html5')
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/TemplateInheritance.php:108)
  at Contao\Widget->inherit()
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Widget.php:608)
  at Contao\Widget->parse()
     (vendor/contao/core-bundle/src/Resources/contao/classes/DataContainer.php:804)
  at Contao\DataContainer->row()
     (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:1985)
  at Contao\DC_Table->edit()
     (vendor/isotope/isotope-core/system/modules/isotope/library/Isotope/BackendModule/BackendOverview.php:245)
  at Isotope\BackendModule\BackendOverview->getModule()
     (vendor/isotope/isotope-core/system/modules/isotope/library/Isotope/BackendModule/BackendOverview.php:84)
  at Isotope\BackendModule\BackendOverview->generate()
     (vendor/contao/core-bundle/src/Resources/contao/classes/Backend.php:439)
  at Contao\Backend->getBackendModule()
     (vendor/contao/core-bundle/src/Resources/contao/controllers/BackendMain.php:168)
  at Contao\BackendMain->run()
     (vendor/contao/core-bundle/src/Controller/BackendController.php:49)
  at Contao\CoreBundle\Controller\BackendController->mainAction()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:75)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:202)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (web/index.php:44)
  at require('/var/www/clients/client2/web352/web/v3/web/index.php')
     (web/app.php:13)

Wäre toll, wenn mir jemand helfen könnte.

Viele Grüße,
conter

**conter** · 02.02.2024, 14:58

Ich komme hier leider nicht weiter.
Das Problem tritt auf, sobald ich den Optionen-Manager versuche, aufzurufen.
Dann kommt der Screen mit

Code:

Internal Server Error
Was ist das Problem?
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 'WHERE pid='9' AND language=''' at line 1

Details oben

Die Tabelle tl_iso_attribute_option sieht meiner Meinung nach unauffällig aus.
Es gibt einmal die Option Abrechnungsmodell mit den Werten "Mieten" oder "Kaufen" mit den pid 0 und
einmal die Option Größe mit einigen Werten, da ist die pid bei allen 5.

Davon abgesehen funktioniert Backend und Frontend.

Hat noch jemand eine Idee, wo der Wurm drin stecken könnte?

Viele Grüße,
conter

**Spooky** · 02.02.2024, 14:59

Welche Isotope Version?

**conter** · 02.02.2024, 17:33

Das ist Version 2.8.17

**conter** · 04.02.2024, 18:57

Ich glaube, ich habe das Problem durch Zufall gefunden ...
Ich hatte mir den Shop lokal geklont und nachdem im Installtool ein ALTER TABLE tl_iso_attribute nötig wurde, habe ich auch bei meinem fehlerhaften System auch mal ins Installtool geschaut und habe da dasselbe ALTER durchgeführt und dann gings wieder.
Es war mir nicht bewusst, dass ich nach Attribut-Änderungen im Backend auch die Datenbank aktualisieren muss.
Viele Grüße,
conter