[2025-09-27 01:45:10] [68d72586098c7] [DEBUG] début chatgpt
[2025-09-27 01:45:10] [68d72586098c7] [DEBUG] curl_init OK
[2025-09-27 01:45:10] [68d72586098c7] [INFO] [CHAT GPT] Commun message : Array
[2025-09-27 01:45:10] [68d72586098c7] [DEBUG] [CHAT GPT] Commun JsonMessage : {"model":"gpt-3.5-turbo","messages":[{"role":"system","content":"Tu es un assistant qui essai d'organiser un covoiturage, nous nous parlons uniquement par SMS"},{"role":"assistant","content":""},{"role":"user","content":""},{"role":"assistant","content":""},{"role":"user","content":""},{"role":"assistant","content":""},{"role":"user","content":""},{"role":"assistant","content":""},{"role":"user","content":""},{"role":"assistant","content":""},{"role":"user","content":""},{"role":"user","content":"S'il te plait \u00e9crit moi les informations pr\u00e9sente dans cette conversation en JSON avec le format suivant: {  \"nom_evenement\": nom de l'\u00e9v\u00e8nement, \"adresse_depart\": adresse d\u00e9part, \"heure_arrivee\": heure arriv\u00e9e , \"adresse_retour\": adresse retour, \"heure_retour\": heure retour , \"role\": conducteur ou passager}.Si l'information n'est pas pr\u00e9sente, indique #NANA pour chaque attribut. Ta r\u00e9ponse ne contient que le code json sans aucun commentaire,analyse ou interpr\u00e9tation."}]}
[2025-09-27 01:45:11] [68d72586098c7] [DEBUG] Commun GPT response: {
  "id": "chatcmpl-CKCPf0gfsvtswwoomFvLLmGwv4gRD",
  "object": "chat.completion",
  "created": 1758930311,
  "model": "gpt-3.5-turbo-0125",
  "choices": [
    {
      "index": 0,
      "message": {
        "role": "assistant",
        "content": "{\n  \"nom_evenement\": \"#NANA\",\n  \"adresse_depart\": \"#NANA\",\n  \"heure_arrivee\": \"#NANA\",\n  \"adresse_retour\": \"#NANA\",\n  \"heure_retour\": \"#NANA\",\n  \"role\": \"#NANA\"\n}",
        "refusal": null,
        "annotations": []
      },
      "logprobs": null,
      "finish_reason": "stop"
    }
  ],
  "usage": {
    "prompt_tokens": 196,
    "completion_tokens": 60,
    "total_tokens": 256,
    "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-27 01:45:11] [68d72586098c7] [DEBUG] Curl Closed OK
[2025-09-27 01:45:11] [68d72586098c7] [INFO] Commun GPT Content: {
  "id": "chatcmpl-CKCPf0gfsvtswwoomFvLLmGwv4gRD",
  "object": "chat.completion",
  "created": 1758930311,
  "model": "gpt-3.5-turbo-0125",
  "choices": [
    {
      "index": 0,
      "message": {
        "role": "assistant",
        "content": "{\n  \"nom_evenement\": \"#NANA\",\n  \"adresse_depart\": \"#NANA\",\n  \"heure_arrivee\": \"#NANA\",\n  \"adresse_retour\": \"#NANA\",\n  \"heure_retour\": \"#NANA\",\n  \"role\": \"#NANA\"\n}",
        "refusal": null,
        "annotations": []
      },
      "logprobs": null,
      "finish_reason": "stop"
    }
  ],
  "usage": {
    "prompt_tokens": 196,
    "completion_tokens": 60,
    "total_tokens": 256,
    "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-27 01:45:11] [68d72586098c7] [ERROR] BDD BddMaj : une erreur est survenu : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[2025-09-27 01:45:11] [68d72586098c7] [ERROR] BDD BddMaj : une erreur est survenu : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[2025-09-27 01:45:11] [68d72586098c7] [ERROR] BDD BddMaj : une erreur est survenu : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[2025-09-27 01:45:11] [68d72586098c7] [ERROR] BDD BddMaj : une erreur est survenu : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[2025-09-27 01:45:11] [68d72586098c7] [ERROR] BDD BddMaj : une erreur est survenu : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[2025-09-27 01:45:11] [68d72586098c7] [ERROR] BDD BddMaj : une erreur est survenu : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[2025-09-27 01:45:11] [68d72586098c7] [DEBUG] début chatgpt
[2025-09-27 01:45:11] [68d72586098c7] [DEBUG] curl_init OK
[2025-09-27 01:45:11] [68d72586098c7] [INFO] [CHAT GPT] Commun message : Array
[2025-09-27 01:45:11] [68d72586098c7] [DEBUG] [CHAT GPT] Commun JsonMessage : {"model":"gpt-3.5-turbo","messages":[{"role":"system","content":"Tu es un assistant qui essai d'organiser un covoiturage, nous nous parlons uniquement par SMS"},{"role":"assistant","content":""},{"role":"user","content":""},{"role":"assistant","content":""},{"role":"user","content":""},{"role":"assistant","content":""},{"role":"user","content":""},{"role":"assistant","content":""},{"role":"user","content":""},{"role":"assistant","content":""},{"role":"user","content":""},{"role":"user","content":"S'il te plait \u00e9crit moi les informations pr\u00e9sente dans cette conversation en JSON avec le format suivant: {  \"nom_evenement\": nom de l'\u00e9v\u00e8nement, \"adresse_depart\": adresse d\u00e9part, \"heure_arrivee\": heure arriv\u00e9e , \"adresse_retour\": adresse retour, \"heure_retour\": heure retour , \"role\": conducteur ou passager}.Si l'information n'est pas pr\u00e9sente, indique #NANA pour chaque attribut. Ta r\u00e9ponse ne contient que le code json sans aucun commentaire,analyse ou interpr\u00e9tation."}]}
[2025-09-27 01:45:12] [68d72586098c7] [DEBUG] Commun GPT response: {
  "id": "chatcmpl-CKCPg0TvTm6LF4C09YZYfOTZu2nop",
  "object": "chat.completion",
  "created": 1758930312,
  "model": "gpt-3.5-turbo-0125",
  "choices": [
    {
      "index": 0,
      "message": {
        "role": "assistant",
        "content": "{\n  \"nom_evenement\": \"#NANA\",\n  \"adresse_depart\": \"#NANA\",\n  \"heure_arrivee\": \"#NANA\",\n  \"adresse_retour\": \"#NANA\",\n  \"heure_retour\": \"#NANA\",\n  \"role\": \"#NANA\"\n}",
        "refusal": null,
        "annotations": []
      },
      "logprobs": null,
      "finish_reason": "stop"
    }
  ],
  "usage": {
    "prompt_tokens": 196,
    "completion_tokens": 60,
    "total_tokens": 256,
    "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-27 01:45:12] [68d72586098c7] [DEBUG] Curl Closed OK
[2025-09-27 01:45:12] [68d72586098c7] [INFO] Commun GPT Content: {
  "id": "chatcmpl-CKCPg0TvTm6LF4C09YZYfOTZu2nop",
  "object": "chat.completion",
  "created": 1758930312,
  "model": "gpt-3.5-turbo-0125",
  "choices": [
    {
      "index": 0,
      "message": {
        "role": "assistant",
        "content": "{\n  \"nom_evenement\": \"#NANA\",\n  \"adresse_depart\": \"#NANA\",\n  \"heure_arrivee\": \"#NANA\",\n  \"adresse_retour\": \"#NANA\",\n  \"heure_retour\": \"#NANA\",\n  \"role\": \"#NANA\"\n}",
        "refusal": null,
        "annotations": []
      },
      "logprobs": null,
      "finish_reason": "stop"
    }
  ],
  "usage": {
    "prompt_tokens": 196,
    "completion_tokens": 60,
    "total_tokens": 256,
    "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-27 01:45:12] [68d72586098c7] [ERROR] BDD BddMaj : une erreur est survenu : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[2025-09-27 01:45:12] [68d72586098c7] [ERROR] BDD BddMaj : une erreur est survenu : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[2025-09-27 01:45:12] [68d72586098c7] [ERROR] BDD BddMaj : une erreur est survenu : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[2025-09-27 01:45:12] [68d72586098c7] [ERROR] BDD BddMaj : une erreur est survenu : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[2025-09-27 01:45:12] [68d72586098c7] [ERROR] BDD BddMaj : une erreur est survenu : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[2025-09-27 01:45:12] [68d72586098c7] [ERROR] BDD BddMaj : une erreur est survenu : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[2025-09-27 01:45:18] [68d7258e015a9] [DEBUG] Callback main start ok
[2025-09-27 01:45:18] [68d7258e015a9] [INFO] Callback ****** Nouveau SMS recu: ********
[2025-09-27 01:45:18] [68d7258e015a9] [DEBUG] Callback main avant while ok
[2025-09-27 01:45:18] [68d7258e015a9] [DEBUG] Fields : 
[2025-09-27 01:45:18] [68d7258e015a9] [INFO] Callback SMS entrant sur sim_card:  depuis Number (user): adm Text: **
[2025-09-27 01:45:18] [68d7258e015a9] [INFO] From: adm|To: |Date: 01:45:18|Message: **
[2025-09-27 01:45:18] [68d7258e015a9] [DEBUG] callback main apres while ok
[2025-09-27 01:45:18] [68d7258e015a9] [DEBUG] callback main sim_card_number n'est pas correct :  envoi vers fin de callback
[2025-09-27 01:45:18] [68d7258e015a9] [DEBUG] Callback juste avant fin callBack
[2025-09-27 02:09:30] [68d72b3ad018a] [DEBUG] Callback main start ok
[2025-09-27 02:09:30] [68d72b3ad018a] [INFO] Callback ****** Nouveau SMS recu: ********
[2025-09-27 02:09:30] [68d72b3ad018a] [DEBUG] Callback main avant while ok
[2025-09-27 02:09:30] [68d72b3ad018a] [DEBUG] Fields : 
[2025-09-27 02:09:30] [68d72b3ad018a] [INFO] Callback SMS entrant sur sim_card:  depuis Number (user): adm Text: **
[2025-09-27 02:09:30] [68d72b3ad018a] [INFO] From: adm|To: |Date: 02:09:30|Message: **
[2025-09-27 02:09:30] [68d72b3ad018a] [DEBUG] callback main apres while ok
[2025-09-27 02:09:30] [68d72b3ad018a] [DEBUG] callback main sim_card_number n'est pas correct :  envoi vers fin de callback
[2025-09-27 02:09:30] [68d72b3ad018a] [DEBUG] Callback juste avant fin callBack