UpdateDB: Error 1146

[SlyT]

During upgrade process in the last stage I tried to patch ods database. During this I got message error:

Error 1146 (42S02) at line 2: Table "ods.oreon_informations" doesn't exist

I checked ODS database and there is no such table. There are tables:
config
data_bin
data_stats_daily
data_stats_monthly
data_stats_yearly
index_data
instance
log
metrics
statistics

I also checked ods.conf and there is nothing wrong.

How can I fix it ?

[WAtt]

When you have select a wrong file when you have process to upgrade.

SQL file for ODS on Oreon database and Oreon SQL file on ODS database....

[SlyT]

I dont remember to have such a question during upgrade process.

Can it be fixed manually ?

[WAtt]

Hi,

Try SQL submit with this page http://wiki.centreon.com/index.php/How_to_update_Centreon-1.4.2.2_to_Centreon-1.4.2.3_%3F


If you have a backup before your upgrade, retore your DB :)

[SlyT]

I cant submit SQL from the page you gave me due to above error.
I've just found initial scheme of ODS database in script createTablesODS.sql but there is no table called "oreon_informations". Where does it come from ?