Skip to main content
Solved

Centreon Widgets not working after migration

  • April 3, 2025
  • 3 replies
  • 92 views

Forum|alt.badge.img+3

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.

Best answer by Alvaro

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:

 

3 replies

lpinsivy
Centreonian
Forum|alt.badge.img+21
  • Centreonian
  • April 3, 2025

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

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


Forum|alt.badge.img+3
  • Author
  • Steward *
  • April 4, 2025

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:
[Fri Apr 04 10:09:49.053089 2025] [proxy_fcgi:error] [pid 1262077:tid 1262121] [client 192.168.50.74:65108] AH01071: Got error 'PHP message: [2025-04-04T10:09:49+0200] [CRITICAL] Uncaught Exception: Error while executing the prepared query: SQLSTATE[42000]: 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":"[object] (CentreonDbException(code: 11): Error while executing the prepared query: SQLSTATE[42000]: 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] [object] (PDOException(code: 42000): SQLSTATE[42000]: 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
[Fri Apr 04 10:13:49.345679 2025] [proxy_fcgi:error] [pid 1262077:tid 1262105] [client 192.168.50.74:65487] AH01071: Got error 'PHP message: [2025-04-04T10:13:49+0200] [CRITICAL] Uncaught Exception: Error while executing the prepared query: SQLSTATE[42000]: 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":"[object] (CentreonDbException(code: 11): Error while executing the prepared query: SQLSTATE[42000]: 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] [object] (PDOException(code: 42000): SQLSTATE[42000]: 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
[Fri Apr 04 10:13:49.349298 2025] [proxy_fcgi:error] [pid 1262077:tid 1262117] [client 192.168.50.74:65503] AH01071: Got error 'PHP message: [2025-04-04T10:13:49+0200] [CRITICAL] Uncaught Exception: Error while executing the prepared query: SQLSTATE[42000]: 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":"[object] (CentreonDbException(code: 11): Error while executing the prepared query: SQLSTATE[42000]: 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] [object] (PDOException(code: 42000): SQLSTATE[42000]: 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


Forum|alt.badge.img+3
  • Author
  • Steward *
  • Answer
  • April 4, 2025

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: