Bonjour,
Le lancement de la mise à jour du plugin virtual étant bloqué à 60% je l’ai relancé comme conseillé mais cela n’a pas résolu le problème et désormais mon jeedom n’est plus fonctionnel, j’ai systématiquement l’erreur 500 Internal Server Error.
En mode rescue j’ai pu récupéré le log http.error :
0000|[Sat Nov 29 21:11:54.238638 2025] [php7:error] [pid 2761:tid 2761] [client 192.168.41.230:21420] PHP Fatal error: Uncaught Exception: [MySQL] Error code : 22007 (1292). Incorrect datetime value: '8' for column `jeedom`.`history`.`datetime` at row 1 : REPLACE INTO history\n SET cmd_id=:cmd_id,\n `datetime`=:datetime,\n value=:value in /var/www/html/core/class/DB.class.php:120\nStack trace:\n#0 /var/www/html/core/class/history.class.php(1093): DB::Prepare()\n#1 /var/www/html/core/class/cmd.class.php(2473): history->save()\n#2 /var/www/html/core/class/cmd.class.php(1953): cmd->addHistoryValue()\n#3 /var/www/html/core/class/eqLogic.class.php(690): cmd->event()\n#4 /var/www/html/plugins/pws/core/class/pws.class.php(122): eqLogic->checkAndUpdateCmd()\n#5 /var/www/html/plugins/pws/core/api/pws.php(25): pws::receiveData()\n#6 {main}\n thrown in /var/www/html/core/class/DB.class.php on line 120
0001|[Sat Nov 29 21:12:55.049500 2025] [php7:error] [pid 2753:tid 2753] [client 192.168.41.230:17313] PHP Fatal error: Uncaught Exception: [MySQL] Error code : 22007 (1292). Incorrect datetime value: '8' for column `jeedom`.`history`.`datetime` at row 1 : REPLACE INTO history\n SET cmd_id=:cmd_id,\n `datetime`=:datetime,\n value=:value in /var/www/html/core/class/DB.class.php:120\nStack trace:\n#0 /var/www/html/core/class/history.class.php(1093): DB::Prepare()\n#1 /var/www/html/core/class/cmd.class.php(2473): history->save()\n#2 /var/www/html/core/class/cmd.class.php(1953): cmd->addHistoryValue()\n#3 /var/www/html/core/class/eqLogic.class.php(690): cmd->event()\n#4 /var/www/html/plugins/pws/core/class/pws.class.php(122): eqLogic->checkAndUpdateCmd()\n#5 /var/www/html/plugins/pws/core/api/pws.php(25): pws::receiveData()\n#6 {main}\n thrown in /var/www/html/core/class/DB.class.php on line 120
0002|[Sat Nov 29 21:13:55.952106 2025] [php7:error] [pid 2739:tid 2739] [client 192.168.41.230:12699] PHP Fatal error: Uncaught Exception: [MySQL] Error code : 22007 (1292). Incorrect datetime value: '8' for column `jeedom`.`history`.`datetime` at row 1 : REPLACE INTO history\n SET cmd_id=:cmd_id,\n `datetime`=:datetime,\n value=:value in /var/www/html/core/class/DB.class.php:120\nStack trace:\n#0 /var/www/html/core/class/history.class.php(1093): DB::Prepare()\n#1 /var/www/html/core/class/cmd.class.php(2473): history->save()\n#2 /var/www/html/core/class/cmd.class.php(1953): cmd->addHistoryValue()\n#3 /var/www/html/core/class/eqLogic.class.php(690): cmd->event()\n#4 /var/www/html/plugins/pws/core/class/pws.class.php(122): eqLogic->checkAndUpdateCmd()\n#5 /var/www/html/plugins/pws/core/api/pws.php(25): pws::receiveData()\n#6 {main}\n thrown in /var/www/html/core/class/DB.class.php on line 120
0003|[Sat Nov 29 21:14:56.979706 2025] [php7:error] [pid 2761:tid 2761] [client 192.168.41.230:44143] PHP Fatal error: Uncaught Exception: [MySQL] Error code : 22007 (1292). Incorrect datetime value: '8' for column `jeedom`.`history`.`datetime` at row 1 : REPLACE INTO history\n SET cmd_id=:cmd_id,\n `datetime`=:datetime,\n value=:value in /var/www/html/core/class/DB.class.php:120\nStack trace:\n#0 /var/www/html/core/class/history.class.php(1093): DB::Prepare()\n#1 /var/www/html/core/class/cmd.class.php(2473): history->save()\n#2 /var/www/html/core/class/cmd.class.php(1953): cmd->addHistoryValue()\n#3 /var/www/html/core/class/eqLogic.class.php(690): cmd->event()\n#4 /var/www/html/plugins/pws/core/class/pws.class.php(122): eqLogic->checkAndUpdateCmd()\n#5 /var/www/html/plugins/pws/core/api/pws.php(25): pws::receiveData()\n#6 {main}\n thrown in /var/www/html/core/class/DB.class.php on line 120
J’ai également lancé une restauration en ligne de commande mais cela n’a rien changé.
Mon jeedom était en 4.5.
Quelqu’un a-t-il déjà rencontré un problème similaire ?