Hi there

I had a recent issue with the number of actual events not matching up with the numbers next to the event categories in the 'All Events'. That problem was fixed and it happened again.

It appears that when you create an recurring event with numerous dates, then go back and delete each of the dates (series 1, 2 etc) within that one event, it throws the numbering out.

I can see this being an issue as the number of members increases and members are wanting to create recurring events, so I have switched off that option within the event settings.

Please could you amend the number of events next to two event categories. 'Classes, courses and workshops' shows 8, but it should be 7. 'Health, fitness and wellbeing' shows 14, but it should be 13.

Please could you also advise me how to fix this problem, in case it happens again in the future.

Regards

Michael

Hi, Michael.

I assign developer to this thread.

Hi Michael,

this is a valid bug. please wait for the fixes.

Regards,
Albert

Hi Albertus

Thanks for acknowledging this as a valid bug and I look forward to the fixes before re-activating the recurring event setting.

In the meantime, can you adjust the numbers next to the 'All Events' in the two categories I originally mentioned, to reflect the correct number of events in those two categories..

I appreciate your help.

Michael

Hi Michael,

please try this fixes:
1. edit /components/com_community/models/events.php line 598:
2. changing this code

$query = "SELECT c.id, c.parent, c.name, count(e.id) AS total, c.description
		  FROM " . $db->quoteName('#__community_events_category') . " AS c
		  LEFT JOIN " . $db->quoteName('#__community_events') . " AS e ON e.catid = c.id
					AND e." . $db->quoteName('published') . "=" . $db->Quote('1') . "
					AND	e." . $db->quoteName('enddate') . " > " . $db->Quote($now->toSql()) . "
		  GROUP BY c.id
		  ORDER BY c.name";

$query = "SELECT c.id, c.parent, c.name, count(e.id) AS total, c.description
		  FROM " . $db->quoteName('#__community_events_category') . " AS c
		  LEFT JOIN " . $db->quoteName('#__community_events') . " AS e ON e.catid = c.id
					AND e." . $db->quoteName('published') . "=" . $db->Quote('1') . "
					AND	e." . $db->quoteName('enddate') . " > " . $db->Quote($now->toSql()) . "
                                        AND e." . $db->quoteName('parent') . " = " . $db->Quote(0) . "
		  GROUP BY c.id
		  ORDER BY c.name";

Thanks Albertus

I'm not that confident in changing code, so I might wait until the bug fixes are released.

Once the bug fixes are released, will that automatically adjust the numbers I currently have on the site, to reflect the actual number of events, without me having to do anything further?

Michael

HI Michael,

if the fixes are released, after upgrade process you dont need do anythings. the event number will reflect actual number.

Regards,
Albert

Thanks Albert

I look forward to the release.

Michael

Hi, Michael.

Please provide us with working administrator credentials.
I can't login to your site backend.
Please, edit your first post and add credentials to corresponding fields.