{"timestamp":"2026-05-09 00:32:45","message":"OTP Generated (Email)","context":{"email":"+91-9627769817","otp":"410956"},"ip":"::1","url":"\/ibvte\/admin\/login.php"}
{"timestamp":"2026-05-09 00:33:23","message":"Query failed","context":{"query":"\n    SELECT s.*, \n           c.institution_name as college_name\n    FROM students s\n    LEFT JOIN users c ON s.college_id = c.id\n    WHERE s.result_declared = 1 AND s.percentage >= 40 AND s.remark != 'Fail'\n    ORDER BY s.result_declared_at DESC\n","params":[],"error":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 's.college_id' in 'on clause'"},"ip":"::1","url":"\/ibvte\/admin\/certificates.php"}
{"timestamp":"2026-05-09 01:49:10","message":"OTP Generated (Email)","context":{"email":"+91-9627769817","otp":"769508"},"ip":"::1","url":"\/ibvte\/admin\/login.php"}
{"timestamp":"2026-05-09 01:50:01","message":"OTP Generated (Email)","context":{"email":"+91-9627769817","otp":"113230"},"ip":"::1","url":"\/ibvte\/login.php"}
{"timestamp":"2026-05-09 01:52:40","message":"Query failed","context":{"query":"\n    SELECT s.*, \n           c.institution_name as college_name\n    FROM students s\n    LEFT JOIN users c ON s.college_id = c.id\n    WHERE s.result_declared = 1 AND s.percentage >= 40 AND s.remark != 'Fail'\n    ORDER BY s.result_declared_at DESC\n","params":[],"error":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 's.college_id' in 'on clause'"},"ip":"::1","url":"\/ibvte\/admin\/certificates.php"}
{"timestamp":"2026-05-09 02:11:59","message":"Colleges page access","context":{"action":"login_as","id":"4","user_id":1,"role":"super_admin"},"ip":"::1","url":"\/ibvte\/admin\/colleges.php?action=login_as&id=4&csrf_token=95ff92cce9adb068e73ffae2ac19626c789a9b62897db87d4897b59aa19a07df"}
{"timestamp":"2026-05-09 02:12:01","message":"Colleges page access","context":{"action":"login_as","id":"4","user_id":1,"role":"super_admin"},"ip":"::1","url":"\/ibvte\/admin\/colleges.php?action=login_as&id=4&csrf_token=95ff92cce9adb068e73ffae2ac19626c789a9b62897db87d4897b59aa19a07df"}
{"timestamp":"2026-05-09 02:12:01","message":"Colleges page access","context":{"action":"login_as","id":"4","user_id":1,"role":"super_admin"},"ip":"::1","url":"\/ibvte\/admin\/colleges.php?action=login_as&id=4&csrf_token=95ff92cce9adb068e73ffae2ac19626c789a9b62897db87d4897b59aa19a07df"}
{"timestamp":"2026-05-09 02:12:02","message":"Colleges page access","context":{"action":"login_as","id":"4","user_id":1,"role":"super_admin"},"ip":"::1","url":"\/ibvte\/admin\/colleges.php?action=login_as&id=4&csrf_token=95ff92cce9adb068e73ffae2ac19626c789a9b62897db87d4897b59aa19a07df"}
{"timestamp":"2026-05-09 02:12:02","message":"Colleges page access","context":{"action":"login_as","id":"4","user_id":1,"role":"super_admin"},"ip":"::1","url":"\/ibvte\/admin\/colleges.php?action=login_as&id=4&csrf_token=95ff92cce9adb068e73ffae2ac19626c789a9b62897db87d4897b59aa19a07df"}
{"timestamp":"2026-05-09 02:13:33","message":"Colleges page access","context":{"action":"list","id":"none","user_id":1,"role":"super_admin"},"ip":"::1","url":"\/ibvte\/admin\/colleges.php"}
{"timestamp":"2026-05-09 02:13:36","message":"Colleges page access","context":{"action":"login_as","id":"5","user_id":1,"role":"super_admin"},"ip":"::1","url":"\/ibvte\/admin\/colleges.php?action=login_as&id=5&csrf_token=95ff92cce9adb068e73ffae2ac19626c789a9b62897db87d4897b59aa19a07df"}
{"timestamp":"2026-05-09 02:13:37","message":"Colleges page access","context":{"action":"login_as","id":"5","user_id":1,"role":"super_admin"},"ip":"::1","url":"\/ibvte\/admin\/colleges.php?action=login_as&id=5&csrf_token=95ff92cce9adb068e73ffae2ac19626c789a9b62897db87d4897b59aa19a07df"}
{"timestamp":"2026-05-09 02:13:40","message":"Colleges page access","context":{"action":"list","id":"none","user_id":1,"role":"super_admin"},"ip":"::1","url":"\/ibvte\/admin\/colleges.php"}
{"timestamp":"2026-05-09 02:13:40","message":"Colleges page access","context":{"action":"list","id":"none","user_id":1,"role":"super_admin"},"ip":"::1","url":"\/ibvte\/admin\/colleges.php"}
{"timestamp":"2026-05-09 02:13:40","message":"Colleges page access","context":{"action":"list","id":"none","user_id":1,"role":"super_admin"},"ip":"::1","url":"\/ibvte\/admin\/colleges.php"}
{"timestamp":"2026-05-09 02:13:40","message":"Colleges page access","context":{"action":"list","id":"none","user_id":1,"role":"super_admin"},"ip":"::1","url":"\/ibvte\/admin\/colleges.php"}
{"timestamp":"2026-05-09 02:13:40","message":"Colleges page access","context":{"action":"list","id":"none","user_id":1,"role":"super_admin"},"ip":"::1","url":"\/ibvte\/admin\/colleges.php"}
{"timestamp":"2026-05-09 02:13:41","message":"Colleges page access","context":{"action":"list","id":"none","user_id":1,"role":"super_admin"},"ip":"::1","url":"\/ibvte\/admin\/colleges.php"}
{"timestamp":"2026-05-09 02:13:41","message":"Colleges page access","context":{"action":"list","id":"none","user_id":1,"role":"super_admin"},"ip":"::1","url":"\/ibvte\/admin\/colleges.php"}
{"timestamp":"2026-05-09 02:13:41","message":"Colleges page access","context":{"action":"list","id":"none","user_id":1,"role":"super_admin"},"ip":"::1","url":"\/ibvte\/admin\/colleges.php"}
{"timestamp":"2026-05-09 02:13:41","message":"Colleges page access","context":{"action":"list","id":"none","user_id":1,"role":"super_admin"},"ip":"::1","url":"\/ibvte\/admin\/colleges.php"}
{"timestamp":"2026-05-09 02:13:41","message":"Colleges page access","context":{"action":"list","id":"none","user_id":1,"role":"super_admin"},"ip":"::1","url":"\/ibvte\/admin\/colleges.php"}
{"timestamp":"2026-05-09 02:13:42","message":"Colleges page access","context":{"action":"list","id":"none","user_id":1,"role":"super_admin"},"ip":"::1","url":"\/ibvte\/admin\/colleges.php"}
{"timestamp":"2026-05-09 02:13:42","message":"Colleges page access","context":{"action":"list","id":"none","user_id":1,"role":"super_admin"},"ip":"::1","url":"\/ibvte\/admin\/colleges.php"}
{"timestamp":"2026-05-09 02:13:42","message":"Colleges page access","context":{"action":"list","id":"none","user_id":1,"role":"super_admin"},"ip":"::1","url":"\/ibvte\/admin\/colleges.php"}
{"timestamp":"2026-05-09 02:13:48","message":"Colleges page access","context":{"action":"login_as","id":"5","user_id":1,"role":"super_admin"},"ip":"::1","url":"\/ibvte\/admin\/colleges.php?action=login_as&id=5&csrf_token=95ff92cce9adb068e73ffae2ac19626c789a9b62897db87d4897b59aa19a07df"}
{"timestamp":"2026-05-09 02:20:37","message":"OTP Generated (Email)","context":{"email":"+91-9627769817","otp":"174515"},"ip":"::1","url":"\/ibvte\/admin\/login.php"}
{"timestamp":"2026-05-09 02:23:02","message":"OTP Generated (Email)","context":{"email":"+91-9627769817","otp":"615842"},"ip":"::1","url":"\/ibvte\/college\/login.php"}
{"timestamp":"2026-05-09 02:28:20","message":"OTP Generated (Email)","context":{"email":"+91-9627769817","otp":"607943"},"ip":"::1","url":"\/ibvte\/admin\/login.php"}
{"timestamp":"2026-05-09 02:30:01","message":"OTP Generated (Email)","context":{"email":"+91-9627769817","otp":"026752"},"ip":"::1","url":"\/ibvte\/admin\/login.php"}
{"timestamp":"2026-05-09 02:32:22","message":"OTP Generated (Email)","context":{"email":"+91-9627769817","otp":"653785"},"ip":"::1","url":"\/ibvte\/admin\/login.php"}
{"timestamp":"2026-05-09 03:03:13","message":"OTP Generated (Email)","context":{"email":"+91-9627769817","otp":"833683"},"ip":"::1","url":"\/ibvte\/admin\/login.php"}
{"timestamp":"2026-05-09 03:33:32","message":"OTP Generated (Email)","context":{"email":"+91-9627769817","otp":"408025"},"ip":"::1","url":"\/ibvte\/admin\/login.php"}
{"timestamp":"2026-05-09 14:25:56","message":"OTP Generated (Email)","context":{"email":"+91-9627769817","otp":"562074"},"ip":"::1","url":"\/ibvte\/admin\/login.php"}
{"timestamp":"2026-05-09 14:26:19","message":"Query failed","context":{"query":"UPDATE course_sub_items SET category = ?, sub_name = ?, short_name = ?, eligibility = ?, description = ?, image = ?, dur_years = ?, dur_months = ?, duration_value = ?, duration_label = ?, admission_fee = ?, exam_fee = ?, certificate_fee = ?, total_fee = ?, syllabus = ?, is_active = ?, course_id = ? WHERE id = ?","params":["Civil & Architecture","Advance Diploma in Civil Engineering","Advance","12th Pass","",null,1,0,1,"1 Year",2500,0,0,2500,"<p>aaaa<\/p>",1,0,81],"error":"SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ibvte`.`course_sub_items`, CONSTRAINT `course_sub_items_ibfk_1` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE)"},"ip":"::1","url":"\/ibvte\/admin\/courses.php?tab=sub_courses&edit_sub=81"}