Ok I found that ehi_vrml_image column in extended_host_information doesn’t exist.
In the SQL script I found that this column exist in CreateTables.sql and then is deleted in the script Update-DB-2.8.17.sql.
I commented line 1376 of /usr/share/centreon/www/class/centreon-clapi/centreonHost.class.php.
And the export went well.
1368 $params = $extendedObj->getParameters(
1369 $element[$this->object->getPrimaryKey()],
1370 array(
1371 "ehi_notes",
1372 "ehi_notes_url",
1373 "ehi_action_url",
1374 "ehi_icon_image",
1375 "ehi_icon_image_alt",
1376 //"ehi_vrml_image",
1377 "ehi_statusmap_image",
1378 "ehi_2d_coords",
1379 "ehi_3d_coords"
1380 )
Does centreon need this column or not ? Is it a bug ?
Hello @mullergg ,
Actually centreon needs that column in the table extended_host_information.
You could add it using this request:
ALTER TABLE extended_host_information
ADD COLUMN ehi_vrml_image int(11) AFTER ehi_icon_image_alt;
