[2026-01-11 10:42:10] [DEBUG] Loading configuration from config.php
[2026-01-11 10:42:10] [DEBUG] Configuration loaded successfully
[2026-01-11 10:42:10] [DEBUG] Database host: fcefrancxdck867a.mysql.db:3306
[2026-01-11 10:42:10] [DEBUG] Database name: fcefrancxdck867a
[2026-01-11 10:42:10] [DEBUG] Database user: fcefrancxdck867a
[2026-01-11 10:42:10] [DEBUG] Input file: /home/fcefrancxd/www/scratch/fce-mysql/last_5_users.json
[2026-01-11 10:42:10] [DEBUG] Batch size: 100
[2026-01-11 10:42:10] [DEBUG] Skip duplicates: Yes
[2026-01-11 10:42:10] [DEBUG] Verbose mode: Yes
[2026-01-11 10:42:10] [DEBUG] PHP Version: 5.6.40
[2026-01-11 10:42:10] [DEBUG] Script start time: 2026-01-11 10:42:10

=== MongoDB to MySQL User Import ===

Connecting to database...
[2026-01-11 10:42:10] [DEBUG] Building DSN connection string
[2026-01-11 10:42:10] [DEBUG] DSN: mysql:host=fcefrancxdck867a.mysql.db;port=3306;dbname=fcefrancxdck867a;charset=utf8mb4
[2026-01-11 10:42:10] [DEBUG] Attempting PDO connection...
[2026-01-11 10:42:10] [DEBUG] PDO connection established successfully
[2026-01-11 10:42:10] [DEBUG] Setting charset to utf8mb4
[2026-01-11 10:42:10] [DEBUG] Charset set successfully
[OK] Connected to database

Reading JSON file: /home/fcefrancxd/www/scratch/fce-mysql/last_5_users.json
[2026-01-11 10:42:10] [DEBUG] Checking if JSON file exists...
[2026-01-11 10:42:10] [DEBUG] JSON file found
[2026-01-11 10:42:10] [DEBUG] Reading JSON file contents...
[2026-01-11 10:42:10] [DEBUG] JSON file size: 14,496 bytes
[2026-01-11 10:42:10] [DEBUG] First 100 chars: [
    {
        "_id": {
            "$oid": "69450f4dc09888be664550b3"
        },
        "fce
[2026-01-11 10:42:10] [DEBUG] Decoding JSON...
[2026-01-11 10:42:10] [DEBUG] JSON decoded
[2026-01-11 10:42:10] [DEBUG] JSON is valid
[2026-01-11 10:42:10] [DEBUG] Total users parsed: 5
[2026-01-11 10:42:10] [DEBUG] First user email: cmichud@enjeu-management.fr
[OK] Loaded 5 users from JSON

[2026-01-11 10:42:10] [DEBUG] Preparing INSERT statement...
[2026-01-11 10:42:10] [DEBUG] Preparing PDO statement...
[2026-01-11 10:42:10] [DEBUG] INSERT statement prepared successfully
[2026-01-11 10:42:10] [DEBUG] Preparing duplicate check statement...
[2026-01-11 10:42:10] [DEBUG] Duplicate check statement prepared
Processing users...
[2026-01-11 10:42:10] [DEBUG] Starting user processing loop
[2026-01-11 10:42:10] [DEBUG] Beginning database transaction
[2026-01-11 10:42:10] [DEBUG] Transaction started
[2026-01-11 10:42:10] [DEBUG] Processing user 1/5
[2026-01-11 10:42:10] [DEBUG] User email: cmichud@enjeu-management.fr
[2026-01-11 10:42:10] [DEBUG] Checking if user exists: cmichud@enjeu-management.fr
[2026-01-11 10:42:10] [DEBUG] User exists: Yes (ID: 7072)
  [SKIP] Skipped (exists): cmichud@enjeu-management.fr
[2026-01-11 10:42:10] [DEBUG] Processing user 2/5
[2026-01-11 10:42:10] [DEBUG] User email: c.dissay@gmail.com
[2026-01-11 10:42:10] [DEBUG] Checking if user exists: c.dissay@gmail.com
[2026-01-11 10:42:10] [DEBUG] User exists: Yes (ID: 7073)
  [SKIP] Skipped (exists): c.dissay@gmail.com
[2026-01-11 10:42:10] [DEBUG] Processing user 3/5
[2026-01-11 10:42:10] [DEBUG] User email: jorrandsonia@gmail.com
[2026-01-11 10:42:10] [DEBUG] Checking if user exists: jorrandsonia@gmail.com
[2026-01-11 10:42:10] [DEBUG] User exists: Yes (ID: 7074)
  [SKIP] Skipped (exists): jorrandsonia@gmail.com
[2026-01-11 10:42:10] [DEBUG] Processing user 4/5
[2026-01-11 10:42:10] [DEBUG] User email: galloischloe@gmail.com
[2026-01-11 10:42:10] [DEBUG] Checking if user exists: galloischloe@gmail.com
[2026-01-11 10:42:10] [DEBUG] User exists: Yes (ID: 7075)
  [SKIP] Skipped (exists): galloischloe@gmail.com
[2026-01-11 10:42:10] [DEBUG] Processing user 5/5
[2026-01-11 10:42:10] [DEBUG] User email: karine.cazalot@gmail.com
[2026-01-11 10:42:10] [DEBUG] Checking if user exists: karine.cazalot@gmail.com
[2026-01-11 10:42:10] [DEBUG] User exists: Yes (ID: 7076)
  [SKIP] Skipped (exists): karine.cazalot@gmail.com
[2026-01-11 10:42:10] [DEBUG] Processing complete, committing final batch
[2026-01-11 10:42:10] [DEBUG] No pending users to commit

Saving ID mapping...
[2026-01-11 10:42:10] [DEBUG] ID mapping contains 5 entries
[2026-01-11 10:42:10] [DEBUG] Mapping file: /home/fcefrancxd/www/scratch/fce-mysql/user_id_mapping.json
[2026-01-11 10:42:10] [DEBUG] JSON mapping size: 950 bytes
[2026-01-11 10:42:10] [DEBUG] ID mapping saved successfully (950 bytes written)
[OK] ID mapping saved to: /home/fcefrancxd/www/scratch/fce-mysql/user_id_mapping.json

[2026-01-11 10:42:10] [DEBUG] Import process completed
[2026-01-11 10:42:10] [DEBUG] Total duration: 0.04 seconds
[2026-01-11 10:42:10] [DEBUG] Average time per user: 0.008 seconds
=== Import Complete ===
Total users:    5
Inserted:       0
Skipped:        5
Errors:         0
Duration:       0.04s
[2026-01-11 10:42:10] [DEBUG] Import completed successfully with no errors