Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the pue-sales domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home/staging-poc/public_html/wp-includes/functions.php on line 6114

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the better-click-to-tweet domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home/staging-poc/public_html/wp-includes/functions.php on line 6114

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the pue-amazon domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home/staging-poc/public_html/wp-includes/functions.php on line 6114

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the pue-stats domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home/staging-poc/public_html/wp-includes/functions.php on line 6114

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the wordpress-seo domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home/staging-poc/public_html/wp-includes/functions.php on line 6114
How to RESET the database after test registrations? | Event Espresso - Staging Server

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

Viewing 4 reply threads


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.
Viewing 4 reply threads

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.

The original Forum description...

Status: closed

Updated by Armando Gelardi 12 years, 6 months ago ago

Topic Tags

Tagged: ,

Notifications

This topic is: not resolved
Event Espresso - Staging Server