centreon-clapi icon indicating copy to clipboard operation
centreon-clapi copied to clipboard

Fatal error with PDOException

Open s-duret opened this issue 9 years ago • 2 comments

Hello,

I can't export configuration with PHP 5.1.6.

I have this error:

PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 2053 ' in /usr/share/centreon/www/modules/centreon-clapi/core/lib/Zend/Db/Statement/Pdo.php:290 Stack trace: #0 /usr/share/centreon/www/modules/centreon-clapi/core/lib/Zend/Db/Statement/Pdo.php(290): PDOStatement->fetchAll(2) #1 /usr/share/centreon/www/modules/centreon-clapi/core/class/centreonDependency.class.php(1242): Zend_Db_Statement_Pdo->fetchAll() #2 /usr/share/centreon/www/modules/centreon-clapi/core/class/centreonDependency.class.php(1053): CentreonDependency->exportServiceDep() #3 /usr/share/centreon/www/modules/centreon-clapi/core/class/centreonAPI.class.php(555): CentreonDependency->export() #4 /usr/share/centreon/www/modules/centreon-clapi/core/centreon(167): CentreonAPI->export() #5 {main}

Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[HY000]: General error: 2053 ' in /usr/share/centreon/www/modules/centreon-clapi/core/lib/Zend/Db/Statement/Pdo.php:294 Stack trace: #0 /usr/share/centreon/www/mod in /usr/share/centreon/www/modules/centreon-clapi/core/lib/Zend/Db/Statement/Pdo.php on line 294

Regards,

s-duret avatar Jun 30 '15 09:06 s-duret

Hi,

Same problem with hostgroup geo_coords.

HG;setparam;Linux;geo_coords;36.52,4.87

PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'hg_geo_coords' in 'field list'' in /usr/share/centreon/lib/Zend/Db/Statement/Pdo.php:228

Stack trace:
#0 /usr/share/centreon/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /usr/share/centreon/lib/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
#2 /usr/share/centreon/lib/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
#3 /usr/share/centreon/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('UPDATE hostgrou...', Array)
#4 /usr/share/centreon/lib/Centreon/Object/Object.php(198): Zend_Db_Adapter_Pdo_Abstract->query('UPDATE hostgrou...', Array)
#5 /usr/share/centreon/www/class/centreon-clapi/centreonObject.class.php(269): Centreon_Object->update('1190', Array)
#6 /usr/share/centreon/www/class/centreon-clapi/centreonHostGroup.class.php(159): CentreonClapi\CentreonObject->setparam('1190', Array)
#7 /usr/share/centreon/www/class/c in /usr/share/centreon/lib/Zend/Db/Statement/Pdo.php on line 234

Best Regards

bmareau avatar Jul 20 '17 09:07 bmareau

Which version of Centreon ?

julienmathis avatar Jul 20 '17 12:07 julienmathis