[2026-01-06 05:59:07] === DEBUT DU SCRIPT ===
[2026-01-06 05:59:07] PHP Version: 5.6.40
[2026-01-06 05:59:07] Current directory: /home/fcefrancxd/www/scratch/fce-mysql
[2026-01-06 05:59:07] Script file: /home/fcefrancxd/www/scratch/fce-mysql/import_debug.php
[2026-01-06 05:59:07] Test 1: Chargement config.php...
[2026-01-06 05:59:07] OK: config.php trouvé
[2026-01-06 05:59:07] OK: config.php chargé
[2026-01-06 05:59:07] Database host: fcefrancxdck867a.mysql.db
[2026-01-06 05:59:07] Database name: fcefrancxdck867a
[2026-01-06 05:59:07] Test 2: Vérification extensions PHP...
[2026-01-06 05:59:07] Extensions chargées: 68
[2026-01-06 05:59:07] PDO disponible: OUI
[2026-01-06 05:59:07] PDO MySQL disponible: OUI
[2026-01-06 05:59:07] JSON disponible: OUI
[2026-01-06 05:59:07] Test 3: Vérification fichier JSON...
[2026-01-06 05:59:07] Chemin JSON: /home/fcefrancxd/www/scratch/fce-mysql/last_5_users.json
[2026-01-06 05:59:07] OK: Fichier JSON trouvé (14,496 octets)
[2026-01-06 05:59:07] Test 4: Lecture du JSON...
[2026-01-06 05:59:07] OK: Contenu lu (14496 caractères)
[2026-01-06 05:59:07] OK: JSON décodé
[2026-01-06 05:59:07] Nombre d'utilisateurs: 5
[2026-01-06 05:59:07] Premier utilisateur: cmichud@enjeu-management.fr
[2026-01-06 05:59:07] Test 5: Connexion à la base de données...
[2026-01-06 05:59:07] DSN: mysql:host=fcefrancxdck867a.mysql.db;port=3306;dbname=fcefrancxdck867a;charset=utf8mb4
[2026-01-06 05:59:07] OK: Connexion PDO établie
[2026-01-06 05:59:07] OK: Test query réussi (result: 1)
[2026-01-06 05:59:07] OK: Table 'user' existe
[2026-01-06 05:59:07] Utilisateurs existants: 6365
[2026-01-06 05:59:07] Test 6: Vérification permissions...
[2026-01-06 05:59:07] Fichier erreur: /home/fcefrancxd/www/scratch/fce-mysql/import_errors.log
[2026-01-06 05:59:07] Writable: OUI
[2026-01-06 05:59:07] Fichier mapping: /home/fcefrancxd/www/scratch/fce-mysql/user_id_mapping.json
[2026-01-06 05:59:07] Writable: OUI
[2026-01-06 05:59:07] OK: Ecriture dans error_log réussie
[2026-01-06 05:59:07] === RESUME DES TESTS ===
[2026-01-06 05:59:07] Tous les tests de base ont réussi !
[2026-01-06 05:59:07] Le script d'import devrait fonctionner.
[2026-01-06 05:59:07] 
[2026-01-06 05:59:07] Pour lancer l'import complet, exécutez:
[2026-01-06 05:59:07]   php import_users_from_json_php56.php
[2026-01-06 05:59:07] 
[2026-01-06 05:59:07] Logs sauvegardés dans: /home/fcefrancxd/www/scratch/fce-mysql/debug_import.log
[2026-01-06 05:59:07] === FIN DU SCRIPT ===
[2026-01-06 09:00:38] [DEBUG] Loading configuration from config.php
[2026-01-06 09:00:38] [DEBUG] Configuration loaded successfully
[2026-01-06 09:00:38] [DEBUG] Database host: fcefrancxdck867a.mysql.db:3306
[2026-01-06 09:00:38] [DEBUG] Database name: fcefrancxdck867a
[2026-01-06 09:00:38] [DEBUG] Database user: fcefrancxdck867a
[2026-01-06 09:00:38] [DEBUG] Input file: /home/fcefrancxd/www/scratch/fce-mysql/last_5_users.json
[2026-01-06 09:00:38] [DEBUG] Batch size: 100
[2026-01-06 09:00:38] [DEBUG] Skip duplicates: Yes
[2026-01-06 09:00:38] [DEBUG] Verbose mode: Yes
[2026-01-06 09:00:38] [DEBUG] PHP Version: 5.6.40
[2026-01-06 09:00:38] [DEBUG] Script start time: 2026-01-06 09:00:38
[2026-01-06 09:00:38] [DEBUG] Building DSN connection string
[2026-01-06 09:00:38] [DEBUG] DSN: mysql:host=fcefrancxdck867a.mysql.db;port=3306;dbname=fcefrancxdck867a;charset=utf8mb4
[2026-01-06 09:00:38] [DEBUG] Attempting PDO connection...
[2026-01-06 09:00:38] [DEBUG] PDO connection established successfully
[2026-01-06 09:00:38] [DEBUG] Setting charset to utf8mb4
[2026-01-06 09:00:38] [DEBUG] Charset set successfully
[2026-01-06 09:00:38] [DEBUG] Checking if JSON file exists...
[2026-01-06 09:00:38] [DEBUG] JSON file found
[2026-01-06 09:00:38] [DEBUG] Reading JSON file contents...
[2026-01-06 09:00:38] [DEBUG] JSON file size: 14,496 bytes
[2026-01-06 09:00:38] [DEBUG] First 100 chars: [
    {
        "_id": {
            "$oid": "69450f4dc09888be664550b3"
        },
        "fce
[2026-01-06 09:00:38] [DEBUG] Decoding JSON...
[2026-01-06 09:00:38] [DEBUG] JSON decoded
[2026-01-06 09:00:38] [DEBUG] JSON is valid
[2026-01-06 09:00:38] [DEBUG] Total users parsed: 5
[2026-01-06 09:00:38] [DEBUG] First user email: cmichud@enjeu-management.fr
[2026-01-06 09:00:38] [DEBUG] Preparing INSERT statement...
[2026-01-06 09:00:38] [DEBUG] Preparing PDO statement...
[2026-01-06 09:00:38] [DEBUG] INSERT statement prepared successfully
[2026-01-06 09:00:38] [DEBUG] Preparing duplicate check statement...
[2026-01-06 09:00:38] [DEBUG] Duplicate check statement prepared
[2026-01-06 09:00:38] [DEBUG] Starting user processing loop
[2026-01-06 09:00:38] [DEBUG] Beginning database transaction
[2026-01-06 09:00:38] [DEBUG] Transaction started
[2026-01-06 09:00:38] [DEBUG] Processing user 1/5
[2026-01-06 09:00:38] [DEBUG] User email: cmichud@enjeu-management.fr
[2026-01-06 09:00:38] [DEBUG] Checking if user exists: cmichud@enjeu-management.fr
[2026-01-06 09:00:38] [DEBUG] User exists: No
[2026-01-06 09:00:38] [DEBUG] Mapping MongoDB data to MySQL fields
[2026-01-06 09:00:38] [DEBUG] Data mapped, inserting user...
[2026-01-06 09:00:38] [DEBUG] User inserted successfully with ID: 7072
[2026-01-06 09:00:38] [DEBUG] Processing user 2/5
[2026-01-06 09:00:38] [DEBUG] User email: c.dissay@gmail.com
[2026-01-06 09:00:38] [DEBUG] Checking if user exists: c.dissay@gmail.com
[2026-01-06 09:00:38] [DEBUG] User exists: No
[2026-01-06 09:00:38] [DEBUG] Mapping MongoDB data to MySQL fields
[2026-01-06 09:00:38] [DEBUG] Data mapped, inserting user...
[2026-01-06 09:00:38] [DEBUG] User inserted successfully with ID: 7073
[2026-01-06 09:00:38] [DEBUG] Processing user 3/5
[2026-01-06 09:00:38] [DEBUG] User email: jorrandsonia@gmail.com
[2026-01-06 09:00:38] [DEBUG] Checking if user exists: jorrandsonia@gmail.com
[2026-01-06 09:00:38] [DEBUG] User exists: No
[2026-01-06 09:00:38] [DEBUG] Mapping MongoDB data to MySQL fields
[2026-01-06 09:00:38] [DEBUG] Data mapped, inserting user...
[2026-01-06 09:00:38] [DEBUG] User inserted successfully with ID: 7074
[2026-01-06 09:00:38] [DEBUG] Processing user 4/5
[2026-01-06 09:00:38] [DEBUG] User email: galloischloe@gmail.com
[2026-01-06 09:00:38] [DEBUG] Checking if user exists: galloischloe@gmail.com
[2026-01-06 09:00:38] [DEBUG] User exists: No
[2026-01-06 09:00:38] [DEBUG] Mapping MongoDB data to MySQL fields
[2026-01-06 09:00:38] [DEBUG] Data mapped, inserting user...
[2026-01-06 09:00:38] [DEBUG] User inserted successfully with ID: 7075
[2026-01-06 09:00:38] [DEBUG] Processing user 5/5
[2026-01-06 09:00:38] [DEBUG] User email: karine.cazalot@gmail.com
[2026-01-06 09:00:38] [DEBUG] Checking if user exists: karine.cazalot@gmail.com
[2026-01-06 09:00:38] [DEBUG] User exists: No
[2026-01-06 09:00:38] [DEBUG] Mapping MongoDB data to MySQL fields
[2026-01-06 09:00:38] [DEBUG] Data mapped, inserting user...
[2026-01-06 09:00:38] [DEBUG] User inserted successfully with ID: 7076
[2026-01-06 09:00:38] [DEBUG] Processing complete, committing final batch
[2026-01-06 09:00:38] [DEBUG] Committing final 5 users
[2026-01-06 09:00:38] [DEBUG] Final commit successful
[2026-01-06 09:00:38] [DEBUG] ID mapping contains 5 entries
[2026-01-06 09:00:38] [DEBUG] Mapping file: /home/fcefrancxd/www/scratch/fce-mysql/user_id_mapping.json
[2026-01-06 09:00:38] [DEBUG] JSON mapping size: 960 bytes
[2026-01-06 09:00:38] [DEBUG] ID mapping saved successfully (960 bytes written)
[2026-01-06 09:00:38] [DEBUG] Import process completed
[2026-01-06 09:00:38] [DEBUG] Total duration: 0.08 seconds
[2026-01-06 09:00:38] [DEBUG] Average time per user: 0.016 seconds
[2026-01-06 09:00:38] [DEBUG] Import completed successfully with no errors