Quiz System Debug

Database connection successful. Found 5 records in AllyQuiz table.

Quiz Record Sample:

{
  "id": 1742045140111,
  "name": "staging test",
  "email": "sicnarfleumas@gmail.com",
  "verificationToken": "457a2bf5-d5b9-4808-9c26-22a5aee1b88c",
  "completed": true,
  "status": "failed",
  "score": 22,
  "passThreshold": 60,
  "passed": false,
  "totalQuestions": 45,
  "questionsPerSection": 15
}

Correct Answers Format:

Total correct answers: 45

Format: Using section_question format (s0_q1) ✓

Sample keys: s0_q1, s0_q2, s0_q3, s0_q4, s0_q5

Sample values: A, C, C, C, C

User Answers Format:

Total user answers: 45

Format: Using section_question format (s0_q1) ✓

Sample keys: s0_q1, s0_q2, s0_q3, s0_q4, s0_q5

Sample values: D, B, C, D, B

Format Consistency Check:

✓ Formats match between correct answers and user answers

Database Schema Information:

AllyQuiz Table Schema:
- id: number (primary key)
- name: text
- email: text (unique)
- phone: text
- verificationToken: text (unique)
- createdAt: date
- startTime: date (optional)
- endTime: date (optional)
- completionTimeSeconds: number (optional)
- status: text
- completed: boolean
- score: number (optional)
- passed: boolean (optional)
- totalQuestions: number (optional)
- questionsPerSection: number (optional)
- questionSet: text (optional) - JSON string of the full quiz structure
- userAnswers: text (optional) - JSON string with format s0_q1 -> answer
- correctAnswers: text (optional) - JSON string with format s0_q1 -> answer

Format Requirements:

Recent Changes: