{"timestamp":"2026-05-13 15:03:29","message":"Query failed","context":{"query":"\n    SELECT category, COUNT(*) as count \n    FROM courses \n    JOIN students ON courses.id = students.course_id \n    GROUP BY category \n    ORDER BY count DESC\n","params":[],"error":"SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'category' in field list is ambiguous"},"ip":"CLI","url":"CLI"}
{"timestamp":"2026-05-13 15:03:37","message":"Query failed","context":{"query":"\n        SELECT category, COUNT(*) as count \n        FROM courses \n        JOIN students ON courses.id = students.course_id \n        GROUP BY category \n        ORDER BY count DESC\n    ","params":[],"error":"SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'category' in field list is ambiguous"},"ip":"CLI","url":"CLI"}
{"timestamp":"2026-05-13 15:23:10","message":"Query failed","context":{"query":"\n        SELECT al.*, u.full_name, u.username, u.role_slug \n        FROM audit_logs al \n        LEFT JOIN users u ON al.user_id = u.id \n        ORDER BY al.created_at DESC \n        LIMIT 5 OFFSET 0\n    ","params":[],"error":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.role_slug' in 'field list'"},"ip":"CLI","url":"CLI"}
{"timestamp":"2026-05-13 15:28:19","message":"Query failed","context":{"query":"SELECT id, roll_number, full_name, username, email, mobile, status, course_id, result_declared, certificate_issued, payment_status FROM users u WHERE u.role_id = 5 AND u.is_active=1 LIMIT 5","params":[],"error":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'status' in 'field list'"},"ip":"CLI","url":"CLI"}
{"timestamp":"2026-05-13 15:28:26","message":"Query failed","context":{"query":"\n  SELECT s.id, s.student_id, s.status, s.payment_status, s.result_declared, s.certificate_issued, s.course_id, \n         u.username, u.email, u.full_name\n  FROM students s \n  JOIN users u ON s.user_id = u.id \n  ORDER BY s.status DESC\n  LIMIT 10\n","params":[],"error":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 's.student_id' in 'field list'"},"ip":"CLI","url":"CLI"}