[2026-03-19 03:07:09] [DB_CONNECT_ERROR] MSG: DB 연결 실패: Access denied for user 'lms_user'@'localhost' (using password: YES) | SQL: | IP: ::1 [2026-03-19 06:03:04] [DB_CONNECT_ERROR] MSG: DB 연결 실패: Access denied for user 'root'@'localhost' (using password: NO) | SQL: | IP: ::1 [2026-03-19 06:12:46] [DB_QUERY_ERROR] MSG: Unknown column 'enroll_count' in 'field list' | SQL: SELECT SUM(enroll_count) AS s FROM lms_company WHERE del_yn='N' | IP: ::1 [2026-03-19 06:22:04] [DB_QUERY_ERROR] MSG: Table 'db_lms_area.lms_enrollment_log' doesn't exist | SQL: SELECT le.enroll_id, lm.member_id, lm.user_name, lm.mobile, lm.mobile_display, lc2.course_title, le.progress_rate, lc.learn_end_date, DATEDIFF(lc.learn_end_date, CURDATE()) as days_remaining, MAX(lel.created_at) as last_learn_date, COUNT(lnl.log_id) as encourage_count FROM lms_enrollment le JOIN lms_class lc ON le.class_id = lc.class_id JOIN lms_course lc2 ON lc.course_id = lc2.course_id JOIN lms_member lm ON le.member_id = lm.member_id LEFT JOIN lms_enrollment_log lel ON le.enroll_id = lel.enroll_id AND lel.log_type = 'LEARN' LEFT JOIN lms_notification_log lnl ON lm.member_id = lnl.member_id AND lnl.send_type IN ('SMS', 'KAKAO', 'EMAIL') WHERE le.del_yn = 'N' AND le.enroll_status = 'A' GROUP BY le.enroll_id ORDER BY le.progress_rate ASC, lc.learn_end_date ASC LIMIT 0, 20 | IP: ::1 [2026-03-19 06:22:04] [DB_QUERY_ERROR] MSG: Unknown column 'lnl.send_at' in 'field list' | SQL: SELECT lnl.log_id, lnl.send_at, lm.user_name, lnl.send_type, lnl.message_content, lnl.send_status FROM lms_notification_log lnl JOIN lms_member lm ON lnl.member_id = lm.member_id ORDER BY lnl.send_at DESC LIMIT 20 | IP: ::1 [2026-03-19 06:22:04] [DB_QUERY_ERROR] MSG: Unknown column 'tpl_content' in 'field list' | SQL: SELECT tpl_id, tpl_name, send_type, tpl_content FROM lms_notification_tpl WHERE use_yn = 'Y' ORDER BY tpl_name | IP: ::1 [2026-03-19 06:22:18] [DB_QUERY_ERROR] MSG: Unknown column 'enroll_count' in 'field list' | SQL: SELECT SUM(enroll_count) AS s FROM lms_company WHERE del_yn='N' | IP: ::1 [2026-03-19 06:31:18] [DB_QUERY_ERROR] MSG: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'lms_certificate c LEFT JOIN lms_member m ON c.member_id = m.member_id LE' at line 1 | SQL: lms_certificate c LEFT JOIN lms_member m ON c.member_id = m.member_id LEFT JOIN lms_course co ON c.course_id = co.course_id LEFT JOIN lms_enroll e ON c.enroll_id = e.enroll_id | IP: 211.114.48.196 [2026-03-19 06:31:18] [DB_QUERY_ERROR] MSG: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?, ?' at line 9 | SQL: SELECT c.cert_id, c.cert_no, c.member_id, c.course_id, c.enroll_id, c.issue_date, c.expire_date, c.cert_type, c.is_valid, m.name as member_name, co.course_name, e.class_id FROM lms_certificate c LEFT JOIN lms_member m ON c.member_id = m.member_id LEFT JOIN lms_course co ON c.course_id = co.course_id LEFT JOIN lms_enroll e ON c.enroll_id = e.enroll_id WHERE 1=1 ORDER BY c.created_at DESC LIMIT ?, ? | IP: 211.114.48.196 [2026-03-19 06:31:18] [DB_QUERY_ERROR] MSG: Unknown column 'is_valid' in 'where clause' | SQL: SELECT COUNT(*) as total_count FROM lms_certificate WHERE YEAR(issue_date) = YEAR(NOW()) AND MONTH(issue_date) = MONTH(NOW()) AND is_valid='N' | IP: 211.114.48.196 [2026-03-19 06:31:18] [DB_QUERY_ERROR] MSG: Table 'db_lms_area.lms_enroll' doesn't exist | SQL: SELECT e.enroll_id, CONCAT(m.name, ' - ', co.course_name) as label FROM lms_enroll e LEFT JOIN lms_member m ON e.member_id = m.member_id LEFT JOIN lms_course co ON e.course_id = co.course_id WHERE e.pass_yn='Y' AND NOT EXISTS ( SELECT 1 FROM lms_certificate WHERE enroll_id = e.enroll_id ) ORDER BY e.created_at DESC | IP: 211.114.48.196 [2026-03-19 06:31:24] [DB_QUERY_ERROR] MSG: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'lms_certificate c LEFT JOIN lms_member m ON c.member_id = m.member_id LE' at line 1 | SQL: lms_certificate c LEFT JOIN lms_member m ON c.member_id = m.member_id LEFT JOIN lms_course co ON c.course_id = co.course_id LEFT JOIN lms_enroll e ON c.enroll_id = e.enroll_id | IP: 211.114.48.196 [2026-03-19 06:31:24] [DB_QUERY_ERROR] MSG: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?, ?' at line 9 | SQL: SELECT c.cert_id, c.cert_no, c.member_id, c.course_id, c.enroll_id, c.issue_date, c.expire_date, c.cert_type, c.is_valid, m.name as member_name, co.course_name, e.class_id FROM lms_certificate c LEFT JOIN lms_member m ON c.member_id = m.member_id LEFT JOIN lms_course co ON c.course_id = co.course_id LEFT JOIN lms_enroll e ON c.enroll_id = e.enroll_id WHERE 1=1 ORDER BY c.created_at DESC LIMIT ?, ? | IP: 211.114.48.196 [2026-03-19 06:31:24] [DB_QUERY_ERROR] MSG: Unknown column 'is_valid' in 'where clause' | SQL: SELECT COUNT(*) as total_count FROM lms_certificate WHERE YEAR(issue_date) = YEAR(NOW()) AND MONTH(issue_date) = MONTH(NOW()) AND is_valid='N' | IP: 211.114.48.196 [2026-03-19 06:31:24] [DB_QUERY_ERROR] MSG: Table 'db_lms_area.lms_enroll' doesn't exist | SQL: SELECT e.enroll_id, CONCAT(m.name, ' - ', co.course_name) as label FROM lms_enroll e LEFT JOIN lms_member m ON e.member_id = m.member_id LEFT JOIN lms_course co ON e.course_id = co.course_id WHERE e.pass_yn='Y' AND NOT EXISTS ( SELECT 1 FROM lms_certificate WHERE enroll_id = e.enroll_id ) ORDER BY e.created_at DESC | IP: 211.114.48.196 [2026-03-19 06:31:25] [DB_QUERY_ERROR] MSG: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'lms_exam_question' at line 1 | SQL: lms_exam_question | IP: 211.114.48.196 [2026-03-19 06:31:25] [DB_QUERY_ERROR] MSG: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?, ?' at line 7 | SQL: SELECT eq.question_id, eq.course_id, eq.category, eq.question_content, eq.q_type, eq.difficulty, eq.score, eq.use_yn, eq.created_at, c.course_name FROM lms_exam_question eq LEFT JOIN lms_course c ON eq.course_id = c.course_id WHERE 1=1 ORDER BY eq.created_at DESC LIMIT ?, ? | IP: 211.114.48.196 [2026-03-19 06:31:25] [DB_QUERY_ERROR] MSG: Unknown column 'course_name' in 'field list' | SQL: SELECT course_id, course_name FROM lms_course WHERE use_yn='Y' ORDER BY course_name | IP: 211.114.48.196 [2026-03-19 06:31:50] [DB_QUERY_ERROR] MSG: Table 'db_lms_area.lms_enrollment_log' doesn't exist | SQL: SELECT le.enroll_id, lm.member_id, lm.user_name, lm.mobile, lm.mobile_display, lc2.course_title, le.progress_rate, lc.learn_end_date, DATEDIFF(lc.learn_end_date, CURDATE()) as days_remaining, MAX(lel.created_at) as last_learn_date, COUNT(lnl.log_id) as encourage_count FROM lms_enrollment le JOIN lms_class lc ON le.class_id = lc.class_id JOIN lms_course lc2 ON lc.course_id = lc2.course_id JOIN lms_member lm ON le.member_id = lm.member_id LEFT JOIN lms_enrollment_log lel ON le.enroll_id = lel.enroll_id AND lel.log_type = 'LEARN' LEFT JOIN lms_notification_log lnl ON lm.member_id = lnl.member_id AND lnl.send_type IN ('SMS', 'KAKAO', 'EMAIL') WHERE le.del_yn = 'N' AND le.enroll_status = 'A' GROUP BY le.enroll_id ORDER BY le.progress_rate ASC, lc.learn_end_date ASC LIMIT 0, 20 | IP: 211.114.48.196 [2026-03-19 06:31:50] [DB_QUERY_ERROR] MSG: Unknown column 'lnl.send_at' in 'field list' | SQL: SELECT lnl.log_id, lnl.send_at, lm.user_name, lnl.send_type, lnl.message_content, lnl.send_status FROM lms_notification_log lnl JOIN lms_member lm ON lnl.member_id = lm.member_id ORDER BY lnl.send_at DESC LIMIT 20 | IP: 211.114.48.196 [2026-03-19 06:31:50] [DB_QUERY_ERROR] MSG: Unknown column 'tpl_content' in 'field list' | SQL: SELECT tpl_id, tpl_name, send_type, tpl_content FROM lms_notification_tpl WHERE use_yn = 'Y' ORDER BY tpl_name | IP: 211.114.48.196 [2026-03-19 06:40:31] [DB_QUERY_ERROR] MSG: Table 'db_lms_area.lms_enrollment_log' doesn't exist | SQL: SELECT le.enroll_id, lm.member_id, lm.user_name, lm.mobile, lm.mobile_display, lc2.course_title, le.progress_rate, lc.learn_end_date, DATEDIFF(lc.learn_end_date, CURDATE()) as days_remaining, MAX(lel.created_at) as last_learn_date, COUNT(lnl.log_id) as encourage_count FROM lms_enrollment le JOIN lms_class lc ON le.class_id = lc.class_id JOIN lms_course lc2 ON lc.course_id = lc2.course_id JOIN lms_member lm ON le.member_id = lm.member_id LEFT JOIN lms_enrollment_log lel ON le.enroll_id = lel.enroll_id AND lel.log_type = 'LEARN' LEFT JOIN lms_notification_log lnl ON lm.member_id = lnl.member_id AND lnl.send_type IN ('SMS', 'KAKAO', 'EMAIL') WHERE le.del_yn = 'N' AND le.enroll_status = 'A' GROUP BY le.enroll_id ORDER BY le.progress_rate ASC, lc.learn_end_date ASC LIMIT 0, 20 | IP: 211.114.48.196 [2026-03-19 06:40:31] [DB_QUERY_ERROR] MSG: Unknown column 'lnl.send_at' in 'field list' | SQL: SELECT lnl.log_id, lnl.send_at, lm.user_name, lnl.send_type, lnl.message_content, lnl.send_status FROM lms_notification_log lnl JOIN lms_member lm ON lnl.member_id = lm.member_id ORDER BY lnl.send_at DESC LIMIT 20 | IP: 211.114.48.196 [2026-03-19 06:40:31] [DB_QUERY_ERROR] MSG: Unknown column 'tpl_content' in 'field list' | SQL: SELECT tpl_id, tpl_name, send_type, tpl_content FROM lms_notification_tpl WHERE use_yn = 'Y' ORDER BY tpl_name | IP: 211.114.48.196 [2026-03-19 06:40:32] [DB_QUERY_ERROR] MSG: Table 'db_lms_area.lms_enrollment_log' doesn't exist | SQL: SELECT le.enroll_id, lm.member_id, lm.user_name, lm.mobile, lm.mobile_display, lc2.course_title, le.progress_rate, lc.learn_end_date, DATEDIFF(lc.learn_end_date, CURDATE()) as days_remaining, MAX(lel.created_at) as last_learn_date, COUNT(lnl.log_id) as encourage_count FROM lms_enrollment le JOIN lms_class lc ON le.class_id = lc.class_id JOIN lms_course lc2 ON lc.course_id = lc2.course_id JOIN lms_member lm ON le.member_id = lm.member_id LEFT JOIN lms_enrollment_log lel ON le.enroll_id = lel.enroll_id AND lel.log_type = 'LEARN' LEFT JOIN lms_notification_log lnl ON lm.member_id = lnl.member_id AND lnl.send_type IN ('SMS', 'KAKAO', 'EMAIL') WHERE le.del_yn = 'N' AND le.enroll_status = 'A' GROUP BY le.enroll_id ORDER BY le.progress_rate ASC, lc.learn_end_date ASC LIMIT 0, 20 | IP: 211.114.48.196 [2026-03-19 06:40:32] [DB_QUERY_ERROR] MSG: Unknown column 'lnl.send_at' in 'field list' | SQL: SELECT lnl.log_id, lnl.send_at, lm.user_name, lnl.send_type, lnl.message_content, lnl.send_status FROM lms_notification_log lnl JOIN lms_member lm ON lnl.member_id = lm.member_id ORDER BY lnl.send_at DESC LIMIT 20 | IP: 211.114.48.196 [2026-03-19 06:40:32] [DB_QUERY_ERROR] MSG: Unknown column 'tpl_content' in 'field list' | SQL: SELECT tpl_id, tpl_name, send_type, tpl_content FROM lms_notification_tpl WHERE use_yn = 'Y' ORDER BY tpl_name | IP: 211.114.48.196 [2026-03-19 06:40:34] [DB_QUERY_ERROR] MSG: Table 'db_lms_area.lms_enrollment_log' doesn't exist | SQL: SELECT le.enroll_id, lm.member_id, lm.user_name, lm.mobile, lm.mobile_display, lc2.course_title, le.progress_rate, lc.learn_end_date, DATEDIFF(lc.learn_end_date, CURDATE()) as days_remaining, MAX(lel.created_at) as last_learn_date, COUNT(lnl.log_id) as encourage_count FROM lms_enrollment le JOIN lms_class lc ON le.class_id = lc.class_id JOIN lms_course lc2 ON lc.course_id = lc2.course_id JOIN lms_member lm ON le.member_id = lm.member_id LEFT JOIN lms_enrollment_log lel ON le.enroll_id = lel.enroll_id AND lel.log_type = 'LEARN' LEFT JOIN lms_notification_log lnl ON lm.member_id = lnl.member_id AND lnl.send_type IN ('SMS', 'KAKAO', 'EMAIL') WHERE le.del_yn = 'N' AND le.enroll_status = 'A' GROUP BY le.enroll_id ORDER BY le.progress_rate ASC, lc.learn_end_date ASC LIMIT 0, 20 | IP: 211.114.48.196 [2026-03-19 06:40:34] [DB_QUERY_ERROR] MSG: Unknown column 'lnl.send_at' in 'field list' | SQL: SELECT lnl.log_id, lnl.send_at, lm.user_name, lnl.send_type, lnl.message_content, lnl.send_status FROM lms_notification_log lnl JOIN lms_member lm ON lnl.member_id = lm.member_id ORDER BY lnl.send_at DESC LIMIT 20 | IP: 211.114.48.196 [2026-03-19 06:40:34] [DB_QUERY_ERROR] MSG: Unknown column 'tpl_content' in 'field list' | SQL: SELECT tpl_id, tpl_name, send_type, tpl_content FROM lms_notification_tpl WHERE use_yn = 'Y' ORDER BY tpl_name | IP: 211.114.48.196 [2026-03-19 06:40:35] [DB_QUERY_ERROR] MSG: Unknown column 'join_type' in 'field list' | SQL: SELECT member_id, user_id, user_name, email, mobile_display, join_type, status, last_login_at, created_at FROM lms_member WHERE 1=1 ORDER BY created_at DESC LIMIT 0, 20 | IP: 211.114.48.196 [2026-03-19 06:40:38] [DB_QUERY_ERROR] MSG: Unknown column 'join_type' in 'field list' | SQL: SELECT member_id, user_id, user_name, email, mobile_display, join_type, status, last_login_at, created_at FROM lms_member WHERE 1=1 ORDER BY created_at DESC LIMIT 0, 20 | IP: 211.114.48.196 [2026-03-19 06:40:45] [DB_QUERY_ERROR] MSG: Unknown column 'join_type' in 'field list' | SQL: SELECT member_id, user_id, user_name, email, mobile_display, join_type, status, last_login_at, created_at FROM lms_member WHERE 1=1 ORDER BY created_at DESC LIMIT 0, 20 | IP: 211.114.48.196 [2026-03-19 06:40:57] [DB_QUERY_ERROR] MSG: Unknown column 'join_type' in 'field list' | SQL: SELECT member_id, user_id, user_name, email, mobile_display, join_type, status, last_login_at, created_at FROM lms_member WHERE 1=1 ORDER BY created_at DESC LIMIT 0, 20 | IP: 211.114.48.196 [2026-03-19 06:40:59] [DB_QUERY_ERROR] MSG: Unknown column 'enroll_count' in 'field list' | SQL: SELECT SUM(enroll_count) AS s FROM lms_company WHERE del_yn='N' | IP: 211.114.48.196 [2026-03-19 07:16:01] [DB_QUERY_ERROR] MSG: Column 'del_yn' in where clause is ambiguous | SQL: SELECT COUNT(*) as cnt FROM lms_enrollment e LEFT JOIN lms_class c ON e.class_id = c.class_id LEFT JOIN lms_course co ON e.course_id = co.course_id LEFT JOIN lms_member m ON e.member_id = m.member_id WHERE del_yn = 'N' | IP: 211.114.48.196 [2026-03-19 07:16:01] [DB_QUERY_ERROR] MSG: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-20, 20' at line 13 | SQL: SELECT e.enroll_id, e.class_id, e.member_id, e.course_id, e.emp_ins_flag, e.enroll_status, e.progress_rate, e.final_score, e.pass_yn, e.pass_date, e.enroll_date, e.created_at, m.user_name, m.user_id, m.email, co.course_title, co.course_code, c.class_year, c.class_seq, c.learn_start_date, c.learn_end_date FROM lms_enrollment e LEFT JOIN lms_class c ON e.class_id = c.class_id LEFT JOIN lms_course co ON e.course_id = co.course_id LEFT JOIN lms_member m ON e.member_id = m.member_id WHERE del_yn = 'N' ORDER BY e.created_at DESC LIMIT -20, 20 | IP: 211.114.48.196 [2026-03-19 07:35:47] [DB_QUERY_ERROR] MSG: Column 'del_yn' in where clause is ambiguous | SQL: SELECT COUNT(*) as cnt FROM lms_enrollment e LEFT JOIN lms_class c ON e.class_id = c.class_id LEFT JOIN lms_course co ON e.course_id = co.course_id LEFT JOIN lms_member m ON e.member_id = m.member_id WHERE del_yn = 'N' | IP: 127.0.0.1 [2026-03-19 07:35:47] [DB_QUERY_ERROR] MSG: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-20, 20' at line 13 | SQL: SELECT e.enroll_id, e.class_id, e.member_id, e.course_id, e.emp_ins_flag, e.enroll_status, e.progress_rate, e.final_score, e.pass_yn, e.pass_date, e.enroll_date, e.created_at, m.user_name, m.user_id, m.email, co.course_title, co.course_code, c.class_year, c.class_seq, c.learn_start_date, c.learn_end_date FROM lms_enrollment e LEFT JOIN lms_class c ON e.class_id = c.class_id LEFT JOIN lms_course co ON e.course_id = co.course_id LEFT JOIN lms_member m ON e.member_id = m.member_id WHERE del_yn = 'N' ORDER BY e.created_at DESC LIMIT -20, 20 | IP: 127.0.0.1 [2026-03-19 09:29:31] [DB_QUERY_ERROR] MSG: Unknown column 'join_type' in 'field list' | SQL: SELECT member_id, user_id, user_name, email, mobile_display, join_type, status, last_login_at, created_at FROM lms_member WHERE 1=1 ORDER BY created_at DESC LIMIT 0, 20 | IP: 127.0.0.1 [2026-03-19 13:14:26] [DB_QUERY_ERROR] MSG: Column 'del_yn' in where clause is ambiguous | SQL: SELECT COUNT(*) as cnt FROM lms_enrollment e LEFT JOIN lms_class c ON e.class_id = c.class_id LEFT JOIN lms_course co ON e.course_id = co.course_id LEFT JOIN lms_member m ON e.member_id = m.member_id WHERE del_yn = 'N' | IP: 127.0.0.1 [2026-03-19 13:14:26] [DB_QUERY_ERROR] MSG: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-20, 20' at line 13 | SQL: SELECT e.enroll_id, e.class_id, e.member_id, e.course_id, e.emp_ins_flag, e.enroll_status, e.progress_rate, e.final_score, e.pass_yn, e.pass_date, e.enroll_date, e.created_at, m.user_name, m.user_id, m.email, co.course_title, co.course_code, c.class_year, c.class_seq, c.learn_start_date, c.learn_end_date FROM lms_enrollment e LEFT JOIN lms_class c ON e.class_id = c.class_id LEFT JOIN lms_course co ON e.course_id = co.course_id LEFT JOIN lms_member m ON e.member_id = m.member_id WHERE del_yn = 'N' ORDER BY e.created_at DESC LIMIT -20, 20 | IP: 127.0.0.1 [2026-03-19 13:17:09] [DB_QUERY_ERROR] MSG: Unknown column 'use_yn' in 'where clause' | SQL: SELECT course_id, course_title FROM lms_course WHERE use_yn='Y' ORDER BY course_title | IP: 127.0.0.1