A PHP Error was encountered

Severity: Notice

Message: Undefined index: ach_id

Filename: controllers/Cms_content.php

Line Number: 56

Backtrace:

File: /datadisk/vhosts/kriya/www/application/controllers/Cms_content.php
Line: 56
Function: _error_handler

File: /datadisk/vhosts/kriya/www/index.php
Line: 316
Function: require_once

Database Error

A Database Error Occurred

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 Event.end_date>='2024-03-19' order by end_date asc' at line 9

SELECT Event.*, Acharya.name as acharya_name, Acharya.type as acharya_type, Acharya.paramlink, EventType.EventType, CenterMaster.city, CenterMaster.name as center_name FROM `Event` left join CenterMaster on Event.center_id=CenterMaster.id left join EventAcharya on Event.evt_id=EventAcharya.evt_id left join Acharya on EventAcharya.ach_id=Acharya.ach_id left join EventType on Event.et_id=EventType.Etid where Event.status='A' AND Acharya.ach_id = AND Event.end_date>='2024-03-19' order by end_date asc

Filename: controllers/Cms_content.php

Line Number: 60