|
Leland Zaremba
|
January 16, 2013 at 10:03 pm
Updated from 3.1.28.xx version to most recent version with 400+ events. Looks like the previous selections for venue and staff are missing after update. Staff and venues are still present in EE but no longer associated with events. Has this been discovered as an issue? Can this be fixed in db?
|
|
Dean
|
January 17, 2013 at 4:44 am
Hello Leland,
No we have not come across this before. What version of Event Espresso did you update from?
It can be fixed in the database but I cant see it being any quicker than doing it manually in the admin as the events will need to have the staff and venue ids matched up to the event ids in both the events_personnel_rel and events_venue_rel tables.
|
|
Leland Zaremba
|
January 17, 2013 at 9:56 am
Hey Dean,
3.1.28.4.P was the previous version. What can I do to see how this happened or possibly fix it without manually updating the events. My admin is going nuts about it.
|
|
Dean
|
January 18, 2013 at 3:31 am
Hi Leland,
The only way to see how it happened would be to try and recreate the circumstances, but we have honestly never heard of this before, so I am wondering if it is an individual case, as we have had a lot of people updating from 3.1.28.X already.
From what I can understand of the issue, I cant see any easy way to resolve it other than manually. If there is some sort of pattern to how the staff/venues are allocated you could possibly write an sql script to add the ids to the appropriate tables, but it may take just as long depending upon the structure you have in place.
|
|
Leland Zaremba
|
January 18, 2013 at 10:53 am
Upon further inspection this is only happening with staff associations. Venue data seems to be fine.
|
|
Seth Shoultes
|
January 18, 2013 at 10:57 am
Leland did you create a backup of the database before updating?
|
|
Leland Zaremba
|
January 18, 2013 at 11:29 am
Yes,
We have a staging site with a backup of everything pre-upgrade. I am poking around on that site now. I may attempt a fresh update there to see if it happens again.
|
|
Seth Shoultes
|
January 18, 2013 at 11:32 am
Cool. Don’t forget to create a backup of that DB before doing so 🙂
As far as I know, nothing has changed staff manager in a long time.
|
|
Leland Zaremba
|
January 18, 2013 at 11:48 am
My thoughts too. Using WPengine so they take care of the staging nicely.
|
|
Leland Zaremba
|
January 18, 2013 at 3:54 pm
Making progress!
On the event edit screen we see this under the Staff box:
“Please add at least one person.”
However we DO have 10+ staff members already entered and they display just fine on the actual staff management page. It seems the edit event page is not correctly querying that data for some reason. Who should I contact with server creds to look at the install using a support token?
|
|
Seth Shoultes
|
January 18, 2013 at 4:04 pm
Any way to turn on debugging on this server? You can send the info to support or myself. We’ll need FTP access too.
|
|
Josh
|
January 18, 2013 at 5:01 pm
Hi Leland,
Which admin user account entered the staff entries into the system? With R&P active, the admin account that entered them into the system is the one that can assign their staff to their events.
You can change the wp_user id for the staff that are affected in the _events_personnel table to the wp_user ID that is managing the staff/events and that should fix it.
|
|
Leland Zaremba
|
January 18, 2013 at 5:38 pm
Sneaky.
I’ll look into that now.
|
|
Leland Zaremba
|
January 18, 2013 at 5:46 pm
Josh!
Well done. Consider it resolved. The WPengine hosting assigned the user_id 1 to a master wpengine user which was not our Admin user account. Fixed and working.
|
