[2025-09-22 01:21:39] [68d08883bc327] [DEBUG] début chatgpt
[2025-09-22 01:21:39] [68d08883bc327] [DEBUG] curl_init OK
[2025-09-22 01:21:39] [68d08883bc327] [DEBUG] [CHAT GPT] Commun JsonMessage : {"model":"gpt-4-turbo-preview","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:43] [68d08883bc327] [DEBUG] Commun GPT response: {
  "id": "chatcmpl-CINfA8G8LOzoGLNU9Nvq7YMzWIyIH",
  "object": "chat.completion",
  "created": 1758496900,
  "model": "gpt-4-0125-preview",
  "choices": [
    {
      "index": 0,
      "message": {
        "role": "assistant",
        "content": "Parfait, merci pour cette information. Souhaitez-vous être conducteur ou passager pour vous rendre au Sommet de la Loutre ?",
        "refusal": null,
        "annotations": []
      },
      "logprobs": null,
      "finish_reason": "stop"
    }
  ],
  "usage": {
    "prompt_tokens": 363,
    "completion_tokens": 31,
    "total_tokens": 394,
    "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:43] [68d08883bc327] [DEBUG] Curl Closed OK
[2025-09-22 01:21:43] [68d08883bc327] [INFO] Commun GPT Content: {
  "id": "chatcmpl-CINfA8G8LOzoGLNU9Nvq7YMzWIyIH",
  "object": "chat.completion",
  "created": 1758496900,
  "model": "gpt-4-0125-preview",
  "choices": [
    {
      "index": 0,
      "message": {
        "role": "assistant",
        "content": "Parfait, merci pour cette information. Souhaitez-vous être conducteur ou passager pour vous rendre au Sommet de la Loutre ?",
        "refusal": null,
        "annotations": []
      },
      "logprobs": null,
      "finish_reason": "stop"
    }
  ],
  "usage": {
    "prompt_tokens": 363,
    "completion_tokens": 31,
    "total_tokens": 394,
    "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:20] [68d088e8d3b06] [DEBUG] Callback main start ok
[2025-09-22 01:23:20] [68d088e8d3b06] [INFO] Callback ****** Nouveau SMS recu: ********
[2025-09-22 01:23:20] [68d088e8d3b06] [DEBUG] Callback main avant while ok
[2025-09-22 01:23:20] [68d088e8d3b06] [DEBUG] Fields : 
[2025-09-22 01:23:20] [68d088e8d3b06] [INFO] Callback SMS entrant sur sim_card:  depuis Number (user): adm Text: **
[2025-09-22 01:23:20] [68d088e8d3b06] [INFO] From: adm|To: |Date: 01:23:20|Message: **
[2025-09-22 01:23:20] [68d088e8d3b06] [DEBUG] callback main apres while ok
[2025-09-22 01:23:20] [68d088e8d3b06] [DEBUG] Service is enabled ? true
[2025-09-22 01:23:20] [68d088e8d3b06] [INFO] Service  is enabled !
[2025-09-22 01:23:20] [68d088e8d3b06] [INFO] Phone Number adm is available !
[2025-09-22 01:23:20] [68d088e8d3b06] [DEBUG] Listen is enabled ? false
[2025-09-22 01:23:20] [68d088e8d3b06] [INFO] Listen  is disabled !
[2025-09-22 01:23:20] [68d088e8d3b06] [DEBUG] callback main sim_card_number CORRECT :  début d'interpretation du message
[2025-09-22 01:23:20] [68d088e8d3b06] [ERROR] BDD CheckNumber : une erreur est survenu : Unknown column 'adm' in 'where clause'
[2025-09-22 01:23:20] [68d088e8d3b06] [ERROR] BDD CheckSmsCount : une erreur est survenu : Unknown column 'adm' in 'where clause'
[2025-09-22 01:23:20] [68d088e8d3b06] [INFO] Callback SMS Count =?  
[2025-09-22 01:23:20] [68d088e8d3b06] [INFO] Callback checkLastMessage :  -- text: **
[2025-09-22 01:23:20] [68d088e8d3b06] [ERROR] BDD BddMaj : une erreur est survenu : Unknown column 'adm' in 'where clause'
[2025-09-22 01:26:34] [68d089aa4486e] [INFO] Ajout du sender : 33757050374 au +33789060090
[2025-09-22 01:26:34] [68d089aa4486e] [DEBUG] SMS sms1_sent_at : 0
[2025-09-22 01:26:34] [68d089aa4486e] [DEBUG] SMS day sms1_sent_at : 0
[2025-09-22 01:32:55] [68d08b278f243] [DEBUG] Callback main start ok
[2025-09-22 01:32:55] [68d08b278f243] [INFO] Callback ****** Nouveau SMS recu: ********
[2025-09-22 01:32:55] [68d08b278f243] [DEBUG] Callback main avant while ok
[2025-09-22 01:32:55] [68d08b278f243] [DEBUG] Fields : 
[2025-09-22 01:32:55] [68d08b278f243] [INFO] Callback SMS entrant sur sim_card:  depuis Number (user): adm Text: **
[2025-09-22 01:32:55] [68d08b278f243] [INFO] From: adm|To: |Date: 01:32:55|Message: **
[2025-09-22 01:32:55] [68d08b278f243] [DEBUG] callback main apres while ok
[2025-09-22 01:32:55] [68d08b278f243] [DEBUG] callback main sim_card_number n'est pas correct :  envoi vers fin de callback
[2025-09-22 01:32:55] [68d08b278f243] [DEBUG] Callback juste avant fin callBack
[2025-09-22 01:38:08] [68d08c6080113] [DEBUG] début chatgpt
[2025-09-22 01:38:08] [68d08c6080113] [DEBUG] curl_init OK
[2025-09-22 01:38:08] [68d08c6080113] [DEBUG] [CHAT GPT] Commun JsonMessage : {"model":"gpt-4-turbo-preview","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-22 01:38:12] [68d08c6080113] [DEBUG] Commun GPT response: {
  "id": "chatcmpl-CINv77cS4V7u3upAj9Gy8Zmv7CAqH",
  "object": "chat.completion",
  "created": 1758497889,
  "model": "gpt-4-0125-preview",
  "choices": [
    {
      "index": 0,
      "message": {
        "role": "assistant",
        "content": "```json\n{\n  \"nom_evenement\": \"#N/A\",\n  \"adresse_depart\": \"#N/A\",\n  \"heure_arrivee\": \"#N/A\",\n  \"adresse_retour\": \"#N/A\",\n  \"heure_retour\": \"#N/A\",\n  \"role\": \"#N/A\"\n}\n```",
        "refusal": null,
        "annotations": []
      },
      "logprobs": null,
      "finish_reason": "stop"
    }
  ],
  "usage": {
    "prompt_tokens": 196,
    "completion_tokens": 64,
    "total_tokens": 260,
    "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:38:12] [68d08c6080113] [DEBUG] Curl Closed OK
[2025-09-22 01:38:12] [68d08c6080113] [INFO] Commun GPT Content: {
  "id": "chatcmpl-CINv77cS4V7u3upAj9Gy8Zmv7CAqH",
  "object": "chat.completion",
  "created": 1758497889,
  "model": "gpt-4-0125-preview",
  "choices": [
    {
      "index": 0,
      "message": {
        "role": "assistant",
        "content": "```json\n{\n  \"nom_evenement\": \"#N/A\",\n  \"adresse_depart\": \"#N/A\",\n  \"heure_arrivee\": \"#N/A\",\n  \"adresse_retour\": \"#N/A\",\n  \"heure_retour\": \"#N/A\",\n  \"role\": \"#N/A\"\n}\n```",
        "refusal": null,
        "annotations": []
      },
      "logprobs": null,
      "finish_reason": "stop"
    }
  ],
  "usage": {
    "prompt_tokens": 196,
    "completion_tokens": 64,
    "total_tokens": 260,
    "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:38:12] [68d08c6080113] [DEBUG] début chatgpt
[2025-09-22 01:38:12] [68d08c6080113] [DEBUG] curl_init OK
[2025-09-22 01:38:12] [68d08c6080113] [DEBUG] [CHAT GPT] Commun JsonMessage : {"model":"gpt-4-turbo-preview","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-22 01:38:16] [68d08c6080113] [DEBUG] Commun GPT response: {
  "id": "chatcmpl-CINvBipowahaFLgbmRo3agfcpWdui",
  "object": "chat.completion",
  "created": 1758497893,
  "model": "gpt-4-0125-preview",
  "choices": [
    {
      "index": 0,
      "message": {
        "role": "assistant",
        "content": "{\n  \"nom_evenement\": \"#N/A\",\n  \"adresse_depart\": \"#N/A\",\n  \"heure_arrivee\": \"#N/A\",\n  \"adresse_retour\": \"#N/A\",\n  \"heure_retour\": \"#N/A\",\n  \"role\": \"#N/A\"\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-22 01:38:16] [68d08c6080113] [DEBUG] Curl Closed OK
[2025-09-22 01:38:16] [68d08c6080113] [INFO] Commun GPT Content: {
  "id": "chatcmpl-CINvBipowahaFLgbmRo3agfcpWdui",
  "object": "chat.completion",
  "created": 1758497893,
  "model": "gpt-4-0125-preview",
  "choices": [
    {
      "index": 0,
      "message": {
        "role": "assistant",
        "content": "{\n  \"nom_evenement\": \"#N/A\",\n  \"adresse_depart\": \"#N/A\",\n  \"heure_arrivee\": \"#N/A\",\n  \"adresse_retour\": \"#N/A\",\n  \"heure_retour\": \"#N/A\",\n  \"role\": \"#N/A\"\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-22 01:38:16] [68d08c6080113] [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-22 01:38:16] [68d08c6080113] [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-22 01:38:16] [68d08c6080113] [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-22 01:38:16] [68d08c6080113] [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-22 01:38:16] [68d08c6080113] [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-22 01:38:16] [68d08c6080113] [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