|
wayne
|
December 28, 2016 at 4:41 pm
Sorry for the xmas timing but i have a new years event expecting to sell up to 1600 tickets. We are using the HD ios app (version 2,4 does not work and assume hd is newer than the other). I have updated setting on my phone to allow for 1000 attendees which seems to work however when we set this to unlimited only 40 attendees show per event. The issue is attendee numbers in ee admin and in the mysql db say there are 694 attendees. (all completed transaction) the ios app says there are only 576 attendees and has not changed even as people are buying. I assume there is a limit issue or db caching issue – we are not using any caching plugins. What are the end points for the app, i have been testing the rest api at https://homelincoln.co.uk/espresso-api/v1/events/170/registrations/ht9qwtgd2d/ but am not sure what else to do. will the other 1100 attendees be rejected?
Thanks
Wayne
|
|
Josh
|
December 28, 2016 at 5:06 pm
Hi Wayne,
Can you check the Event Espresso > API settings in your WordPress admin to see if there are limits set there?
|
|
wayne
|
December 28, 2016 at 5:10 pm
thanks for the speedy reply. limits are all set at 2000 except events which are at 50 in the admin as are the settings in the phone. Does the rest api cache for 24 hours?
|
|
Josh
|
December 28, 2016 at 5:12 pm
No the API add-on does not cache results.
|
|
Josh
|
December 28, 2016 at 5:48 pm
No not really. One thing I suspect is your server might hitting a query limit so it’s stopping at 576 registrations when the app sends the request. That’s one of the improvements that they made in EE4 and the EE4 apps where they were able to add pagination.
|
|
wayne
|
December 29, 2016 at 2:05 am
all ask our server guys, however if I manually query https://homelincoln.co.uk/espresso-api/v1/events/170/registrations/ht9qwtgd2d/?status=approved&limit=700
I get back the required results so am not sure there is a query limit in place
|
|
wayne
|
December 29, 2016 at 7:15 am
I have spoken with our hosting providers and they say there is also no limit. What query does the app do when you have selected the the event – so i can test it here. assuming it is similar to above?
I am assuming there is no limit on the app (574 seems an odd number). I have not got time to convert everything to ee4 and there are features in ee3 that we needed that were not in ee4. We are currently at 750 attendees and I cant afford for other 200 people not to be scanned on the door, or to check manually. If some one scans does it check the db each time or does it check the initial results (574)? –
Happy to provide credentials and ftp details
Thanks
|
|
Josh
|
December 29, 2016 at 8:28 am
It might be best if you can send a copy of the database then we can test/troubleshoot on another server. You can send to support eventespresso.com.
|
|
wayne
|
December 29, 2016 at 10:35 am
Hi
I have uploaded a test server here http://eetest.adigitalengagement.co.uk/
with a recent db. I have checked with the app and new site and get the same results. I will email credentials and ftp. I cant see why its keeps only bring back 576 results. I will also email sql dump
Thanks
Wayne
|
|
Josh
|
December 29, 2016 at 11:32 am
Hi Wayne,
I checked the app on your test server, and the app loads 726 attendees, which is the same number of attendees that get exported to the CSV file report.
Side note, the app didn’t load any attendee data until after I disabled the All In One WP Security plugin.
One thing you can try with the app is go to its settings and increase the timeout setting past whatever its set to now.
|
|
wayne
|
December 29, 2016 at 2:07 pm
odd, i still get 576 when i log into either account? What phone, ios and app are you using?
Thanks for looking into this.
|
|
Josh
|
December 29, 2016 at 2:14 pm
It’s an iPhone 5s, iOS version 10.1.1, and the app is the Event Espresso HD app version 1.6.4, which is this one:
https://itunes.apple.com/us/app/event-espresso-hd/id604494948?mt=8
Did you try changing the timeout settings? Also, have you tried swiping down on the list to force a refresh?
|
|
wayne
|
December 29, 2016 at 3:18 pm
I have deleted the app on my phone and so have a few other admins on their phones. We now have 792 which is closer but the event is saying 828, which we are all getting. timeout setting are at max and have refreshed, wp security disabled.
Is their a possible reason for this disparity? defaults are incomplete so there are no pending but possibly a few refunds. Are refunded tickets added to the attendee list in the app?
|
|
wayne
|
December 30, 2016 at 1:42 am
Sorry for the mass of emails. I noticed that around 36 completed transactions in the db had no first or last name (not sure how they managed to submit the form), I have adde their details to the attendee information by cross referencing the paypal transactions. I thought this may fix disparity but it only added a few extra in the attendee list. Is there anything im missing that need to be added to the db, i.e attendee meta?
W
|
|
Josh
|
December 30, 2016 at 7:43 am
Hi Wayne,
You can run the CSV export of registrations for that event and that will give you the correct total.
|
|
wayne
|
December 30, 2016 at 9:06 am
Hi Josh
I have been exporting and checking the numbers for completed transactions which at the moment is 904, jn the admin it says 904 but on the ipad app and multiple iphone apps its says 865. It still has this 36-39 disparity. The csv and site are saying the same but apps are off. There must be something the app is looking for, for example the json api has registration and attendee queries. I just need to understand the difference numbers.
w
|
|
Josh
|
December 30, 2016 at 10:42 am
The apps for EE3 do not factor in the quantity field of the registration row from the db. So the app is basically only counting the number of completed registration rows in the db. If you view a registration in the app, it will show the Quantity value there.
|
|
wayne
|
December 30, 2016 at 1:39 pm
Cheers Josh, all makes sense now. one last thing, potentially, can the json api queries be tweaked i.e in facadereadfunctions file could $totalItemsInDB = intval($wpdb->get_var(“SELECT COUNT(id) FROM {$wpdb->prefix}events_attendee”));
be replaced with
$totalItemsInDB = intval($wpdb->get_var(“SELECT COUNT(id) FROM {$wpdb->prefix}events_attendee where payment_status =’Completed'” ));
|
|
Josh
|
December 30, 2016 at 5:16 pm
I don’t think so Wayne, the app will still do its own query for registrations.
|
