JEM keeps showing just the same 3 events

First, to clarify the reason for this UPDATE for venues table (now included in version 4.4.1):

This UPDATE sets venues to Public, not events. Since JEM 2.36 (4-5 years ago), venues were set in the table with access = 0 (by default, don't have ACL). If these venues have not been modified and saved, this value remains unchanged.

With JEM 4.4.0, ACL was added to events, categories and venues. In a migrated JEM installation, venues created back then still have access = 0. With JEM 4.4.0, events associated with those venues are not visible due to lack of permissions.

This UPDATE sets permissions to Public if the value is 0, making them visible again.


Second, to clarify how the events go to archive or not:

By default en JEM, events are published and not moved to archived. However, this can be automated: after X days, they can be marked as archived (see JEM global settings, under Basic Setting - Event Handling). By default, nothing happens. You can set it so that after one day, the event is automatically marked as archived. If this setting is not changed, the event remains in its original "Published" state, even if it's a past event.

The calendar in JEM 4.4.0 implements a new default behavior: if an event is archived, it is not shown in the calendar. Just like Joomla does with articles. Each administrator decides which events appear in the calendar by adjusting the Calendar view settings (change in option 'Show archived events' to Yes).

JEM is flexible enough to display different options, but the configuration must match what you want to achieve.Events can be set to be automatically marked as archived, and then you choose whether to show them in the calendar or not. Another option is not to archive events at all, and still show published events in the calendar, even if they are past. In this last case, you can also manage visibility using the event's publishing end dates.

Almost everything is possible in JEM, and in a consistent way. But something may still need to be considered in the model. If so, we'd be happy to receive the details, or even a real example to evaluate it.

I set "venues" to "access = 1"
(like before).
UPDATE #__jem_venues SET access = 1 WHERE access = 0;

You still have access to the site and can see.

I can't see my problem. sorry.

even on 4.4.1, I've to set all events on "archived" to see
the only way to see them

best, m.

Now, I see a second issue in your web.
The events aren't displaying because they are in the wrong category or without category (error in the import process, I don't know).

If you go to JEM → Categories, you'll see that there are events (361 of them) assigned to the root category, which is incorrect. In JEM, events cannot be assigned to the root category—it doesn't even appear as an option in the dropdown list.
I'm not sure how these events ended up assigned to the root category (ID 0).

Is there any process that might be creating events in the events table outside of the normal JEM views?
If the these events have a id cat = 0 in the cats_event_relations table
or

Have you migrated JEM events in the past without importing the cats_event_relations table?
If the these events aren't in the cats_event_relations table.

I think this is an external error, or perhaps an error caused by not importing the CSV of relations.

I don't have access to MySQL to check the JEM tables, but you can take a look at this table.

I don't know which categories each event belongs to—that information has been lost or might still exist in an old installation (in case it can be recovered).

The solutions, create a script to asign all events without category to it of category or create a table with relations of category id --> events id. This is a helpt to solve it.

Only archived events are displayed, and in the frontend, I have to explicitly click to see them; otherwise, I don't see any. This isn't working.
Am I the only one with this problem?
The categories are correct now. I had another installation where the categories were correct but with the same problem addressed here, so I didn't prioritize fixing it initially; now it's fixed — without improvement, as feared   The incorrect category assignment is probably an import error with the CSV files: they were correct after the third attempt, but the first time they were mixed up. However, this has nothing to do with my main problem. I used your JEM extra-tool to "delete the data" (only a "1 0 root..." remained in the kat. table) and then re-imported events, cats, etc. 
I want to see events, including past ones. I want to be able to see time windows with specific types of events via extra links. I was able to do this with former JEM. 


BUT
right now, in the first installation (I opened the second one for you), after updating to the latest JEM 4.4.1, I'm getting an error in the frontend when accessing the eventslist-link.


„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 '' at line 3

 # Function Location

1. 1 () JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:138
2. 2 mysqli->prepare() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:138
3. 3 Joomla\Database\Mysqli\MysqliStatement->__construct() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:972
4. 4 Joomla\Database\Mysqli\MysqliDriver->prepareStatement() JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:1780
5. 5 Joomla\Database\DatabaseDriver->setQuery() JROOT/templates/cassiopeia_child1/html/com_jem/eventslist/responsive/default.php:53
6. 6 include() JROOT/libraries/src/MVC/View/HtmlView.php:416
7. 7 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:204
8. 8 Joomla\CMS\MVC\View\HtmlView->display() JROOT/components/com_jem/views/eventslist/view.html.php:217
9. 9 JemViewEventslist->display() JROOT/components/com_jem/controller.php:115
10. 10 JemController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:730
11. 11 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jem/jem.php:49
12. 12 require_once() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71
13. 13 Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73
14. 14 Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() JROOT/libraries/src/Component/ComponentHelper.php:361
15. 15 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:217
16. 16 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:271
17. 17 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:304
18. 18 Joomla\CMS\Application\CMSApplication->execute() JROOT/includes/app.php:58
19. 19 require_once() JROOT/index.php:51

"Great." A new problem. Everything was better back then!


Does the table mean anything to you?
best, m.



 

Now, the problem is that you have an override of the eventslist view in your template:
JROOT/templates/cassiopeia_child1nwv/html/com_jem/eventslist/responsive/default.php:53

This PHP file hasn't been updated to the latest version of JEM, and its code is obsolete.
Please delete the override and test the eventslist menu again.