Your software
My Mautic version is:4.4.5
My PHP version is:7.4
while creating a API credential this issue is coming and after creation it is showing 500 error
[2024-04-02 03:39:10] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: “An exception occurred while executing ‘INSERT INTO oauth2_clients (name, random_id, secret, redirect_uris, allowed_grant_types, role_id) VALUES (?, ?, ?, ?, ?, ?)’ with params [“pabbly”, “1jqma97im1q8wggcwkw0000ocs0gwg0wok4gc4s8kwggc444kg”, “4dhu0va61neoo0oscswwckggsw8g0ko84880k00k4w8kw04kg8”, “a:1:{i:0;s:29:"https://domain";}”, “a:3:{i:0;s:18:"authorization_code";i:1;s:13:"refresh_token";i:2;s:18:"client_credentials";}”, 1]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘role_id’ in ‘field list’” at /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 {“exception”:“[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing ‘INSERT INTO oauth2_clients (name, random_id, secret, redirect_uris, allowed_grant_types, role_id) VALUES (?, ?, ?, ?, ?, ?)’ with params ["pabbly", "1jqma97im1q8wggcwkw0000ocs0gwg0wok4gc4s8kwggc444kg", "4dhu0va61neoo0oscswwckggsw8g0ko84880k00k4w8kw04kg8", "a:1:{i:0;s:29:\"https:\/\/domain\";}", "a:3:{i:0;s:18:\"authorization_code\";i:1;s:13:\"refresh_token\";i:2;s:18:\"client_credentials\";}", 1]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘role_id’ in ‘field list’ at /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\DBAL\Driver\PDO\Exception(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘role_id’ in ‘field list’ at /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘role_id’ in ‘field list’ at /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)”} {“hostname”:“”,“pid”:10088}