[Bug]: Installation fails with SQL syntax error

pietzschke commented 7 months ago

Plugin Version

5.0.0

PHP Version

8.2

Shopware Version

6.5.7.4

Installation method

Community-Store

Identity provider

None

What happened?

Installation fails with the error in the log. Tried deletion and reinstall. Maybe it's related to MariaDB.

Relevant log output

[2024-01-18T14:24:12.506964+00:00] app.ERROR: Migration: "Heptacom\AdminOpenAuth\Migration\Migration1693915434MigrateSamlConfigRequestedAuthnContext" failed: "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 'json)) WHERE     `provider` IN ('saml2', 'jumpcloud')     AND (         JSON_...' at line 2" [] []
[2024-01-18T14:24:19.604179+00: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 'json)) WHERE     `provider` IN ('saml2', 'jumpcloud')     AND (         JSON_...' at line 2" at /vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 86 {"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 'json))\nWHERE\n    `provider` IN ('saml2', 'jumpcloud')\n    AND (\n        JSON_...' at line 2 at /dev.ses-sandmann.de/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:86)\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 'json))\nWHERE\n    `provider` IN ('saml2', 'jumpcloud')\n    AND (\n        JSON_...' at line 2 at /vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\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 'json))\nWHERE\n    `provider` IN ('saml2', 'jumpcloud')\n    AND (\n        JSON_...' at line 2 at /vendor/doctrine/dbal/src/Driver/PDO/Connection.php:33)"} []

JoshuaBehrens commented 7 months ago

@pietzschke can you provide us the mariadb version? As we are only testing MySQL I can support your estimate, that it is an issue with that, but we can give it a try to fix that.