Skip to main content
Solved

Blank Pages Centreon 23.04

  • June 20, 2023
  • 6 replies
  • 559 views
R
Forum|alt.badge.img+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.

Best answer by lpinsivy

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;

 

6 replies

lpinsivy
Centreonian
Forum|alt.badge.img+21
  • lpinsivy
  • Centreonian
  • June 20, 2023

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

R
Forum|alt.badge.img+4
  • ReneRohe
  • Author
  • Steward **
  • June 20, 2023
[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”

lpinsivy
Centreonian
Forum|alt.badge.img+21
  • lpinsivy
  • Centreonian
  • Answer
  • June 20, 2023

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;

 

    R
    Forum|alt.badge.img+4
    • ReneRohe
    • Author
    • Steward **
    • June 20, 2023

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

    R
    Forum|alt.badge.img+4
    • ReneRohe
    • Author
    • Steward **
    • June 20, 2023

    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

    lpinsivy
    Centreonian
    Forum|alt.badge.img+21
    • lpinsivy
    • Centreonian
    • June 20, 2023

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

      Terms & ConditionsCookie settingsAccessibility statement