|
SBANE Webmaster
|
July 24, 2013 at 5:22 am
WP 3.1, EE 3.1.33.3P Business License, recent upgrade from 3.0.19.b20
After recently upgrading EE, we noticed that inidividual Attendee meta data isn’t visible anymore. All the attendee records display properly when viewing the Attendees Report, but when you click on an individual name, there is no information below the header label “Registration Information [ Primary Attendee Record ]”.
Looking at the database, it appears that attendee meta data is now stored in the new table wp_events_attendee_meta. Registrations that occurred on our site after the upgrade have records in this table, and the individual attendee data displays correctly.
Is there an upgrade script I can run to create records in the new table for existing records in the wp_events_attendee table?
Thanks in advance,
Erik
Erik Domingo
|
|
Josh
|
July 24, 2013 at 6:40 am
Hi Erik,
I’m afraid there isn’t an migration script for updating from 3.0.x to 3.1.
|
|
SBANE Webmaster
|
August 3, 2013 at 9:20 am
I understand – can I use the SERIALIZE() function in the code now to manually insert the records? I understand I may have to manipulate the data coming from the events_attendee table first…
|
|
Sidney Harrell
|
August 5, 2013 at 11:24 am
It may be easier than that. This is the sql getting the attendee id to pull the data for the edit attendee record admin screen:
$SQL = "SELECT id FROM " . EVENTS_ATTENDEE_TABLE . " WHERE registration_id =%s AND is_primary = 1 ";
I believe that “is_primary” field is new to 3.1. It may just be a matter of going through your old records and adding a 1 to that field for your primary attendees.
|
|
SBANE Webmaster
|
August 5, 2013 at 11:44 am
Thanks for the idea – one question, though – how do I identify primary attendees from older records?
|
|
Dean
|
August 6, 2013 at 3:25 am
OK, so I tested this out on the closest version I have to yours, version 3.0.19.P.41.
Using a free event as a base, the Primary registrant has a status of Completed but the additional attendees have an Incomplete status.
Obviously this is 100% as it’s possible primary attendees didnt pay for an event and are therefore incomplete, but it gives a place to start.
One other way to at least group them, is to check the registration_id. If it is a group booking then that ID will be the same for each attendee as they are lumped together with the primary attendee. So if there are five people with the same ID and one is Completed, thats your Primary attendee.
|
