help to better help you:
Please: add always Joomla / JEM version and details to your posts, so we can try to reproduce your issue!
Event not found error only on classes
Re: Event not found error only on classes
1 week 1 day ago - 1 week 1 day ago
JEM does not delete events and assumes that if they were created, they still exist.
Why are you deleting past events? Wouldn’t it be better to archive them instead?
After debugging the issue, this is the cause of the problem:
These events (with id 1010, 1011,...) are part of a recurrence series. Each event in the series has a root event, and the ID of this root event is saved in the recurrence_first_id field for each event register. When an event expires, instead of archiving it, the event is deleted from the xxx_jem_events table (manual, or vía script).The error occurs because the root event was deleted from the _jem_events table. The code checks for the root event associated with each child event. Since the root event no longer exists in your database, an error message is displayed. See line 388 in \components\com_jem\views\event\view.html.php.
For example, for your database, the events with IDs 1010, 1011, 1012, 1013, 1014, 1015, etc., have recurrence_first_id = 1004. However, the root event with ID 1004 no longer exists in your database because it was deleted (see the attached image).
Solution and recommendation:
Instead of deleting events, you can automatically archive them once they have passed. You just need to enable the following setting in JEM Settings → Basic Settings → Event Handling → Handle Old Events = Archive old events + Number of Days = 1. This way, you won’t have the error, and the root event check will have data because the event will still exist, even if it’s archived.
Why are you deleting past events? Wouldn’t it be better to archive them instead?
After debugging the issue, this is the cause of the problem:
These events (with id 1010, 1011,...) are part of a recurrence series. Each event in the series has a root event, and the ID of this root event is saved in the recurrence_first_id field for each event register. When an event expires, instead of archiving it, the event is deleted from the xxx_jem_events table (manual, or vía script).The error occurs because the root event was deleted from the _jem_events table. The code checks for the root event associated with each child event. Since the root event no longer exists in your database, an error message is displayed. See line 388 in \components\com_jem\views\event\view.html.php.
For example, for your database, the events with IDs 1010, 1011, 1012, 1013, 1014, 1015, etc., have recurrence_first_id = 1004. However, the root event with ID 1004 no longer exists in your database because it was deleted (see the attached image).
Solution and recommendation:
Instead of deleting events, you can automatically archive them once they have passed. You just need to enable the following setting in JEM Settings → Basic Settings → Event Handling → Handle Old Events = Archive old events + Number of Days = 1. This way, you won’t have the error, and the root event check will have data because the event will still exist, even if it’s archived.
Last edit: 1 week 1 day ago by McKillo.
Please Log in or Create an account to join the conversation.