|
dmartin1
|
April 3, 2014 at 1:23 pm
We upgraded our version of Event Espresso yesterday and these are new issues we are having today.
While viewing All Attendees in the Event Overview section the filters do not seem to be working correctly. I am trying to filter all attendees with an Incomplete payment status (which I know there are a handful) and I cannot get it to filter correctly. Also, I can’t get a view that shows all attendees currently in the database. Last, when I try to export All Attendee Data it is pulling in events and attendees that were deleted yesterday, but those events are not visible within the website view.
Wordpress Version: WP 3.8.1
Event Espresso Version: 3.1.36.4.P (Version was upgraded yesterday and no add-ons currently in use.)
|
|
Jonathan Wilson
|
April 3, 2014 at 2:22 pm
Hi Amy,
I logged into your site and I can’t get any Incomplete registrations to show either. I did an export of all attendee data, which is essentially a database dump into an Excel spreadsheet, and no incomplete registrations appear in the spreadsheet either. Is it possible that one of the site admins changed the status?
Also, which events and attendees aren’t supposed to be showing in the export?
|
|
dmartin1
|
April 3, 2014 at 3:06 pm
I am actually able to see the Incompletes in the spreadsheet when I sort the pay status column. There are 6 incompletes and 1 payment declined. I have been able to successfully manipulate the filters to show the incompletes but not easily, only if I filter by the month that the event took place. This is difficult because we don’t technically know who is incomplete and it would be helpful if we could filter by this status only to show all incompletes from the database.
There are actually a lot of events in the spreadsheet that have been deleted from within the site. I have the spreadsheet that downloaded for me. Is there a way for me to send this to you? There are too many events to list (210 total) but I created a second sheet to show all the events highlighted in yellow that have been deleted in the past, even some were deleted before yesterday. For these events I also had deleted all attendees associated with the event.
Please let me know if you need further information.
|
|
Jonathan Wilson
|
April 3, 2014 at 3:57 pm
AH, I see. Sorry for the misunderstanding. I now see the incomplete registrations in the export. If you have alot of attendees, and the majority of them are complete, then you will need to select the individual month in order to view the incomplete registrations.
Attendees should not appear in the export once they have been deleted in the dashboard. This issue could likely be caused by some caching on the server. Your host would be able to answer the question of whether they cache the database. However, you can delete the entries from the wp_events_attendee table in the database. I recommend that you backup the database prior to making any changes to the database.
|
|
dmartin1
|
April 4, 2014 at 8:46 am
So there is not a way to view all attendees from the database (regardless of pay status or month)? When I do not have a month or category set and the status set to “Show All Completed/Incomplete” it pulls a list of completed payments but does not include any incompletes. Is there a number that is considered a lot of attendees?
On the other hand, I noticed that the attendees number tends to vary based on how the event filter is set. Sometimes, if I have the event filter status set to “ALL (Active/Inactive)” and then I view the attendees and set it to “Show ALL Completed/Incomplete” it pulls all the events (including previously deleted ones – 270) and all attendees (along with deleted ones – 7,478). When this happened I was able to pull up an incomplete payment from that large list, not through filtering but by live search. But, I can’t always reproduce the numbers with the same filtering. Once I change a filter, the numbers jump. I try to reset the filters back the same way mentioned above and the events go to 25 (the actual correct number that I have on the site) and all attendees goes to (837). If I change the filter status to just Incomplete the Events number jumps to 6 and the All Attendees Number jumps to 140 but does not pull any incomplete unless I filter by month. I hope this all makes sense, I am just trying to give more insight into what seems like odd filtering behavior to me. I am hoping for a more precise and consistent way to pull all incomplete payment statuses so that none are missed.
We are self hosted and my director is checking to see if the server is caching. If this is the case, is it recommended that we do not cache the database? Also, if it is caching, each time I delete an event would I need to also manually delete it from the table in the database?
|
|
dmartin1
|
April 4, 2014 at 9:03 am
For clarification on the caching are you referring to WP caching or the MySQL query caching (or some other type of caching)?
|
|
dmartin1
|
April 4, 2014 at 9:44 am
Just found out more info regarding caching: We don’t use WP caching and the query cache is disabled.
|
|
Sidney Harrell
|
April 4, 2014 at 1:48 pm
I think I see what is going on now. The 2014 Ski Trip Helmet Rental event, for example, has a registration start and event start date of 3-17. The end date is 3-28, but the registration end date is 4-14. So it does not show up under the active events, so it does not show the attendees in the list initially, which is for attendees of active events. If your events dates are set up so that chronologically they go registration start, registration end, event start, event end, I think you’ll have a much easier time.
|
|
dmartin1
|
April 7, 2014 at 8:07 am
Thank you both for your time in troubleshooting this issue. I will keep an eye on our events to keep this practice moving forward. We sometimes have to reopen past events for payment, as is the case for the above example, but most events I try to setup in this order. I understand why this would cause certain events to not filter in, but I still can’t figure out why the filtering is inconsistent. Sometimes the All (Active/Inactive) status filter will show 26 events and other times only 7. Maybe it is also because of the issue with the database not properly deleting entries when they are deleted from the dashboard. I will keep working to find how to manipulate the filters to see the data I need.
|
