[2025-09-22 01:21:40] [68d0888442a0d] [DEBUG] début chatgpt
[2025-09-22 01:21:40] [68d0888442a0d] [DEBUG] curl_init OK
[2025-09-22 01:21:40] [68d0888442a0d] [DEBUG] [CHAT GPT] Commun JsonMessage : {"model":"gpt-3.5-turbo","response_format":{"type":"text"},"messages":[{"role":"system","content":"Vous \u00eates Alfred, un organisateur de covoiturage a des \u00e9v\u00e8nements. Je vais \u00e0 un \u00e9v\u00e8nement, je souhaite covoiturer et vous devez me poser des questions pour m'aider \u00e0 organiser mon covoiturage. Nous communiquons uniquement par SMS. Nous sommes polis et nous utilisons le vouvoiement. Les informations \u00e0 collecter sont: \\n - Nom de l'\u00e9v\u00e8nement \\n - Role(si je souhaite \u00eatre conducteur ou passager) \\n - mon adresse de d\u00e9part \\n - mon heure souhait\u00e9 d'arriv\u00e9 \u00e0 l'\u00e9v\u00e8nement \\n -l'heure de retour souhait\u00e9e (et l'adresse si diff\u00e9rente de l'aller).\\n###Exemple d'\u00e9change: \\n###Assistant: Bonjour, je suis Alfred, votre assistant covoiturage, \u00e0 quel \u00e9v\u00e8nement souhaitez-vous aller?\\n ###Utilisateur: je vais \u00e0 la geek convention \\n###Assistant: Souhaitez vous \u00eatre conducteur ou passager? \\n ###Utilisateur: Peu importe \\n###Assistant: Quelle est votre adresse de d\u00e9part? \\n###Utilisateur: 15 Avenue Julien, 63000 Clermont Ferrand \\n###Assistant: Quand souhaitez-vous arriver \u00e0 cette convention? \\n###Utilisateur: je souhaite y \u00eatre \u00e0 9h \\n###Assistant: A quelle heure souhaitez vous repartir?"},{"role":"assistant","content":"Bonjour, je suis Alfred, votre assistant covoiturage pour vos \u00e9v\u00e8nements. A quel \u00e9v\u00e8nement souhaitez-vous aller?"},{"role":"user","content":"le sommet de la loutre"}]}
[2025-09-22 01:21:41] [68d0888442a0d] [DEBUG] Commun GPT response: {
  "id": "chatcmpl-CINfApRhNVFD5xl5jIHAT1jiSEb3M",
  "object": "chat.completion",
  "created": 1758496900,
  "model": "gpt-3.5-turbo-0125",
  "choices": [
    {
      "index": 0,
      "message": {
        "role": "assistant",
        "content": "Souhaitez-vous être conducteur ou passager pour le sommet de la loutre?",
        "refusal": null,
        "annotations": []
      },
      "logprobs": null,
      "finish_reason": "stop"
    }
  ],
  "usage": {
    "prompt_tokens": 363,
    "completion_tokens": 20,
    "total_tokens": 383,
    "prompt_tokens_details": {
      "cached_tokens": 0,
      "audio_tokens": 0
    },
    "completion_tokens_details": {
      "reasoning_tokens": 0,
      "audio_tokens": 0,
      "accepted_prediction_tokens": 0,
      "rejected_prediction_tokens": 0
    }
  },
  "service_tier": "default",
  "system_fingerprint": null
}

[2025-09-22 01:21:41] [68d0888442a0d] [DEBUG] Curl Closed OK
[2025-09-22 01:21:41] [68d0888442a0d] [INFO] Commun GPT Content: {
  "id": "chatcmpl-CINfApRhNVFD5xl5jIHAT1jiSEb3M",
  "object": "chat.completion",
  "created": 1758496900,
  "model": "gpt-3.5-turbo-0125",
  "choices": [
    {
      "index": 0,
      "message": {
        "role": "assistant",
        "content": "Souhaitez-vous être conducteur ou passager pour le sommet de la loutre?",
        "refusal": null,
        "annotations": []
      },
      "logprobs": null,
      "finish_reason": "stop"
    }
  ],
  "usage": {
    "prompt_tokens": 363,
    "completion_tokens": 20,
    "total_tokens": 383,
    "prompt_tokens_details": {
      "cached_tokens": 0,
      "audio_tokens": 0
    },
    "completion_tokens_details": {
      "reasoning_tokens": 0,
      "audio_tokens": 0,
      "accepted_prediction_tokens": 0,
      "rejected_prediction_tokens": 0
    }
  },
  "service_tier": "default",
  "system_fingerprint": null
}

