|
Daniel
|
May 31, 2023 at 7:29 am
After updating to v5…. NONE of my venue listings are showing!
It seems that v5 changed the way that venues are linked to events and failed to update the data structures.
wp_event_esp_meta.VNU_ID is set to 0 for ALL events. All of the old events still have their data linked to venue rows in a wp_esp_event_venue join row, but none of the v5 template code can find this information anymore so all of the places on the website where venues used to be listed is now blank.
When I go to edit the Event in the Admin UI – the Event is set to “Select an Event”
When I go to my single event page that shows event venue info there is NO info. In order to get it to show again I have to re-select the venue and then Update the event. This is very complicated because we have many venues and many events.
Please advise.
BTW – I had originally posted this as a question about the API but now it is a bug report on the forum because this v5 migration has broken the functionality of the EE website.
https://github.com/eventespresso/eea-rest-api/issues/45
|
|
Tony
|
May 31, 2023 at 8:37 am
Hi Daniel,
Did you at any point update to v5.0.0-5.0.2 or did you update straight to the current version?
You can find your EE activation history within:
Event Espresso -> Maintenance -> System information
Search for ‘ee activation history’ there
Does it list 5.0.0, or 5.0.1, or 5.0.2 there?
|
|
Daniel
|
May 31, 2023 at 11:56 am
Hi Tony! I skipped right to the latest. I think it was 5.0.6.
|
|
Daniel
|
May 31, 2023 at 11:59 am
There are no version numbers but there is a list of dates. These are the last 2.
2023-03-03 14:52:53
2023-05-27 18:53:51
I was deliberately avoiding updating because when I have updated in the past some issues came up. I guess I can’t win! It seems like maybe the migrations made an incorrect assumption that everyone was updating in lockstep?
|
|
Tony
|
May 31, 2023 at 1:11 pm
This reply has been marked as private.
|
|
Daniel
|
May 31, 2023 at 3:59 pm
Thank you! I await further guidance.
|
|
Tony
|
June 1, 2023 at 6:57 am
Ok, so I did some testing with various setups for migrations to kick in and they worked as expected jumping straight to 5.0.6/7
Do you know the specific version you updated from? I’m assuming 4.10.46?
IIRC you are more than comfortable with PHP, so can you run these:
var_dump(get_option('espresso_db_update', []));
var_dump(get_option(EE_Data_Migration_Manager::current_database_state));
var_dump(get_option(EE_Data_Migration_Manager::data_migration_script_option_prefix . 'Core.5.0.0'));
However, you prefer to run them on the site and send me the output?
(For speed I use Debug Bar and Debug Bar console, but any request should work)
I have a plugin that forces the v5 migrations to re-run but I’d like to see how your DB state is set to see why migrations didn’t trigger for you and confirm if that plugin will work.
|
