Question

Centreon 22.4 update error

  • 28 August 2023
  • 3 replies
  • 55 views
P
Badge +1

 

Trying to update centreon 20 to 22.4 and on step 4 i see this:
 

Cannot execute query: ALTER TABLE `contact` ADD COLUMN `show_deprecated_pages` enum('0','1') DEFAULT '0' AFTER `default_page`;

in mysql -  ALTER TABLE `contact` ADD COLUMN `show_deprecated_pages` enum('0','1') DEFAULT '0' AFTER `default_page`;
ERROR 1046 (3D000): No database selected

3 replies

Laurent
Rank
Userlevel 6
Badge +18

Hi @philzy , please select ‘centreon’ database before to run SQL request:

use centreon;

 

P
Badge +1

Thank you!
i found needed sql file at this path /usr/share/centreon/www/install/sql/centreon
file Update-DB-20.10.0-beta.1.sql and i inserted “use centreon;”
But i don’t understand why it’s not working out of the box?
Pretty sure, that i’am not alone with such issue during upgrade.
Did the guys do tests before publishing updates?
In any case, thank you!

Laurent
Rank
Userlevel 6
Badge +18

Hi @philzy , sorry for the inconvenience.

We try to perform update from old Centreon versions but it can depend of which DBMS you are using and about your database values.

Reply


Terms & ConditionsCookie settings