HeptacomShopwarePlatformAdminOpenAuth
HeptacomShopwarePlatformAdminOpenAuth copied to clipboard
[Bug]: Installation fails with SQL syntax error
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)"} []