Bonjour,
Lors de la synchronisation des équipements, j’ai l’erreur suivante
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '97-Scene Aurore boréale' for key 'unique'
J’ai lu le changelog et je ne suis pas concerné par cette note
IMPORTANT : pour ceux qui ont des prises il est possible que vous ayez une erreur a la synchronisation, il faut donc sur les prises supprimer la commande état et relancer la synchronisation
J’ai supprimé l’ensemble des équipements mais lors de la synchronisation j’ai quand même l’erreur. voici les logs
0000|[2024-01-17 19:18:42] DEBUG : Found device type zigbee_connectivity model : SML003 => {"id":"0d749c09-8f2c-4d14-9982-2a8bf7292b8d","id_v1":"\/sensors\/36","product_data":{"model_id":"SML003","manufacturer_name":"Signify Netherlands B.V.","product_name":"Hue motion sensor","product_archetype":"unknown_archetype","certified":true,"software_version":"2.53.6","hardware_platform_type":"100b-11b"},"metadata":{"name":"D\u00e9tecteur Cuisine","archetype":"unknown_archetype"},"identify":[],"usertest":{"status":"set","usertest":false},"services":[{"rid":"359e873b-8b84-497a-8feb-79c861b5aea3","rtype":"zigbee_connectivity"},{"rid":"6dd437a7-298b-49bc-b1f5-5ca879d0fbbf","rtype":"motion"},{"rid":"495d2ded-05bc-4afb-9001-b183d678d91f","rtype":"device_power"},{"rid":"b286888e-0005-4e6f-aed8-aac28740e017","rtype":"light_level"},{"rid":"e4cdcd25-8458-4265-8f8a-50be6c88c90f","rtype":"temperature"},{"rid":"6d5705c0-bc15-4c84-99db-ff0b2c618d09","rtype":"device_software_update"}],"type":"device"}
0001|[2024-01-17 19:18:43] DEBUG : Found device type zigbee_connectivity model : SML003 => {"id":"4f93fc3a-fb9d-40a4-b7f7-deb5812d38d5","id_v1":"\/sensors\/27","product_data":{"model_id":"SML003","manufacturer_name":"Signify Netherlands B.V.","product_name":"Hue motion sensor","product_archetype":"unknown_archetype","certified":true,"software_version":"2.53.6","hardware_platform_type":"100b-11b"},"metadata":{"name":"D\u00e9tecteur Salon","archetype":"unknown_archetype"},"identify":[],"usertest":{"status":"set","usertest":false},"services":[{"rid":"591c073f-759a-4226-8a25-2d5f2fe301ca","rtype":"zigbee_connectivity"},{"rid":"e112ccec-90c1-4f75-95e0-f1568be75e0e","rtype":"motion"},{"rid":"c57ba751-478d-4cd8-bb5d-4b7f0e66f54c","rtype":"device_power"},{"rid":"03eede4e-c68b-42e0-85ee-62f9e4345f80","rtype":"light_level"},{"rid":"f86ab2a8-6261-4df4-9e06-023a25698e34","rtype":"temperature"},{"rid":"43de2274-8a68-4d06-9ded-5a36774355ba","rtype":"device_software_update"}],"type":"device"}
0002|[2024-01-17 19:18:43] DEBUG : Found device type bridge model : BSB002 => {"id":"68bbee88-1538-4001-b782-7d8358a4350b","product_data":{"model_id":"BSB002","manufacturer_name":"Signify Netherlands B.V.","product_name":"Hue Bridge","product_archetype":"bridge_v2","certified":true,"software_version":"1.62.1962097030"},"metadata":{"name":"JAG Philips hue","archetype":"bridge_v2"},"identify":[],"services":[{"rid":"4e5d1fba-d241-49ba-8037-84de487cbaed","rtype":"bridge"},{"rid":"e12f5ec2-dd98-487c-be95-29c18dbbfc7f","rtype":"zigbee_connectivity"},{"rid":"c884be20-98d6-470e-9bd4-661886ba0fae","rtype":"entertainment"},{"rid":"b32ea46a-094a-4f48-8b2e-f7055e6533b9","rtype":"zigbee_device_discovery"}],"type":"device"}
0003|[2024-01-17 19:18:43] DEBUG : Found device type zigbee_connectivity model : 929003047101 => {"id":"72b027c9-934e-44cf-9b4a-faf37ad18cf8","id_v1":"\/lights\/5","product_data":{"model_id":"929003047101","manufacturer_name":"Signify Netherlands B.V.","product_name":"Hue Milliskin spot","product_archetype":"recessed_ceiling","certified":true,"software_version":"1.104.2","hardware_platform_type":"100b-114"},"metadata":{"name":"Lumi\u00e8re entr\u00e9e salle de bain","archetype":"recessed_ceiling"},"identify":[],"services":[{"rid":"8dfc2de7-d1c8-4d14-a9af-0ea582d12a99","rtype":"zigbee_connectivity"},{"rid":"27f7b72b-6760-4ad2-9d99-1438e8251953","rtype":"light"},{"rid":"d6be4b72-5216-48fb-98ea-1636fe356dc7","rtype":"taurus_7455"},{"rid":"daa77fea-54d5-4b8a-9d77-0ea82b2eb485","rtype":"device_software_update"}],"type":"device"}
0004|[2024-01-17 19:18:43] DEBUG : Found device type zigbee_connectivity model : 440400982841 => {"id":"878f2b83-401a-4905-be83-cff5a326b91f","id_v1":"\/lights\/4","product_data":{"model_id":"440400982841","manufacturer_name":"Signify Netherlands B.V.","product_name":"Hue Play","product_archetype":"hue_play","certified":true,"software_version":"1.104.2","hardware_platform_type":"100b-11d"},"metadata":{"name":"Lumi\u00e8re t\u00e9l\u00e9vision Gauche","archetype":"hue_play"},"identify":[],"services":[{"rid":"dbdf228f-a701-46c6-90ab-50ff59fa5e1d","rtype":"zigbee_connectivity"},{"rid":"74920a59-ec71-46f7-92ab-9733512d9ae3","rtype":"light"},{"rid":"c113e928-b7bf-4107-80f2-a10d0cf80d21","rtype":"entertainment"},{"rid":"e4e0b7d3-6217-406f-9e3a-a8dc18c3b639","rtype":"taurus_7455"},{"rid":"b6d3e724-b20f-44d4-8756-8b2102f5c65e","rtype":"device_software_update"}],"type":"device"}
0005|[2024-01-17 19:18:43] DEBUG : Found device type zigbee_connectivity model : LST002 => {"id":"99f81c2f-6f32-4f26-8aa3-dca6b7ff9274","id_v1":"\/lights\/2","product_data":{"model_id":"LST002","manufacturer_name":"Signify Netherlands B.V.","product_name":"Hue lightstrip plus","product_archetype":"hue_lightstrip","certified":true,"software_version":"67.108.5","hardware_platform_type":"100b-10b"},"metadata":{"name":"LED T\u00e9l\u00e9vision","archetype":"hue_lightstrip"},"identify":[],"services":[{"rid":"65b8bbde-4fe8-47c4-87d2-7bc7056f0601","rtype":"zigbee_connectivity"},{"rid":"36cfa919-e006-4332-98ab-c715f2be5dcf","rtype":"light"},{"rid":"03741e12-86bd-4b6b-a01f-d5e424c45883","rtype":"entertainment"},{"rid":"061e68dd-9568-4f7b-a36e-39ffc29d1d5e","rtype":"taurus_7455"},{"rid":"6930222c-7554-4083-b43f-39cdcd76192a","rtype":"device_software_update"}],"type":"device"}
0006|[2024-01-17 19:18:44] DEBUG : Found device type zigbee_connectivity model : 440400982841 => {"id":"9fd2c63d-f353-47c1-bbaf-4d3de01f625d","id_v1":"\/lights\/3","product_data":{"model_id":"440400982841","manufacturer_name":"Signify Netherlands B.V.","product_name":"Hue Play","product_archetype":"hue_play","certified":true,"software_version":"1.104.2","hardware_platform_type":"100b-11d"},"metadata":{"name":"Lumi\u00e8re t\u00e9l\u00e9vision droite","archetype":"hue_play"},"identify":[],"services":[{"rid":"622fef45-c119-41bb-bb8c-d6423bdb8b60","rtype":"zigbee_connectivity"},{"rid":"bae38c5b-1265-4101-b2f5-a64d6869ebe7","rtype":"light"},{"rid":"7b16af9d-66bb-4717-965e-fb8312d760f3","rtype":"entertainment"},{"rid":"d45356a7-b8c3-4245-b73d-90cbfdbad73a","rtype":"taurus_7455"},{"rid":"a316549a-2341-4ece-8f75-752c929255b8","rtype":"device_software_update"}],"type":"device"}
0007|[2024-01-17 19:18:44] DEBUG : Found device type zigbee_connectivity model : LWB006 => {"id":"acc53898-8a60-4514-a425-5df26205773a","id_v1":"\/lights\/1","product_data":{"model_id":"LWB006","manufacturer_name":"Signify Netherlands B.V.","product_name":"Hue white lamp","product_archetype":"classic_bulb","certified":true,"software_version":"67.108.5","hardware_platform_type":"100b-105"},"metadata":{"name":"Lumi\u00e8re canap\u00e9","archetype":"table_shade"},"identify":[],"services":[{"rid":"c905e80e-8ebb-4da0-bd3c-1303c148d494","rtype":"zigbee_connectivity"},{"rid":"8fae9c7c-ad33-44b4-891a-6d723d53cef8","rtype":"light"},{"rid":"999c5751-deee-4e18-b7db-20d0bad6efa6","rtype":"taurus_7455"},{"rid":"89a28356-9339-4347-b125-b281ee54c194","rtype":"device_software_update"}],"type":"device"}
0008|[2024-01-17 19:18:44] DEBUG : Found device type zigbee_connectivity model : RWL021 => {"id":"f6b71678-5e87-47a5-8fa7-b780d135f044","id_v1":"\/sensors\/2","product_data":{"model_id":"RWL021","manufacturer_name":"Signify Netherlands B.V.","product_name":"Hue dimmer switch","product_archetype":"unknown_archetype","certified":true,"software_version":"1.1.28573","hardware_platform_type":"100b-109"},"metadata":{"name":"T\u00e9l\u00e9commande Salon","archetype":"unknown_archetype"},"services":[{"rid":"c0456634-5efd-48ef-9bfc-7c61103302e2","rtype":"zigbee_connectivity"},{"rid":"1714fc5d-06d9-4fd2-9fd4-42d7480bd4c7","rtype":"button"},{"rid":"2a4917d2-ad89-4f67-8c50-ec83a5d0056a","rtype":"button"},{"rid":"14e8c959-4708-4133-ba90-3d69f14c90ea","rtype":"button"},{"rid":"79df45cb-51b9-4e7c-a7e5-55dbfb3cbab2","rtype":"button"},{"rid":"904ec036-5658-4399-bc90-6cc64efc310f","rtype":"device_power"},{"rid":"f5025c08-fea9-4a4f-9809-f4210d2655f7","rtype":"device_software_update"}],"type":"device"}
0009|[2024-01-17 19:18:44] DEBUG : Found room 9b31d662-56e2-49d4-b373-ac33121f5dc4 => {"id":"9b31d662-56e2-49d4-b373-ac33121f5dc4","id_v1":"\/groups\/1","children":[{"rid":"acc53898-8a60-4514-a425-5df26205773a","rtype":"device"}],"services":[{"rid":"ce3e1adb-179e-4e8f-bb5e-d48acfc289e8","rtype":"grouped_light"}],"metadata":{"name":"Lumi\u00e8re zone canap\u00e9","archetype":"living_room"},"type":"room"}
0010|[2024-01-17 19:18:44] DEBUG : Found room d61dd79f-fb26-41e9-8375-4f30617a5bdd => {"id":"d61dd79f-fb26-41e9-8375-4f30617a5bdd","id_v1":"\/groups\/4","children":[{"rid":"72b027c9-934e-44cf-9b4a-faf37ad18cf8","rtype":"device"}],"services":[{"rid":"5843ac02-8fad-438f-8fa5-cf43b18458e5","rtype":"grouped_light"}],"metadata":{"name":"Lampe Zone Salle de bain","archetype":"bathroom"},"type":"room"}
0011|[2024-01-17 19:18:45] DEBUG : Found room dc1590d1-3788-4b66-afbe-7f177d82530c => {"id":"dc1590d1-3788-4b66-afbe-7f177d82530c","id_v1":"\/groups\/10","children":[{"rid":"878f2b83-401a-4905-be83-cff5a326b91f","rtype":"device"},{"rid":"99f81c2f-6f32-4f26-8aa3-dca6b7ff9274","rtype":"device"},{"rid":"9fd2c63d-f353-47c1-bbaf-4d3de01f625d","rtype":"device"}],"services":[{"rid":"50de6dba-f5b1-4bb5-838b-2a90c511d33a","rtype":"grouped_light"}],"metadata":{"name":"Lumi\u00e8res zone t\u00e9l\u00e9vision","archetype":"living_room"},"type":"room"}
0012|[2024-01-17 19:18:45] DEBUG : Found zone d067003c-3b80-4f83-a9b4-2360aac261a0 => {"id":"d067003c-3b80-4f83-a9b4-2360aac261a0","id_v1":"\/groups\/15","children":[{"rid":"36cfa919-e006-4332-98ab-c715f2be5dcf","rtype":"light"},{"rid":"8fae9c7c-ad33-44b4-891a-6d723d53cef8","rtype":"light"},{"rid":"bae38c5b-1265-4101-b2f5-a64d6869ebe7","rtype":"light"},{"rid":"74920a59-ec71-46f7-92ab-9733512d9ae3","rtype":"light"}],"services":[{"rid":"716b4037-ce76-43de-820f-e3d25752a0cc","rtype":"grouped_light"}],"metadata":{"name":"Lumi\u00e8res Zone salon","archetype":"living_room"},"type":"zone"}
0013|[2024-01-17 19:18:45] DEBUG : Found group light 50de6dba-f5b1-4bb5-838b-2a90c511d33a => {"id":"50de6dba-f5b1-4bb5-838b-2a90c511d33a","id_v1":"\/groups\/10","owner":{"rid":"dc1590d1-3788-4b66-afbe-7f177d82530c","rtype":"room"},"on":{"on":true},"dimming":{"brightness":70.355},"dimming_delta":[],"color_temperature":[],"color_temperature_delta":[],"color":[],"alert":{"action_values":["breathe"]},"signaling":{"signal_values":["alternating","no_signal","on_off","on_off_color"]},"dynamics":[],"type":"grouped_light"}
0014|[2024-01-17 19:18:45] DEBUG : Found group light 51f83d31-9ec0-411d-bdc7-e5cfabb70a11 => {"id":"51f83d31-9ec0-411d-bdc7-e5cfabb70a11","id_v1":"\/groups\/0","owner":{"rid":"6185e1ca-221a-4572-824c-b7402e106758","rtype":"bridge_home"},"on":{"on":true},"dimming":{"brightness":80.23666666666666},"dimming_delta":[],"color_temperature":[],"color_temperature_delta":[],"color":[],"alert":{"action_values":["breathe"]},"signaling":{"signal_values":["alternating","no_signal","on_off","on_off_color"]},"dynamics":[],"type":"grouped_light"}
0015|[2024-01-17 19:18:45] DEBUG : Found group light 5843ac02-8fad-438f-8fa5-cf43b18458e5 => {"id":"5843ac02-8fad-438f-8fa5-cf43b18458e5","id_v1":"\/groups\/4","owner":{"rid":"d61dd79f-fb26-41e9-8375-4f30617a5bdd","rtype":"room"},"on":{"on":false},"dimming":{"brightness":0},"dimming_delta":[],"color_temperature":[],"color_temperature_delta":[],"alert":{"action_values":["breathe"]},"signaling":{"signal_values":["no_signal","on_off"]},"dynamics":[],"type":"grouped_light"}
0016|[2024-01-17 19:18:45] DEBUG : Found group light 716b4037-ce76-43de-820f-e3d25752a0cc => {"id":"716b4037-ce76-43de-820f-e3d25752a0cc","id_v1":"\/groups\/15","owner":{"rid":"d067003c-3b80-4f83-a9b4-2360aac261a0","rtype":"zone"},"on":{"on":true},"dimming":{"brightness":80.23666666666666},"dimming_delta":[],"color_temperature":[],"color_temperature_delta":[],"color":[],"alert":{"action_values":["breathe"]},"signaling":{"signal_values":["alternating","no_signal","on_off","on_off_color"]},"dynamics":[],"type":"grouped_light"}
0017|[2024-01-17 19:18:45] DEBUG : Found group light ce3e1adb-179e-4e8f-bb5e-d48acfc289e8 => {"id":"ce3e1adb-179e-4e8f-bb5e-d48acfc289e8","id_v1":"\/groups\/1","owner":{"rid":"9b31d662-56e2-49d4-b373-ac33121f5dc4","rtype":"room"},"on":{"on":true},"dimming":{"brightness":100},"dimming_delta":[],"alert":{"action_values":["breathe"]},"signaling":{"signal_values":["no_signal","on_off"]},"dynamics":[],"type":"grouped_light"}
0018|[2024-01-17 19:18:51] DEBUG : Received message for bridge : 1 => {"creationtime":"2024-01-17T18:18:51Z","data":[{"id":"39d64cac-431d-4c79-9950-fce98945f696","name":"jeedom_b2j1p","type":"geofence_client"}],"id":"8c3b6de8-8861-4a02-a012-03fd70b45ec9","type":"update"}
0019|[2024-01-17 19:18:55] DEBUG : Received message for bridge : 1 => {"creationtime":"2024-01-17T18:18:55Z","data":[{"id":"f86ab2a8-6261-4df4-9e06-023a25698e34","id_v1":"\/sensors\/29","owner":{"rid":"4f93fc3a-fb9d-40a4-b7f7-deb5812d38d5","rtype":"device"},"temperature":{"temperature":21.06,"temperature_report":{"changed":"2024-01-17T18:18:55.352Z","temperature":21.06},"temperature_valid":true},"type":"temperature"}],"id":"30c190b8-b561-455f-b98d-010e0ade6ac2","type":"update"}
0020|[2024-01-17 19:19:12] DEBUG : Received message for bridge : 1 => {"creationtime":"2024-01-17T18:19:12Z","data":[{"id":"e112ccec-90c1-4f75-95e0-f1568be75e0e","id_v1":"\/sensors\/27","motion":{"motion":true,"motion_report":{"changed":"2024-01-17T18:19:11.834Z","motion":true},"motion_valid":true},"owner":{"rid":"4f93fc3a-fb9d-40a4-b7f7-deb5812d38d5","rtype":"device"},"type":"motion"}],"id":"69eb5ae6-736b-4e58-bf4d-24147d7c7922","type":"update"}
A disposition pour plus de renseignements et/ou de test