Irregularity with Event Attendance

[paulatoma]

Describe the issue
We have been using the platform for less than a year, and I’m still trying to fully understand how it works. However, I’m having difficulty following the logic behind certain functionalities, or it might just be a bug. Specifically, I’m creating events to track attendance, but the reports don’t align with the data we input.

For example, I created an event for November where 26 members attended, and 244 did not, which should total 270 members. However, the event attendance report only lists 18 names for both attendees and non-attendees, with discrepancies in the names shown between the two lists. I also noticed that assigning a family to a member changes who appears on the report, but the number 18 stays the same—it just replaces one name with another based on updates made to the user profile. Additionally, the report seems influenced by membership classifications, but while the names change, the total count remains fixed at 18.

Furthermore, the total members according to the attendance report should add up to 270 (26 attendees + 244 non-attendees), but our people dashboard indicates we have 285 members.

I’ve tried to resolve this issue by following the "how-to" documentation, but I’m still struggling. I need help figuring out what I might be doing wrong.

Collected Value Title	Data
Page Name	/EventAttendance.php?Action=List&Event=5&Type=Saturday%20Service%20-%20Regular%20Meeting
Screen Size	1080x1920
Window Size	956x1912
Page Size	1310x1912
Platform Information	Linux iad1-shared-b8-09 5.15.86-grsec-bnxt-focal+ #1 SMP Wed Oct 11 22:07:10 UTC 2023 x86_64
PHP Version	8.2.26
SQL Version	8.0.28-0ubuntu0.20.04.3
ChurchCRM Version	5.12.0
Reporting Browser	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36 Edg/131.0.0.0
Prerequisite Status	All Prerequisites met

[justinkoby]

I'm having the same issue. I'm testing the software and checked in 10 members for last week's service. When I go to Event Attendance Reports, and select the type of event, It shows 10 members attending in the grey box to the right. But, when I click on that "10 members" box, the report only includes 8?

[justinkoby]

Oh, I found my issue and it may be similar to the original issue. One of my names had parenthesis ( ) in the name. That broke the SQL script.

@paulatoma Do any of your names have apostrophes or parenthesis in the name?

Well, never mind. Today, I checked in 17, but the report shows 1

[MCCMorgan]

When I have issues with updated information not showing up correctly I clear out the cache on the shared server. The database was updating but the cache was holding onto the old data after I hit save. For me it is under the cpanel speed menu and dynamic caching. That forces the page to grab the new data and update the calculations. I did add /churchcrm/* to the do not cache this URL list and that seemed to work but still had some
Issues last night so was just hitting the servers clear cache button whenever I updated an existing value.