Hello,
Je viens de refaire des tests (d’abord sans mettre le plugin a jour, pour bien valider le problème), et ca ne plante pas juste avec un message contenant une simple apostrophe comme je le pensais.
en fait, j’ai envoyé un message avec du texte (avec une apostrophe et un smiley) ET une image.
Le log http.error :
0026|[Tue Jan 17 19:34:51.633868 2023] [php7:error] [pid 4195] [client 127.0.0.1:42970] PHP Fatal error: Uncaught Exception: [MySQL] Error code : 22007 (1366). Incorrect string value: '\xF0\x9F\x98\x89' for column `jeedom`.`history`.`value` at row 1 : REPLACE INTO history
0027|SET cmd_id=:cmd_id,
0028|`datetime`=:datetime,
0029|value=:value in /var/www/html/core/class/DB.class.php:102
0030|Stack trace:
0031|#0 /var/www/html/core/class/history.class.php(988): DB::Prepare('REPLACE INTO hi...', Array, 0)
0032|#1 /var/www/html/core/class/cmd.class.php(2296): history->save(Object(signalCmd))
0033|#2 /var/www/html/core/class/cmd.class.php(1782): cmd->addHistoryValue('Tu vois qu'on p...', '2023-01-17 19:3...')
0034|#3 /var/www/html/plugins/signal/core/php/jeeSignal.php(52): cmd->event('Tu vois qu'on p...', NULL)
0035|#4 {main}
0036|thrown in /var/www/html/core/class/DB.class.php on line 102
Le log signal en debug :
[2023-01-17 15:28:07]ERROR : Error on send to jeedom : null
[2023-01-17 19:31:40]DEBUG : state courant: running
[2023-01-17 19:31:40]INFO : Lancement démon signal : sudo /usr/bin/node /var/www/html/plugins/signal/resources/demond/signald.js --loglevel debug --socketport 55099 --signal_server 127.0.0.1:8099/v1/receive/+3366xxxx--callback http://127.0.0.1:80/plugins/signal/core/php/jeeSignal.php --apikey xxxx --cycle 0.3 --pid /tmp/jeedom/signal/deamon.pid
[2023-01-17 18:31:40]INFO : Start signal
[2023-01-17 18:31:40]INFO : Log level on : debug
[2023-01-17 18:31:40]INFO : Socket port : 55099
[2023-01-17 18:31:40]INFO : Docker server : 127.0.0.1:8099/v1/receive/+336xxxx
[2023-01-17 18:31:40]INFO : PID file : /tmp/jeedom/signal/deamon.pid
[2023-01-17 18:31:40]INFO : Apikey : xxxx
[2023-01-17 18:31:40]INFO : Callback : http://127.0.0.1:80/plugins/signal/core/php/jeeSignal.php
[2023-01-17 18:31:40]INFO : Cycle : 0.3
[2023-01-17 18:31:40]INFO : Connect to signal server : ws://127.0.0.1:8099/v1/receive/+336xxxx
[2023-01-17 18:31:40]DEBUG : HTTP listen on 127.0.0.1 port : 55099 started
[2023-01-17 18:31:40]DEBUG : [WebSocket] Connexion au websocket signal-Api établie
[2023-01-17 18:34:51]DEBUG : [WebSocket] Message reçu: {"envelope":{"source":"+336xxxx","sourceNumber":"+336xxxx","sourceUuid":"1d4xxxx178","sourceName":"moi","sourceDevice":1,"timestamp":1673980491174,"syncMessage":{"sentMessage":{"destination":"+336xxxx","destinationNumber":"+33xxxx","destinationUuid":"1d4xxxx8","timestamp":1673980491174,"message":"Tu vois qu'on peut éviter les pics... 😉","expiresInSeconds":0,"viewOnce":false,"attachments":[{"contentType":"image/jpeg","filename":null,"id":"RTJxxxxQ0","size":74900}]}}},"account":"+336xxxx","subscription":0}
[2023-01-17 18:34:51]DEBUG : Send data to jeedom : {"received":{"envelope":{"source":"+336xxxx","sourceNumber":"+336xxxx","sourceUuid":"1dxxxx8","sourceName":"moi","sourceDevice":1,"timestamp":1673980491174,"syncMessage":{"sentMessage":{"destination":"+336xxxx","destinationNumber":"+3366xxxx","destinationUuid":"1xxxx8","timestamp":1673980491174,"message":"Tu vois qu'on peut éviter les pics... 😉","expiresInSeconds":0,"viewOnce":false,"attachments":[{"contentType":"image/jpeg","filename":null,"id":"RTJm7qxxxxQ0","size":74900}]}}},"account":"+336xxxx","subscription":0}}
[2023-01-17 19:34:51]DEBUG : Message de groupe => NON
[2023-01-17 18:34:51]ERROR : Error on send to jeedom : null
PS : tu vois que j’ai aussi quelques lignes comme ca, je ne sais pas si c’est normal :
[2023-01-17 15:28:07]ERROR : Error on send to jeedom : null