MORSE MACHINE API DEBUG
======================

1. Testing database connection...
✅ Database connected successfully

2. Checking morse_machine_sessions table structure...
   - id (int(11))
   - username (varchar(255))
   - session_date (datetime)
   - character_set (enum('koch','cwops','abc','swedish','danish','hiragana','katakana'))
   - training_mode (enum('lesson','custom'))
   - lesson_number (int(11))
   - speed_wpm (int(11))
   - pitch_hz (int(11))
   - volume_percent (int(11))
   - buzzer_enabled (tinyint(1))
   - show_cw_enabled (tinyint(1))
   - session_duration_seconds (int(11))
   - total_characters (int(11))
   - correct_characters (int(11))
   - incorrect_characters (int(11))
   - accuracy_percentage (decimal(5,2))
   - effective_speed_wpm (decimal(6,2))
   - characters_in_session (longtext)
   - character_progress (longtext)
   - character_errors (longtext)
   - avg_response_time (decimal(8,3))
   - min_response_time (decimal(8,3))
   - max_response_time (decimal(8,3))
   - response_time_stddev (decimal(8,3))
   - improvement_from_previous (decimal(5,2))
   - session_notes (text)

3. Checking morse_machine_character_analytics table structure...
   - id (int(11))
   - session_id (int(11))
   - username (varchar(255))
   - character (char(10))
   - session_date (datetime)
   - attempts_in_session (int(11))
   - correct_in_session (int(11))
   - errors_in_session (int(11))
   - accuracy_in_session (decimal(5,2))
   - avg_response_time (decimal(8,3))
   - min_response_time (decimal(8,3))
   - max_response_time (decimal(8,3))
   - response_times (longtext)
   - cumulative_attempts (int(11))
   - cumulative_correct (int(11))
   - cumulative_errors (int(11))
   - overall_accuracy (decimal(5,2))
   - mastery_level (enum('learning','practicing','proficient','mastered'))
   - difficulty_score (decimal(5,2))
   - last_mistake_types (longtext)

4. Testing basic GET query (session summary)...
   Sessions found: 6
✅ Basic query successful

5. Testing character analytics query (corrected for actual schema)...
   Character analytics found: 4 records
✅ Character analytics query successful

6. Testing config/config.php file...
✅ config/config.php file exists
✅ setApiHeaders function exists
✅ logApiAccess function exists
✅ initializeApp function exists

6. Checking available Morse Machine tables...
   ✅ Found table: morse_machine_achievements
   ✅ Found table: morse_machine_character_analytics
   ✅ Found table: morse_machine_progression
   ✅ Found table: morse_machine_response_times
   ✅ Found table: morse_machine_sessions
   ✅ Found table: morse_machine_training_patterns

7. Testing session simulation...
✅ Session started with test username

DIAGNOSIS COMPLETE
================
Database tables: ✅ Created and accessible
Column structure: ✅ Matches API expectations
Basic queries: ✅ Working
Config file: ✅ Found