Severity: Notice
Message: Trying to access array offset on value of type null
Filename: models/internal_message.php
Line Number: 214
Severity: Notice
Message: Trying to access array offset on value of type null
Filename: models/internal_message.php
Line Number: 215
Severity: Warning
Message: Cannot modify header information - headers already sent by (output started at /home/childrensmanor/public_html/application/models/utility.php:380)
Filename: core/Common.php
Line Number: 403
Error Number: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND internal_messages.sender_type = 'teacher' AND internal_messages...' at line 6
Select Z.reply_id,Z.flag_for_msg,Z.id,Z.subject,Z.created_date,Z.fullname,Z.status,Z.sender_type From(Select Y.reply_id,Y.flag_for_msg,Y.id,Y.subject,Y.created_date,Y.fullname,Y.status,Y.sender_type From((SELECT internal_messages.id,internal_messages.reply_id,internal_messages.flag_for_msg,internal_messages.subject, internal_messages.status, internal_messages.created_date, internal_messages.sender_type, CONCAT(teachers.first_name, ' ', teachers.last_name) as fullname FROM internal_messages LEFT JOIN teachers ON internal_messages.sender_id = teachers.teacher_id WHERE internal_messages.receiver_id = AND internal_messages.sender_type = 'teacher' AND internal_messages.receiver_delete != 1 And internal_messages.school_id = '') UNION (SELECT internal_messages.id,internal_messages.reply_id,internal_messages.flag_for_msg,internal_messages.subject, internal_messages.status, internal_messages.created_date, internal_messages.sender_type, CONCAT(parents.first_name, ' ', parents.last_name) as fullname FROM internal_messages LEFT JOIN parents ON parents.id = internal_messages.sender_id WHERE internal_messages.receiver_id = AND internal_messages.sender_type = 'parent' AND internal_messages.receiver_delete != 1 And internal_messages.school_id = '') UNION (SELECT internal_messages.id,internal_messages.reply_id,internal_messages.flag_for_msg,internal_messages.status, internal_messages.subject, internal_messages.created_date, internal_messages.sender_type, users.username as fullname FROM internal_messages LEFT JOIN users ON users.user_id = internal_messages.sender_id WHERE internal_messages.receiver_id = AND internal_messages.sender_type = 'admin' AND internal_messages.receiver_delete != 1 And internal_messages.school_id = '') order by created_date desc )as Y order by Y.created_date ) as Z group by Z.reply_id
Filename: /home/childrensmanor/public_html/models/internal_message.php
Line Number: 245