Skip to main content

I have the problem that almost all pages like “Custom Views”, “Monitoring Connectors Manager”, “Host configuration”, “Service configuration” are displayed as a blank white / black page.

The only menu working - luckily - ist the “Resources Status”.

Example “Custom Views”

What can I do. I really need to manage my hosts in the next days and add some more…

DNF Update is up to date on my server.

I only have this one central server.

Running on ALMA 8 Linux.

Hi @ReneRohe do you have errors in /var/log/php-fpm/centreon-errors.log when you access to these pages?


[20-Jun-2023 11:17:30 Europe/Berlin] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'topology_url_substitute' in 'field list' in /usr/share/centreon/www/class/centreonDBStatement.class.php:132
Stack trace:
#0 /usr/share/centreon/www/class/centreonDBStatement.class.php(132): PDOStatement->execute()
#1 /usr/share/centreon/www/main.get.php(130): CentreonDBStatement->execute()
#2 /usr/share/centreon/www/main.get.php(142): {closure}()
#3 {main}
thrown in /usr/share/centreon/www/class/centreonDBStatement.class.php on line 132

I get this message when for example trying to open “custom views”


Hi @ReneRohe , it’s a fresh install or an update from previous version?

Can you execute this SQL request:

ALTER TABLE topology ADD topology_url_substitute VARCHAR(255) NULL AFTER topology_url_opt;

 


@Laurent it´s not a fresh install. I updated from 23.03 to 23.04.

I can still run the sql request if its an updated platform?


That fixed it

Thank you @Laurent for the quick help

 

Seems to be a bug maybe otherwise i could not explain why this table was missing


@ReneRohe sorry for the problems encountered, we are currently working on fixing this problem.


Reply