Skip to main content

Hello everyone :)

 

After migrating and troubleshooting several issues, the custom view widgets aren't working for me. They once worked again, but suddenly they don't.

 

Any ideas are welcome. Thank you very much in advance.

Hi ​@Alvaro which version of Centreon do you use?

Can you check in /var/log/php-fpm/centreon-errors.log file?


Hi ​@Alvaro which version of Centreon do you use?

Can you check in /var/log/php-fpm/centreon-errors.log file?

My version is Centreon 24.10.6

I dont use php-fpm, i have apache configured:
The error log of apache has this configured:
rFri Apr 04 10:09:49.053089 2025] 2proxy_fcgi:error] opid 1262077:tid 1262121] 2client 192.168.50.74:65108] AH01071: Got error 'PHP message: g2025-04-04T10:09:49+0200] 0CRITICAL] Uncaught Exception: Error while executing the prepared query: SQLSTATET42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'centreon_storage.i.host_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by {"exception":"nobject] (CentreonDbException(code: 11): Error while executing the prepared query: SQLSTATET42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'centreon_storage.i.host_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by at /usr/share/centreon/www/class/centreonDB.class.php:291)\\n)previous exception] oobject] (PDOException(code: 42000): SQLSTATET42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is no...', referer: https://192.168.50.39:11443/centreon/main.get.php?p=103
rFri Apr 04 10:13:49.345679 2025] 2proxy_fcgi:error] opid 1262077:tid 1262105] 0client 192.168.50.74:65487] AH01071: Got error 'PHP message: g2025-04-04T10:13:49+0200] 0CRITICAL] Uncaught Exception: Error while executing the prepared query: SQLSTATET42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'centreon_storage.i.host_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by {"exception":"nobject] (CentreonDbException(code: 11): Error while executing the prepared query: SQLSTATET42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'centreon_storage.i.host_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by at /usr/share/centreon/www/class/centreonDB.class.php:291)\\n)previous exception] oobject] (PDOException(code: 42000): SQLSTATET42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is no...', referer: https://192.168.50.39:11443/centreon/main.get.php?p=103
rFri Apr 04 10:13:49.349298 2025] 2proxy_fcgi:error] opid 1262077:tid 1262117] 1client 192.168.50.74:65503] AH01071: Got error 'PHP message: g2025-04-04T10:13:49+0200] 0CRITICAL] Uncaught Exception: Error while executing the prepared query: SQLSTATET42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'centreon_storage.i.host_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by {"exception":"nobject] (CentreonDbException(code: 11): Error while executing the prepared query: SQLSTATET42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'centreon_storage.i.host_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by at /usr/share/centreon/www/class/centreonDB.class.php:291)\\n)previous exception] oobject] (PDOException(code: 42000): SQLSTATET42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is no...', referer: https://192.168.50.39:11443/centreon/main.get.php?p=103
root@Centreon:/var/log/centreon# tail -n 100 /var/log/apache2/error.log


Hi ​@Alvaro which version of Centreon do you use?

Can you check in /var/log/php-fpm/centreon-errors.log file?

@Laurent Solved!!
To solve it (Not permanent, only in session)

SET GLOBAL sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION';


(Permanent)I add this configuration to my.cnf and the widgets pop up, the logs error solved too:

 


Reply