{"ts":"2026-05-11 12:01:53","type":"PDOException","message":"SQLSTATE[42S02]: Base table or view not found: 1146 Table 'atelier_20260330.consultant_task_review' doesn't exist","code":"42S02","file":"/var/www/html/api/core/BaseRepository.php","line":105,"context":{"method":"App\\Api\\Repositories\\BaseRepository::query","table":"checklist","sql":"SELECT\r\n                        ct.sort_order,\r\n                        t.id          AS task_id,\r\n                        t.name,\r\n                        t.description,\r\n                        t.execution_time,\r\n                        t.is_mandatory,\r\n                        t.requires_photo,\r\n                        t.frequency,\r\n                        t.day_of_week,\r\n                        COALESCE(tc.status, 'PENDING') AS status,\r\n                        tc.id         AS completion_id,\r\n                        tc.completed_at,\r\n                        tc.scheduled_time,\r\n                        tc.note,\r\n                        emp.display_name AS completed_by,\r\n                        fa.id            AS attachment_id,\r\n                        fa.original_name AS attachment_filename,\r\n                        ctr.id           AS review_id,\r\n                        ctr.is_accepted  AS review_is_accepted,\r\n                        ctr.rating       AS review_rating,\r\n                        ctr.comment      AS review_comment\r\n                    FROM checklist_task ct\r\n                    JOIN todo_task t ON t.id = ct.task_id\r\n                        AND (t.frequency = 'DAILY'\r\n                             OR (t.frequency = 'WEEKLY' AND t.day_of_week = :day_of_week))\r\n                    LEFT JOIN todo_task_completion tc\r\n                        ON tc.task_id = ct.task_id\r\n                        AND tc.shop_id = :shop_id\r\n                        AND tc.scheduled_for_date = :date\r\n                    LEFT JOIN franchisee_employee emp\r\n                        ON emp.id = tc.completed_by_employee_id\r\n                    LEFT JOIN file_attachment fa\r\n                        ON fa.related_type = 'task_completion'\r\n                        AND fa.related_id = tc.id\r\n                    LEFT JOIN consultant_task_review ctr\r\n                        ON ctr.shop_id = :shop_id\r\n                        AND ctr.task_id = t.id\r\n                        AND ctr.review_date = :date\r\n                    WHERE ct.checklist_id = :checklist_id\r\n                    ORDER BY ct.sort_order ASC, ct.id ASC","params":{"shop_id":2,"date":"2026-05-09","day_of_week":"SATURDAY","checklist_id":3}}}
{"ts":"2026-05-11 14:40:42","type":"PDOException","message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'where clause'","code":"42S22","file":"/var/www/html/api/core/BaseRepository.php","line":66,"context":{"method":"App\\Api\\Repositories\\BaseRepository::first","table":"notification_read_log","sql":"SELECT * FROM notification_read_log WHERE id = :id","params":{"id":33},"data":{"id":33},"data_not":[]}}
{"ts":"2026-05-11 14:40:42","type":"PDOException","message":"SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '33-75' for key 'PRIMARY'","code":"23000","file":"/var/www/html/api/core/BaseRepository.php","line":225,"context":{"method":"App\\Api\\Repositories\\BaseRepository::insert","table":"notification_read_log","sql":"INSERT INTO notification_read_log (id_notification,id_employee,id_shop,last_read_at,last_seen_date,read_count) values (:id_notification,:id_employee,:id_shop,:last_read_at,:last_seen_date,:read_count)","params":{"id_notification":33,"id_employee":75,"id_shop":2,"last_read_at":"2026-05-11 14:40:42","last_seen_date":"2026-05-11","read_count":1},"columns":["id_notification","id_employee","id_shop","last_read_at","last_seen_date","read_count"]}}
{"ts":"2026-05-11 15:38:09","type":"PDOException","message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'where clause'","code":"42S22","file":"/var/www/html/api/core/BaseRepository.php","line":66,"context":{"method":"App\\Api\\Repositories\\BaseRepository::first","table":"notification_read_log","sql":"SELECT * FROM notification_read_log WHERE id = :id","params":{"id":392},"data":{"id":392},"data_not":[]}}
{"ts":"2026-05-11 15:38:09","type":"PDOException","message":"SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '392-75' for key 'PRIMARY'","code":"23000","file":"/var/www/html/api/core/BaseRepository.php","line":225,"context":{"method":"App\\Api\\Repositories\\BaseRepository::insert","table":"notification_read_log","sql":"INSERT INTO notification_read_log (id_notification,id_employee,id_shop,last_read_at,last_seen_date,read_count) values (:id_notification,:id_employee,:id_shop,:last_read_at,:last_seen_date,:read_count)","params":{"id_notification":392,"id_employee":75,"id_shop":2,"last_read_at":"2026-05-11 15:38:09","last_seen_date":"2026-05-11","read_count":1},"columns":["id_notification","id_employee","id_shop","last_read_at","last_seen_date","read_count"]}}