|
mattsmithmba
|
June 7, 2019 at 11:35 am
Greetings! We are showing that attendees are registering for our events, however, the actual names of the attendees are no where to be found.
I am showing screencaps from our “Event List” which reveals we have 7 attendees.
https://www.dropbox.com/s/uq7k0oktn556fkg/event-espresso-call-event-list.png?dl=0
Then I view attendees for that same event, and we have names of those 7 registered attendees:
https://www.dropbox.com/s/ie0t2ta48az8xly/event-espresso-call-event-attendees.png?dl=0
|
|
Josh
|
June 7, 2019 at 12:12 pm
Hi,
There could be a number of reasons the list is empty on that one page, it’s likely a filter part of the query that’s not correct in this case.
On the first screenshot, do you see the column that says “6/75”? What happens when you click on that?
|
|
mattsmithmba
|
June 7, 2019 at 3:11 pm
Josh,
The same thing happens. No attendees are in the list. Here’s a video screencap of what happens when I look for attendees on a few different events.
https://www.dropbox.com/s/mbmuvhm7pg3ih2c/event-espresso-attendees.mov?dl=0
Thank you for your help!
Best,
Matt
|
|
Josh
|
June 7, 2019 at 6:36 pm
Does that site have the current version of Event Espresso 3? (3.1.37.14) If not, you can update to the current version before proceeding to the next troubleshooting step.
Also, may I ask was the site migrated from a live site to staging?
If that’s a staging site you could deactivate all other plugins to rule out a plugin conflict.
|
|
mattsmithmba
|
June 10, 2019 at 2:41 pm
Josh – Thank you for the quick response.
1) I will check our version of EE
2) I will deactivate on stating to see if there are plugin conflicts.
Be back soon!
Matt
|
|
mattsmithmba
|
June 10, 2019 at 3:14 pm
Version of EE: 3.1.37.14.P
Also, here is a video screen cap that shows me de-activating plugins.
https://www.dropbox.com/s/yhhh0f3tdfg3lqp/event-espresso-plugins.mov?dl=0
No luck in finding our attendees. Any ideas?
|
|
Josh
|
June 10, 2019 at 3:19 pm
I’m still curious to know if the site’s data was migrated over from another site, which if that’s the case then maybe not all the database tables were transferred over?
One other thing you could do is try a registration for an event. After you test a registration, does it still say No records found?
|
|
mattsmithmba
|
June 10, 2019 at 3:52 pm
Josh,
Here’s a video screencap giving a click-through of our production website. In short, it’s the same issue with no attendees.
https://www.dropbox.com/s/rev3y9v41pn68pz/event-espresso-click-through-of-live-website-same-issues.mov?dl=0
Best,
Matt
|
|
Josh
|
June 10, 2019 at 3:55 pm
Hi Matt,
I’m afraid the video does not answer either of my questions. Those are:
Was the site’s data was migrated over from another site?
and
After you test a registration, does it still say No records found?
|
|
mattsmithmba
|
June 10, 2019 at 3:58 pm
1) Yes, 100% of the site’s data / tables were migrated from Production > Dev.
2) Yes, on Friday of last week, we did an internal test of event registration Production website. The number ticked up by 1 attendee. But none of our attendee information showed up.
|
|
Josh
|
June 10, 2019 at 4:30 pm
Can you check the server’s PHP error log for anything logged at the moment you tried to load the attendees page? It seems the data is there or the attendee count would show 0, but something is preventing the records to be retrieved in that view.
|
|
mattsmithmba
|
June 10, 2019 at 4:37 pm
This reply has been marked as private.
|
|
Josh
|
June 10, 2019 at 5:00 pm
The error:
WordPress database error Table 'wp_callphx.wp_events_attendee_checkin' doesn't exist for query
is the problem. For some reason your site does not have a wp_events_attendee_checkin table, but it’s trying to query to that table.
What you could try is comment out line 101 of includes/event-management/queries.php
which is
$SQL .= $ticketing_installed ? ', ac.date_scanned, ac.checked_in ac_checked_in' : '';
That should prevent the database error and allow the query to work.
|
|
mattsmithmba
|
June 10, 2019 at 5:06 pm
Thanks for the quick response! I’ll setup FTP credentials and FTP down the file and get to work.
Thanks again!
|
|
mattsmithmba
|
June 10, 2019 at 5:38 pm
Josh,
I couldn’t fid the code that you noted in the post above.
Here is a screen cap of the PHP code, you can see line 101 at the bottom of the screen.
https://www.dropbox.com/s/pr23v1bxvweq1wf/event-espresso-quiriesPHP.png?dl=0
Here is the PHP:
https://www.dropbox.com/s/wli8dco2ndaj5xx/queries.php.zip?dl=0
Best,
Matt
|
|
Josh
|
June 10, 2019 at 7:27 pm
Hey Matt,
In one of your earlier screen videos at around 00:36 in your plugins page showed a copy of Event Espresso that was version 3.1.21. I think you’re editing that one. You’ll need to make the edit to the newer version (3.1.37.14.p) because that’s the version that’s activated on your site at the moment.
|
|
Josh
|
June 11, 2019 at 8:24 am
Update:
My colleague Tony did some checking through the code and found that a custom ticket template located in /wp-content/uploads/espresso/ticketing/ would cause the additional SQL part involving the attendee check-in table to be included in the query.
It appears that your site has an unused custom ticket template, which along with not having the ticketing add-on tables, would cause the error.
So what you could do instead is FTP in to /wp-content/uploads/espresso/ticketing/template.php and delete that template.php file. Once that file is gone your attendees list query should no longer have an error.
|
|
mattsmithmba
|
June 11, 2019 at 12:19 pm
Tony was right! *redacted*
-
This reply was modified 5 years, 5 months ago by
 Josh. Reason: GDPR
|
|
Josh
|
June 11, 2019 at 12:30 pm
Thanks for the update. I’ve redacted the link to the screenshot since it appears to include personal identifiable information.
|
|
mattsmithmba
|
June 11, 2019 at 12:34 pm
Oh thank you Josh. Actually those attendees was my crew testing the function. But thank you for the courtesy.
|
