Skip to main content

 

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

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

use centreon;

 

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!

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