|
Allen
|
September 12, 2020 at 9:14 am
I don’t know what or how this happened (maybe when WordPress updated?) – but my current events have simply vanished! I have over 1500 people registered in a series of events (8) and they have all disappeared! https://superbilliardsexpo.com/events/warmup2020/
https://superbilliardsexpo.com/events/open2020/
(there are several others)
The links to the events pull up 404 errors, and all the entries show “No Associated Event” in the Event column in the Registrations dashboard
THIS IS A MAJOR PROBLEM! I can still tell what event someone paid for by the Ticket Price, and I can still see Event Date
I need help with this asap please! If I have to open a ticket and pay someone to fix this, I will — I just need help!
|
|
Tony
|
September 14, 2020 at 5:27 am
Hi there,
From this:
The links to the events pull up 404 errors, and all the entries show “No Associated Event” in the Event column in the Registrations dashboard
And the fact that events are no longer available on the front end it sounds like the Event Posts have been removed from the database.
EE events are a custom post type within WordPress, meaning they ‘live’ in the wp_posts table along with all of your other posts. A WordPress update should never remove posts from that table and EE can’t remove events that have ‘related date’ (registrations, payments etc).
Are you the only user with admin access?
Did you create a backup of the site before you run the updates? Or, as you don’t know if this happened at the same time of the updates, have known good database backup from before this happened?
I can see using the REST API on your site that there are EE events from 2019 and a test event so there are some EE events within the DB, which is even stranger as if this was something automated I’d expect all of the EE events to have been removed.
|
|
Allen
|
September 14, 2020 at 6:48 am
I agree, it is very bizarre indeed. I had a malware attack, and my host (Flywheel) scrubbed the site and removed malware. Could that have caused the situation somehow?
|
|
Allen
|
September 14, 2020 at 6:54 am
And is there a way to get them back into the events as they were sorted before? I have entries associated with each event – and I can see them labeled by the “Price” column in the Registrations dashboard (thankfully)
|
|
Tony
|
September 14, 2020 at 8:27 am
I agree, it is very bizarre indeed. I had a malware attack, and my host (Flywheel) scrubbed the site and removed malware. Could that have caused the situation somehow?
If they’ve gone in and randomly removed posts from the wp_posts table then yes.
You’ll also have problems if they’ve been altering any other tables if they’ve broken any relationships (like it sounds like they have here).
Did they send you a report of what they actually did during the above?
And is there a way to get them back into the events as they were sorted before? I have entries associated with each event – and I can see them labeled by the “Price” column in the Registrations dashboard (thankfully)
Not easily no, those records there were removed from the database need to be restored.
Do you have a database backup from shortly before this happened?
|
|
Allen
|
September 14, 2020 at 5:51 pm
okay, I may have this figured out…
I did a restore from backup, prior to the site being infected with malware. All Events are there.
Part of the process o removing malware, my host suggested I update all plug-ins and themes, and remove un-used, etc.
Also, they suggested I update Admin passwords. While doing so – I found 2 old unused Admin accounts, and I deleted them.
So – after the restore, I found my events (yay) and then took all these steps again … no problems after updating and removing the plugins/themes. BUT – after deleting unused Admin accounts – the events were gone again!
SO – my theory, and hoping you can confirm (just to set my mind at ease, and maybe help someone else) is that one of those Admin accounts must have created the Events. So, when I deleted the Admin account, the events went away with it?
Would that be a possible cause and effect? The whole thing is just baffling me, and I don’t want it to happen again – so, hoping you can confirm!
Thanks so much!
|
|
Tony
|
September 15, 2020 at 3:33 am
SO – my theory, and hoping you can confirm (just to set my mind at ease, and maybe help someone else) is that one of those Admin accounts must have created the Events. So, when I deleted the Admin account, the events went away with it?
Yes, that is likely the problem.
When you delete a user account WordPress asks you what you want to do with its related content, if you clicked Delete then that explains it, example:
https://monosnap.com/file/vUi6y89RD28QJmUjmdewgY19KGeVHS
If you are going to delete the user accounts you’ll need to assign the content to another admin/user to prevent posts (and/or Events) from being removed.
You can confirm if those users accounts are set as the author by editing the event and checking which account is set in the author section, if its one of the accounts you deleted last time, then yes, that’s the problem.
|
