|
Esports
|
August 12, 2016 at 9:52 am
Hello,
We are having an issue where people are paying on event espresso that are not showing up on our backend.
We are taking participants money without them being registered on our website, so we do not know where the money is coming from and for who.
This is a reoccurring issue this week.
Thank you
|
|
Josh
|
August 12, 2016 at 11:42 am
Which payment method are you using? Is there caching set up on this server?
|
|
Esports
|
August 12, 2016 at 11:45 am
Using World Pay. We had a cache plugin setup on the site called Hyper Cache Extended which I’ve now deactivated thinking that it may be an issue but not sure. Not sure about the server itself.
|
|
Tony
|
August 12, 2016 at 12:03 pm
Can you check with your hosting provider to confirm if they have server side caching enabled please.
Are users making multiple registrations on the site?
For example paying for Event A and then clicking back to pay for Event B?
|
|
Esports
|
August 12, 2016 at 12:12 pm
I will find out from the server about the caching.
A couple of weeks ago one registrant had registered their self but went back on to register 3 others. The payment from World Pay came thru for all the registered people but none of their info is in EE. This has now happened a few more times.
|
|
Tony
|
August 12, 2016 at 12:15 pm
If when they do that that use the browsers back button they can overwrite their previous registration with the next one, EE displays warnings for this when the back button is clicked.
Can you link me to the event so I can take a look?
|
|
Esports
|
August 12, 2016 at 1:25 pm
Not sure what they did and can’t find out. All they know is they registered and paid for the event. Can’t go back to them now.
I believe this was the link… http://chn.animalhealthasia.com/event-registration/?ee=5
Attached is a graphic showing 3 people that were registered at once, payment was received but no details in EE
http://animalhealthasia.com/hypfiles/uploads/2016/08/C7HI_G3SUCKCNFU.png
This other attachment occurred today…
http://animalhealthasia.com/hypfiles/uploads/2016/08/Screen-Shot-2016-08-12-at-3.23.35-PM.png
|
|
Josh
|
August 12, 2016 at 1:32 pm
Hi Terry,
We can look into this a bit further if you can re-send the redeem a support token form, and when you do, you send WordPress admin level credentials (the ones you sent earlier appear to be subscriber level), as well as FTP access so we can check the logs.
|
|
Esports
|
August 12, 2016 at 2:13 pm
This has been done.
|
|
Josh
|
August 12, 2016 at 2:25 pm
Hi Terry,
Is there a way you can get those FTP credentials? The reason I ask is because we can check the logs with FTP. Both of the forms you sent did not include FTP information, so we’re really limited to what we can look though.
|
|
Josh
|
August 12, 2016 at 2:44 pm
One thing that’s evident from looking over the attendee list table in the admin is there are gaps in the Attendee ID sequence. I doubt that someone is actually going through and deleting attendees, so what may have happened was the caching was serving up older sessions, so registration would overwrite the a prior registration session. Have any registrations gone missing since the caching plugin was deactivated?
|
|
Esports
|
August 12, 2016 at 3:31 pm
Have not heard anything from the client about any further missing registrations. Due to the time difference I may not here anything til over the weekend or Monday. I’ll have to have this monitored over the weekend.
|
|
Esports
|
August 12, 2016 at 3:36 pm
Also are you now certain that those registrations are not somewhere in the db of the site.. either the http://animalhealthasia.com or http://chn.animalhealthasia.com?
|
|
Josh
|
August 12, 2016 at 3:52 pm
We’d need access to the database in order to confirm, but I doubt they are.
|
|
Esports
|
August 14, 2016 at 9:16 am
Can you go ahead and access the database thru cpanel with the info I sent you. What other info do you need for this?
|
|
Esports
|
August 14, 2016 at 8:48 pm
Heard back from the server support and there is no server side caching enabled on their server.
|
|
Josh
|
August 15, 2016 at 10:02 am
Hi Terry,
I’m looking over the two databases between the two sites and it looks like some of the attendee information was copied over from Site 1 to Site 2. For example, if you go into your cpanel’s phpmyadmin and look at the wp_2_events_answer table, you’ll only see records for attendee ID’s 119, 120, 121, 124, 131, and 132, which are the most recent. That’s 6 attendees, starting with ID 119 and ending with ID 132.
Then you look in the wp_2_events_attendee table, there are 22 attendees starting with ID 94 and ending with ID 132.
Then you look in the wp_events_attendee table (that’s for site 1) and you’ll note that the attendee records from both sites are identical, starting with Attendee ID 116 and lower (115, 114, 133, and so on).
This looks like someone tried to sync the attendee data from site 1 to site 2 at that point, but they did not copy over any of the data from the wp_events_answer table over to the wp_2_events_answer table.
Are you aware of anyone making attempts at trying to sync the attendee data between the two sites? If so, is this continuing to be done?
|
|
Esports
|
August 15, 2016 at 2:52 pm
Hi Josh
No sync is actually happening here. We built site 1 first then need to build site 2 for the 2nd language so we duplicated site 1. So some of the attendees you’re seeing in site 2 are from site 1 (we should of wiped the db after the duplicating the site). I’m not understanding what this has to do with the registrants not being visible. Can you clarify if this has something to do with my current situation?
|
|
Josh
|
August 15, 2016 at 3:15 pm
This might have something to do with your current situation because the database tables on site 2 were incorrectly copied over from site 1. If you had started with a clean database for site 2 instead of a partial copy from site 1 there may not have been any issues with site 2.
|
|
Esports
|
August 15, 2016 at 10:08 pm
Is there a way of correcting the situation at this point? If I remove the attendees from site 2 that are already in site 1, will that resolve things here?
|
|
Josh
|
August 16, 2016 at 9:18 am
I don’t the attendees that were copied over were the issue. What concerns me is the way the various parts of the database were copied over, but not all tables were copied over. So two concerns, the partial data on site 2, and there was also the caching plugin that had been active. Going forward the situation for site 2 might be fine if the caching plugin was causing the issue you reported. You’ll have other issues on site 2 like the attendees with data that is missing, but those are the attendees that were partially copied over from site 1.
|
