Solved

Blank Pages Centreon 23.04

  • 20 June 2023
  • 6 replies
  • 328 views

Badge +4

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.

icon

Best answer by Laurent 20 June 2023, 11:35

View original

6 replies

Userlevel 6
Badge +18

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

Badge +4
[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”

Userlevel 6
Badge +18

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;

 

Badge +4

@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?

Badge +4

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

Userlevel 6
Badge +18

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

Reply