Support

Home Forums Event Espresso Premium How to RESET the database after test registrations?

How to RESET the database after test registrations?

Posted: July 14, 2012 at 4:31 am


Armando Gelardi

July 14, 2012 at 4:31 am

Hi, I need to empty the database of all test registrations made (no more traces of test attendees).

I did some test registrations (on my live site) in order to see if every step of the process works fine. Now before opening registrations to participant I would like to reset the database so I have no “test” attendees registered anymore and can have a clean start.
I only want to reset all ATTENDEE related information.
I have only one event (I understand I could not reset attendee registrations if I would have more than one event).

Is there any function, script or MySQL query I can use for this purpose?

I looked into the database structure (using the Adminer plugin) and I suppose I should empty the following tables:
wp_events_answer
wp_events_attendee
wp_events_attendee_checkin
wp_events_attendee_cost
wp_events_attendee_meta
wp_events_member_rel

Is this correct? Did I miss some tables?

Thanks in advance for any Help!


Seth Shoultes

  • Support Staff

July 14, 2012 at 9:16 pm

Hi Armando,

Those tables look correct. However, you should be able to just delete the attendees using the event admin.


Armando Gelardi

July 15, 2012 at 12:54 am

Hi Seth!

as a fact I did try the “Delete Attendee(s)” function in the event admin, but i deletes attendees only from the wp_events_attendee table.
The other tables still have records with data from these attendee ID’s.

So i think it would be better (in order to have a clean start) to have all “attendee related” data to be cancelled and thus clean all the tables mentioned above. This way I would start with attendee_ID from #1 again and don’t have any related data in the other tables with those same ID numbers I had with my test registrations.

So besides the “Delete Attendee(s)” button in the event admin are there other functions or scripts I could use?

Thanks!


Seth Shoultes

  • Support Staff

July 15, 2012 at 4:58 pm

IF you want the ID’s to start over, you will need to completely delete those tables and reinstall the plugin.


Armando Gelardi

July 16, 2012 at 5:23 am

Ah ok.
So I’ll think about that…
maybe I’ll only clean the tables and forget about starting over with the ID numbering.

Thanks.

The support post ‘How to RESET the database after test registrations?’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Support forum for Event Espresso 3 and Event Espresso 4.
Documentation for EE3 and EE4
Documentation for Event Espresso 3 Documentation for Event Espresso 4

Status: closed

Updated by  Armando Gelardi 8 years, 3 months ago ago

Topic Tags

Notifications

This topic is: not resolved
Do NOT follow this link or you will be banned from the site!
[gravityform id=80 title=false description=false ajax=false]
<div class='gf_browser_unknown gform_wrapper' id='gform_wrapper_80' ><form method='post' enctype='multipart/form-data' id='gform_80' action='/topic/how-to-reset-the-database-after-test-registrations/'> <div class='gform_body'><ul id='gform_fields_80' class='gform_fields top_label form_sublabel_below description_below'><li id='field_80_1' class='gfield gfield_contains_required field_sublabel_below field_description_below gfield_visibility_visible' ><label class='gfield_label' for='input_80_1' >First name<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_text'><input name='input_1' id='input_80_1' type='text' value='' class='medium' aria-required="true" aria-invalid="false" /></div></li><li id='field_80_2' class='gfield gfield_contains_required field_sublabel_below field_description_below gfield_visibility_visible' ><label class='gfield_label' for='input_80_2' >Email address<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_email'> <input name='input_2' id='input_80_2' type='email' value='' class='medium' aria-required="true" aria-invalid="false" /> </div></li><li id='field_80_3' class='gfield gfield_contains_required field_sublabel_below field_description_below gfield_visibility_visible' ><label class='gfield_label' >GDPR Agreement<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_checkbox'><ul class='gfield_checkbox' id='input_80_3'><li class='gchoice_80_3_1'> <input name='input_3.1' type='checkbox' value='I consent to have this website store my submitted information so they can respond to my inquiry.' id='choice_80_3_1' /> <label for='choice_80_3_1' id='label_80_3_1'>I consent to have this website store my submitted information so they can respond to my inquiry.</label> </li></ul></div></li><li id='field_80_4' class='gfield gform_validation_container field_sublabel_below field_description_below gfield_visibility_visible' ><label class='gfield_label' for='input_80_4' >Email</label><div class='ginput_container'><input name='input_4' id='input_80_4' type='text' value='' autocomplete='off'/></div><div class='gfield_description' id='gfield_description_80_4'>This field is for validation purposes and should be left unchanged.</div></li> </ul></div> <div class='gform_footer top_label'> <input type='submit' id='gform_submit_button_80' class='gform_button button' value='Download Now' onclick='if(window["gf_submitting_80"]){return false;} if( !jQuery("#gform_80")[0].checkValidity || jQuery("#gform_80")[0].checkValidity()){window["gf_submitting_80"]=true;} ' onkeypress='if( event.keyCode == 13 ){ if(window["gf_submitting_80"]){return false;} if( !jQuery("#gform_80")[0].checkValidity || jQuery("#gform_80")[0].checkValidity()){window["gf_submitting_80"]=true;} jQuery("#gform_80").trigger("submit",[true]); }' /> <input type='hidden' class='gform_hidden' name='is_submit_80' value='1' /> <input type='hidden' class='gform_hidden' name='gform_submit' value='80' /> <input type='hidden' class='gform_hidden' name='gform_unique_id' value='' /> <input type='hidden' class='gform_hidden' name='state_80' value='WyJbXSIsIjBiNjdjZjkyMDUzOWUxOWY5Y2NiZjIwMzM4YjA1Mjk4Il0=' /> <input type='hidden' class='gform_hidden' name='gform_target_page_number_80' id='gform_target_page_number_80' value='0' /> <input type='hidden' class='gform_hidden' name='gform_source_page_number_80' id='gform_source_page_number_80' value='1' /> <input type='hidden' name='gform_field_values' value='' /> </div> </form> </div><script type='text/javascript'> jQuery(document).bind('gform_post_render', function(event, formId, currentPage){if(formId == 80) {} } );jQuery(document).bind('gform_post_conditional_logic', function(event, formId, fields, isInit){} );</script><script type='text/javascript'> jQuery(document).ready(function(){jQuery(document).trigger('gform_post_render', [80, 1]) } ); </script>
[i]
[i]