|
CCCNZ
|
March 11, 2017 at 8:29 pm
Hi,
We are reformatting our EE4 environment & want to delete all previous data back to initial installation).
I tried “Permanently Delete ALL Event Espresso Tables and Data” including deleting & reinstalling the EE4 Core.
However, Registrations & Transactions failed to be deleted and still remain.
All Transactions report:
Primary Registrant “No contact record, because the transaction was abandoned or the registration process failed.” and
Event “The event associated with this transaction via the primary registration cannot be retrieved.”
Please help?
Cheers,
Chris
|
|
Josh
|
March 13, 2017 at 11:31 am
Hi Chris,
The script that deletes those tables may have timed out. Can you try running it again? Then after you try, you can look in the database with PHPmyadmin and verify that all of the tables that have the _esp_ are removed.
|
|
CCCNZ
|
March 17, 2017 at 10:17 pm
Hi Josh,
I tried this again – the script isn’t completing by the fact that the tables remain.
I’ve deleted EE & its extensions & 39 CCHG_ESP_* tables remain.
Can I drop these tables, then reinstall EE & its extensions?
Are there any other WP tables that need to be updated?
Cheers,
Chris
|
|
Josh
|
March 20, 2017 at 11:26 am
Hi Chris,
The options table for one will need to be updated, but all of that should happen automatically from the Event Espresso > Maintenance > Reset page. Can you activate WP_DEBUG and set up logging before running the Reset script? There may be an error preventing the script from deleting all of the tables.
|
|
CCCNZ
|
March 21, 2017 at 2:21 pm
Hi Josh,
Performed the following:
1. switch WP to Debug mode
2. Event Espresso > Maintenance Mode > Reset/Delete Data
3. Reset Event Espresso Tables
4. Permanently Delete all Event Espresso Tables and Data
5. Check to see if the script from 4 has dropped the 39 CCHG_ESP_* tables
6. Save the WP debug log to dropbox & send me the link
7. switch WP to non-Debug mode
Results:
All EE tables were deleted except the following 3:
· *_esp_event_mailchimp_list_group: 3 records and all set to -1
· *_esp_event_question_mailchimp_field: Empty table
· *_esp_people_to_post: Empty table
Do you want these tables manually dropped?
Anything else to check?
DEBUG logfile follows (there’s plenty of good oil in there):
[21-Mar-2017 09:13:20 UTC] PHP Notice: Undefined variable: next_db_state in
-
This reply was modified 7 years, 9 months ago by
 Josh. Reason: removed logs containing server information
|
|
Josh
|
March 22, 2017 at 8:57 am
Hi again,
This error may be the reason why the script didn’t complete:
[19-Mar-2017 04:28:26 UTC] PHP Fatal error: Class \’EE_Registry\’ not found in /wp-content/plugins/Odered_EE_Upcoming_Events_Widget/Odered_EE_Upcoming_Events_Widget.php on line 33
Before you run the script that deletes the tables, you should deactivate your custom widget plugin. A fatal error like that prevent the script from finishing. I’d add it’d also be a good idea to add some error proofing before you call the EE_Registry class and do an class_exists check. This way you’ll avoid fatal errors when the site is put into maintenance mode or Event Espresso core happens to be deactivated for any reason.
|
|
CCCNZ
|
March 24, 2017 at 7:15 pm
Hi Josh,
Ta for that & I’ve passed those details onto our technical guru.
However, need to know what our next steps are with the remaining 3 tables:
All EE tables were deleted except the following 3:
· cchg_esp_event_mailchimp_list_group: 3 records and all set to -1
· cchg_esp_event_question_mailchimp_field: Empty table
· cchg_esp_people_to_post: Empty table
Do you want these tables manually dropped?
Anything else to check before reinstalling EE?
Cheers,
Chris
|
|
CCCNZ
|
March 25, 2017 at 3:19 am
Hi Josh,
An update – all sorted. We deleted the 3 remaining tables and Event Espresso folder.
EE core reinstalled without any errors.
Cheers, Chris
|
