Hello I’ve upgrade my old CentOS7 with Centreon 22.04 to OL8 with Centreon 24.
I had to remove all mariadb, and centreon package to proceed the OS upgrade.
The database is now correctly configured, I have my old data, and want to make the Centreon Upgrade.
When I goes to page /install/upgrade, and start upgrade, I’m currently stuck at step 4: 22.10.30 to 23.04.0
When I check logs I see some errors:
sql-error.log
>
p2025-06-06T15:14:01+02:00] ERROR : OCentreonDb] Error while executing the simple query: SQLSTATES42S22]: Column not found: 1054 Unknown column 'sat.token_type' in 'where clause' | {"context":{"default":{"back_trace":{"file":"/usr/share/centreon/www/class/centreonDB.class.php","line":947,"class":null,"function":null},"request_infos":{"url":null,"http_method":null,"server":null,"referrer":null}},"exception":{"exception_type":"PDOException","file":"/usr/share/centreon/www/class/centreonDB.class.php","line":342,"code":"42S22","message":"SQLSTATES42S22]: Column not found: 1054 Unknown column 'sat.token_type' in 'where clause'","previous":null},"custom":{"db_name":"centreon","query":"DELETE st FROM security_token st\nWHERE st.expiration_date < UNIX_TIMESTAMP(NOW())\nAND EXISTS (\n SELECT 1\n FROM security_authentication_tokens sat\n WHERE sat.provider_token_refresh_id = st.id\n AND sat.token_type = 'auto'\n LIMIT 1\n)","pdo_error_infos":o"42S22",1054,"Unknown column 'sat.token_type' in 'where clause'"],"pdo_error_code":"42S22"}}}
centreon-web
> -2025-06-06T15:25:01+02:00] INFO : TokenRemoval CRON: failed to delete old tokens | {"context":{"default":{"back_trace":{"file":"/usr/share/centreon/cron/outdated-token-removal.php","line":46,"class":null,"function":null},"request_infos":{"url":null,"http_method":null,"server":null,"referrer":null}},"exception":null,"custom":null}
How may I unstuck it ?