+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
+21Hi
use centreon;
+1Thank 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!
+21Hi
We try to perform update from old Centreon versions but it can depend of which DBMS you are using and about your database values.
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.