Announcement

Collapse
No announcement yet.

Mysql Error sur Centreon Views

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Mysql Error sur Centreon Views

    J'ai cette erreur dans l'onglet Centreon Views

    Mysql Error : SELECT id, service_id, service_description, host_name, special FROM index_data WHERE `trashed` = '0' AND host_name = 'google.com' && service_description = 'Alive Hosts' [nativecode=1054 ** Unknown column 'trashed' in 'where clause']

    La table existe et je suis capable de faire une requette Sql sans la condition "WHERE `trashed` = '0' "

    Merci d'avance
    C4ipp3r

    Oreon 1.4.1
    SLES 10 SP1


    Solved the issue : mod oreon.conf.php
    $conf_oreon['db'] = "oreondb";
    $conf_oreon['ods'] = "oreon"; < changed for ODS - all graphs are ok
    Last edited by c4ipp3r; 27 August 2007, 21:03. Reason: found error
    C4IPP3R
    Centreon 2 Nagios 3
    SuSE SLES 10 SP1
    ML350 Dual Xeon

  • #2
    I have a similar error after upgrading from 1.4 to 1.4.1 !
    I can't access the Centreon Views..

    the error is:
    Code:
     Mysql Error : SELECT DISTINCT host_name FROM index_data WHERE `trashed` = '0' ORDER BY `host_name` [nativecode=1054 ** Unknown column 'trashed' in 'where clause']
    Fatal error: Call to undefined method DB_Error::fetchInto() in /usr/local/oreon/www/include/views/graphs/graphODS/graphODSByHost.php on line 51
    And when I try to update my CentreonDataStorage options in the Centreon frontend I get the following error:

    Code:
    DB Error : UPDATE `config` SET `RRDdatabase_path` = '/usr/local/oreon/OreonDataStorage/', `len_storage_rrd` = '365', `len_storage_mysql` = '365', `autodelete_rrd_db` = '1', `sleep_time` = '10', `purge_interval` = '30', `auto_drop` = '1', `drop_file` = '/usr/local/nagios/var/service-perfdata_temp', `perfdata_file` = '/usr/local/nagios/var/service-perfdata', `archive_log` = '1', `fast_parsing` = '0', `nagios_log_file` = '/usr/local/nagios/var/nagios.log', `archive_retention` = '31', `storage_type` = '2' WHERE `id` = 1 LIMIT 1 ; [nativecode=1054 ** Unknown column 'len_storage_mysql' in 'field list']
    ## EDIT ##
    It's "Server DEV" in my signature..

    Last edited by Jogarem; 7 January 2008, 16:20. Reason: added host info
    isyVmon 2.4 including Centreon 2.2, we are currently searching for BETA testers ;o)
    isyVmon 2.2 including Centreon 2.1.13, Smartphone APP, Splunk integration, Windows Monitoring and many more

    see http://www.isyVmon.com for more details in our FREEWARE Centreon appliance!

    (isyVmon is a product of Nagios & Centreon enthusiasts started in 2007 and is the very first ready-to-run appliance based on Centreon including Enterprise support and Enterprise features)

    Comment

    Working...
    X