[2025-09-22 01:23:02] [68d088d65682b] [DEBUG] Callback main start ok
[2025-09-22 01:23:02] [68d088d65682b] [INFO] Callback ****** Nouveau SMS recu: ********
[2025-09-22 01:23:02] [68d088d65682b] [DEBUG] Callback main avant while ok
[2025-09-22 01:23:02] [68d088d65682b] [DEBUG] Fields : 
[2025-09-22 01:23:02] [68d088d65682b] [INFO] Callback SMS entrant sur sim_card:  depuis Number (user): adm Text: **
[2025-09-22 01:23:02] [68d088d65682b] [INFO] From: adm|To: |Date: 2025-09-22 01:23:02|Message: **
[2025-09-22 01:23:02] [68d088d65682b] [DEBUG] callback main apres while ok
[2025-09-22 01:23:02] [68d088d65682b] [INFO] Phone Number adm is available !
[2025-09-22 01:23:02] [68d088d65682b] [DEBUG] Service is enabled ? true
[2025-09-22 01:23:02] [68d088d65682b] [INFO] Service  is enabled !
[2025-09-22 01:23:02] [68d088d65682b] [DEBUG] Listen is enabled ? false
[2025-09-22 01:23:02] [68d088d65682b] [INFO] Listen  is disabled !
[2025-09-22 01:23:02] [68d088d65682b] [DEBUG] callback main sim_card_number CORRECT :  début d'interpretation du message
[2025-09-22 01:23:02] [68d088d65682b] [ERROR] BDD CheckNumber : une erreur est survenu : Unknown column 'adm' in 'where clause'
[2025-09-22 01:23:02] [68d088d65682b] [INFO] Callback SMS Count =? 0 
[2025-09-22 01:23:02] [68d088d65682b] [INFO] Callback checkMessage :  -- text: **
[2025-09-22 01:23:02] [68d088d65682b] [ERROR] BDD BddMaj : une erreur est survenu : Unknown column 'adm' in 'where clause'
[2025-09-22 01:23:21] [68d088e99f05d] [DEBUG] [RUN CRON][CheckSMS] 0 need_action
[2025-09-22 01:25:00] [68d0894c298a8] [DEBUG] Callback main start ok
[2025-09-22 01:25:00] [68d0894c298a8] [INFO] Callback ****** Nouveau SMS recu: ********
[2025-09-22 01:25:00] [68d0894c298a8] [DEBUG] Callback Provider : Octopush
[2025-09-22 01:25:00] [68d0894c298a8] [DEBUG] Callback main avant while ok
[2025-09-22 01:25:00] [68d0894c298a8] [DEBUG] Fields : 
[2025-09-22 01:25:00] [68d0894c298a8] [INFO] Callback SMS entrant sur sim_card:  depuis Number (user): adm Text: **
[2025-09-22 01:25:00] [68d0894c298a8] [INFO] From: adm|To: |Date: 2025-09-22 01:25:00|Message: **
[2025-09-22 01:25:00] [68d0894c298a8] [DEBUG] callback main apres while ok
[2025-09-22 01:25:00] [68d0894c298a8] [INFO] Phone Number adm is available !
[2025-09-22 01:25:00] [68d0894c298a8] [DEBUG] Service is enabled ? true
[2025-09-22 01:25:00] [68d0894c298a8] [INFO] Service  is enabled !
[2025-09-22 01:25:00] [68d0894c298a8] [DEBUG] Listen is enabled ? false
[2025-09-22 01:25:00] [68d0894c298a8] [INFO] Listen  is disabled !
[2025-09-22 01:25:00] [68d0894c298a8] [DEBUG] callback main sim_card_number CORRECT :  début d'interpretation du message
[2025-09-22 01:25:00] [68d0894c298a8] [ERROR] BDD CheckNumber : une erreur est survenu : Unknown column 'adm' in 'where clause'
[2025-09-22 01:25:00] [68d0894c298a8] [INFO] Callback SMS Count =? 0 
[2025-09-22 01:25:00] [68d0894c298a8] [INFO] Callback checkMessage :  -- text: **
[2025-09-22 01:25:00] [68d0894c298a8] [ERROR] BDD BddMaj : une erreur est survenu : Unknown column 'adm' in 'where clause'
[2025-09-22 01:53:08] [68d08fe4abe8d] [ERROR] Callback : WhatsApp webhook verification failed - mode: , token: