I updated our otrs installation from znuny 6.3.1 to 6.3.4, after the update / migration script we got the following Error Messages in the otrs log:
Code: Select all
[Mon Jul 4 10:52:42 2022][Error][Kernel::System::DBCRUD::MigrateUUIDDatabaseTableColumns][1800] Unknown column 'z4o_database_backend_uuid' in 'field list', SQL: 'SELECT z4o_database_backend_uuid FROM oauth2_token LIMIT 1'
[Mon Jul 4 10:52:42 2022][Error][Kernel::System::DBCRUD::MigrateUUIDDatabaseTableColumns][1800] Unknown column 'database_backend_uuid' in 'field list', SQL: 'SELECT database_backend_uuid FROM oauth2_token LIMIT 1'
[Mon Jul 4 10:52:42 2022][Error][Kernel::System::DBCRUD::MigrateUUIDDatabaseTableColumns][1800] Unknown column 'z4o_database_backend_uuid' in 'field list', SQL: 'SELECT z4o_database_backend_uuid FROM oauth2_token_config LIMIT 1'
[Mon Jul 4 10:52:42 2022][Error][Kernel::System::DBCRUD::MigrateUUIDDatabaseTableColumns][1800] Unknown column 'database_backend_uuid' in 'field list', SQL: 'SELECT database_backend_uuid FROM oauth2_token_config LIMIT 1'
Code: Select all
mysql> show columns from oauth2_token;
+-------------------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------------------+--------------+------+-----+---------+----------------+
| id | int | NO | PRI | NULL | auto_increment |
| token_config_id | int | NO | UNI | NULL | |
| authorization_code | text | YES | | NULL | |
| token | text | YES | | NULL | |
| token_expiration_date | datetime | YES | | NULL | |
| refresh_token | text | YES | | NULL | |
| refresh_token_expiration_date | datetime | YES | | NULL | |
| error_message | text | YES | | NULL | |
| error_description | text | YES | | NULL | |
| error_code | varchar(250) | YES | | NULL | |
| create_time | datetime | NO | | NULL | |
| create_by | int | NO | MUL | NULL | |
| change_time | datetime | NO | | NULL | |
| change_by | int | NO | MUL | NULL | |
| dbcrud_uuid | varchar(36) | YES | UNI | NULL | |
+-------------------------------+--------------+------+-----+---------+----------------+
Code: Select all
mysql> show columns from oauth2_token_config;
+-------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+----------------+
| id | int | NO | PRI | NULL | auto_increment |
| name | varchar(250) | NO | UNI | NULL | |
| config | text | NO | | NULL | |
| valid_id | smallint | NO | MUL | NULL | |
| create_time | datetime | NO | | NULL | |
| create_by | int | NO | MUL | NULL | |
| change_time | datetime | NO | | NULL | |
| change_by | int | NO | MUL | NULL | |
| dbcrud_uuid | varchar(36) | YES | UNI | NULL | |
+-------------+--------------+------+-----+---------+----------------+
How can I resolve these error message, is it enough to create these columns?