Support

February 12, 2020 at 9:48 am

When I install the Mailchimp addon it needs to update my database. During the process the database update fails, so now none of my events are showing and the main EE4 plugin is not working either. The only solution I have found is to update with default settings which loses all my event data.

Here is the error:
Could not migrate old row {“id”:”1″,”event_id”:”2″,”mailchimp_group_id”:null,”mailchimp_list_id”:”d6c4e45e4b”} because there is no new event ID for old event with ID 2
Received error “Column ‘EVT_ID’ cannot be null” inserting row <br/> EVT_ID => (%d), AMC_mailchimp_list_id => d6c4e45e4b (%s), AMC_mailchimp_group_id => (%s) <br/> into table wp_dn5hpz3lys_esp_event_mailchimp_list_group.<br/> Data used was <br/> id => 1, event_id => 2, mailchimp_group_id => , mailchimp_list_id => d6c4e45e4b <br/> from table wp_dn5hpz3lys_events_mailchimp_event_rel.
Could not migrate old row {“id”:”2″,”event_id”:”3″,”mailchimp_group_id”:null,”mailchimp_list_id”:”0″} because there is no new event ID for old event with ID 3
Received error “Column ‘EVT_ID’ cannot be null” inserting row <br/> EVT_ID => (%d), AMC_mailchimp_list_id => 0 (%s), AMC_mailchimp_group_id => (%s) <br/> into table wp_dn5hpz3lys_esp_event_mailchimp_list_group.<br/> Data used was <br/> id => 2, event_id => 3, mailchimp_group_id => , mailchimp_list_id => 0 <br/> from table wp_dn5hpz3lys_events_mailchimp_event_rel.
Could not migrate old row {“id”:”3″,”event_id”:”1″,”mailchimp_group_id”:null,”mailchimp_list_id”:”d6c4e45e4b”} because there is no new event ID for old event with ID 1
Received error “Column ‘EVT_ID’ cannot be null” inserting row <br/> EVT_ID => (%d), AMC_mailchimp_list_id => d6c4e45e4b (%s), AMC_mailchimp_group_id => (%s) <br/> into table wp_dn5hpz3lys_esp_event_mailchimp_list_group.<br/> Data used was <br/> id => 3, event_id => 1, mailchimp_group_id => , mailchimp_list_id => d6c4e45e4b <br/> from table wp_dn5hpz3lys_events_mailchimp_event_rel.
Could not migrate old row {“id”:”4″,”event_id”:”4″,”mailchimp_group_id”:null,”mailchimp_list_id”:”d6c4e45e4b”} because there is no new event ID for old event with ID 4
Received error “Column ‘EVT_ID’ cannot be null” inserting row <br/> EVT_ID => (%d), AMC_mailchimp_list_id => d6c4e45e4b (%s), AMC_mailchimp_group_id => (%s) <br/> into table wp_dn5hpz3lys_esp_event_mailchimp_list_group.<br/> Data used was <br/> id => 4, event_id => 4, mailchimp_group_id => , mailchimp_list_id => d6c4e45e4b <br/> from table wp_dn5hpz3lys_events_mailchimp_event_rel.
Could not migrate old row {“id”:”5″,”event_id”:”5″,”mailchimp_group_id”:null,”mailchimp_list_id”:”d6c4e45e4b”} because there is no new event ID for old event with ID 5
Received error “Column ‘EVT_ID’ cannot be null” inserting row <br/> EVT_ID => (%d), AMC_mailchimp_list_id => d6c4e45e4b (%s), AMC_mailchimp_group_id => (%s) <br/> into table wp_dn5hpz3lys_esp_event_mailchimp_list_group.<br/> Data used was <br/> id => 5, event_id => 5, mailchimp_group_id => , mailchimp_list_id => d6c4e45e4b <br/> from table wp_dn5hpz3lys_events_mailchimp_event_rel.
Could not migrate old row {“id”:”6″,”event_id”:”6″,”mailchimp_group_id”:null,”mailchimp_list_id”:”d6c4e45e4b”} because there is no new event ID for old event with ID 6
Received error “Column ‘EVT_ID’ cannot be null” inserting row <br/> EVT_ID => (%d), AMC_mailchimp_list_id => d6c4e45e4b (%s), AMC_mailchimp_group_id => (%s) <br/> into table wp_dn5hpz3lys_esp_event_mailchimp_list_group.<br/> Data used was <br/> id => 6, event_id => 6, mailchimp_group_id => , mailchimp_list_id => d6c4e45e4b <br/> from table wp_dn5hpz3lys_events_mailchimp_event_rel.
Could not migrate old row {“id”:”7″,”event_id”:”7″,”mailchimp_group_id”:null,”mailchimp_list_id”:”d6c4e45e4b”} because there is no new event ID for old event with ID 7
Received error “Column ‘EVT_ID’ cannot be null” inserting row <br/> EVT_ID => (%d), AMC_mailchimp_list_id => d6c4e45e4b (%s), AMC_mailchimp_group_id => (%s) <br/> into table wp_dn5hpz3lys_esp_event_mailchimp_list_group.<br/> Data used was <br/> id => 7, event_id => 7, mailchimp_group_id => , mailchimp_list_id => d6c4e45e4b <br/> from table wp_dn5hpz3lys_events_mailchimp_event_rel.
Could not migrate old row {“id”:”8″,”event_id”:”8″,”mailchimp_group_id”:null,”mailchimp_list_id”:”d6c4e45e4b”} because there is no new event ID for old event with ID 8
Received error “Column ‘EVT_ID’ cannot be null” inserting row <br/> EVT_ID => (%d), AMC_mailchimp_list_id => d6c4e45e4b (%s), AMC_mailchimp_group_id => (%s) <br/> into table wp_dn5hpz3lys_esp_event_mailchimp_list_group.<br/> Data used was <br/> id => 8, event_id => 8, mailchimp_group_id => , mailchimp_list_id => d6c4e45e4b <br/> from table wp_dn5hpz3lys_events_mailchimp_event_rel.
Could not migrate old row {“id”:”9″,”event_id”:”9″,”mailchimp_group_id”:null,”mailchimp_list_id”:”d6c4e45e4b”} because there is no new event ID for old event with ID 9
Received error “Column ‘EVT_ID’ cannot be null” inserting row <br/> EVT_ID => (%d), AMC_mailchimp_list_id => d6c4e45e4b (%s), AMC_mailchimp_group_id => (%s) <br/> into table wp_dn5hpz3lys_esp_event_mailchimp_list_group.<br/> Data used was <br/> id => 9, event_id => 9, mailchimp_group_id => , mailchimp_list_id => d6c4e45e4b <br/> from table wp_dn5hpz3lys_events_mailchimp_event_rel.
Could not migrate old row {“id”:”10″,”event_id”:”10″,”mailchimp_group_id”:null,”mailchimp_list_id”:”d6c4e45e4b”} because there is no new event ID for old event with ID 10
Received error “Column ‘EVT_ID’ cannot be null” inserting row <br/> EVT_ID => (%d), AMC_mailchimp_list_id => d6c4e45e4b (%s), AMC_mailchimp_group_id => (%s) <br/> into table wp_dn5hpz3lys_esp_event_mailchimp_list_group.<br/> Data used was <br/> id => 10, event_id => 10, mailchimp_group_id => , mailchimp_list_id => d6c4e45e4b <br/> from table wp_dn5hpz3lys_events_mailchimp_event_rel.
Could not migrate old row {“id”:”11″,”event_id”:”11″,”mailchimp_group_id”:null,”mailchimp_list_id”:”d6c4e45e4b”} because there is no new event ID for old event with ID 11
Received error “Column ‘EVT_ID’ cannot be null” inserting row <br/> EVT_ID => (%d), AMC_mailchimp_list_id => d6c4e45e4b (%s), AMC_mailchimp_group_id => (%s) <br/> into table wp_dn5hpz3lys_esp_event_mailchimp_list_group.<br/> Data used was <br/> id => 11, event_id => 11, mailchimp_group_id => , mailchimp_list_id => d6c4e45e4b <br/> from table wp_dn5hpz3lys_events_mailchimp_event_rel.
Could not migrate old row {“id”:”12″,”event_id”:”12″,”mailchimp_group_id”:null,”mailchimp_list_id”:”d6c4e45e4b”} because there is no new event ID for old event with ID 12
Received error “Column ‘EVT_ID’ cannot be null” inserting row <br/> EVT_ID => (%d), AMC_mailchimp_list_id => d6c4e45e4b (%s), AMC_mailchimp_group_id => (%s) <br/> into table wp_dn5hpz3lys_esp_event_mailchimp_list_group.<br/> Data used was <br/> id => 12, event_id => 12, mailchimp_group_id => , mailchimp_list_id => d6c4e45e4b <br/> from table wp_dn5hpz3lys_events_mailchimp_event_rel.
Could not migrate old row {“id”:”13″,”event_id”:”13″,”mailchimp_group_id”:null,”mailchimp_list_id”:”d6c4e45e4b”} because there is no new event ID for old event with ID 13
Received error “Column ‘EVT_ID’ cannot be null” inserting row <br/> EVT_ID => (%d), AMC_mailchimp_list_id => d6c4e45e4b (%s), AMC_mailchimp_group_id => (%s) <br/> into table wp_dn5hpz3lys_esp_event_mailchimp_list_group.<br/> Data used was <br/> id => 13, event_id => 13, mailchimp_group_id => , mailchimp_list_id => d6c4e45e4b <br/> from table wp_dn5hpz3lys_events_mailchimp_event_rel.
Could not migrate old row {“id”:”14″,”event_id”:”14″,”mailchimp_group_id”:null,”mailchimp_list_id”:”d6c4e45e4b”} because there is no new event ID for old event with ID 14
Received error “Column ‘EVT_ID’ cannot be null” inserting row <br/> EVT_ID => (%d), AMC_mailchimp_list_id => d6c4e45e4b (%s), AMC_mailchimp_group_id => (%s) <br/> into table wp_dn5hpz3lys_esp_event_mailchimp_list_group.<br/> Data used was <br/> id => 14, event_id => 14, mailchimp_group_id => , mailchimp_list_id => d6c4e45e4b <br/> from table wp_dn5hpz3lys_events_mailchimp_event_rel.
Could not migrate old row {“id”:”15″,”event_id”:”15″,”mailchimp_group_id”:null,”mailchimp_list_id”:”d6c4e45e4b”} because there is no new event ID for old event with ID 15
Received error “Column ‘EVT_ID’ cannot be null” inserting row <br/> EVT_ID => (%d), AMC_mailchimp_list_id => d6c4e45e4b (%s), AMC_mailchimp_group_id => (%s) <br/> into table wp_dn5hpz3lys_esp_event_mailchimp_list_group.<br/> Data used was <br/> id => 15, event_id => 15, mailchimp_group_id => , mailchimp_list_id => d6c4e45e4b <br/> from table wp_dn5hpz3lys_events_mailchimp_event_rel.
Could not migrate old row {“id”:”16″,”event_id”:”16″,”mailchimp_group_id”:null,”mailchimp_list_id”:”d6c4e45e4b”} because there is no new event ID for old event with ID 16
Received error “Column ‘EVT_ID’ cannot be null” inserting row <br/> EVT_ID => (%d), AMC_mailchimp_list_id => d6c4e45e4b (%s), AMC_mailchimp_group_id => (%s) <br/> into table wp_dn5hpz3lys_esp_event_mailchimp_list_group.<br/> Data used was <br/> id => 16, event_id => 16, mailchimp_group_id => , mailchimp_list_id => d6c4e45e4b <br/> from table wp_dn5hpz3lys_events_mailchimp_event_rel.
Could not migrate old row {“id”:”17″,”event_id”:”17″,”mailchimp_group_id”:null,”mailchimp_list_id”:”d6c4e45e4b”} because there is no new event ID for old event with ID 17
Received error “Column ‘EVT_ID’ cannot be null” inserting row <br/> EVT_ID => (%d), AMC_mailchimp_list_id => d6c4e45e4b (%s), AMC_mailchimp_group_id => (%s) <br/> into table wp_dn5hpz3lys_esp_event_mailchimp_list_group.<br/> Data used was <br/> id => 17, event_id => 17, mailchimp_group_id => , mailchimp_list_id => d6c4e45e4b <br/> from table wp_dn5hpz3lys_events_mailchimp_event_rel.
Could not migrate old row {“id”:”18″,”event_id”:”18″,”mailchimp_group_id”:null,”mailchimp_list_id”:”d6c4e45e4b”} because there is no new event ID for old event with ID 18
Received error “Column ‘EVT_ID’ cannot be null” inserting row <br/> EVT_ID => (%d), AMC_mailchimp_list_id => d6c4e45e4b (%s), AMC_mailchimp_group_id => (%s) <br/> into table wp_dn5hpz3lys_esp_event_mailchimp_list_group.<br/> Data used was <br/> id => 18, event_id => 18, mailchimp_group_id => , mailchimp_list_id => d6c4e45e4b <br/> from table wp_dn5hpz3lys_events_mailchimp_event_rel.
Could not migrate old row {“id”:”19″,”event_id”:”19″,”mailchimp_group_id”:null,”mailchimp_list_id”:”d6c4e45e4b”} because there is no new event ID for old event with ID 19
Received error “Column ‘EVT_ID’ cannot be null” inserting row <br/> EVT_ID => (%d), AMC_mailchimp_list_id => d6c4e45e4b (%s), AMC_mailchimp_group_id => (%s) <br/> into table wp_dn5hpz3lys_esp_event_mailchimp_list_group.<br/> Data used was <br/> id => 19, event_id => 19, mailchimp_group_id => , mailchimp_list_id => d6c4e45e4b <br/> from table wp_dn5hpz3lys_events_mailchimp_event_rel.
Could not migrate old row {“id”:”20″,”event_id”:”20″,”mailchimp_group_id”:null,”mailchimp_list_id”:”d6c4e45e4b”} because there is no new event ID for old event with ID 20
Received error “Column ‘EVT_ID’ cannot be null” inserting row <br/> EVT_ID => (%d), AMC_mailchimp_list_id => d6c4e45e4b (%s), AMC_mailchimp_group_id => (%s) <br/> into table wp_dn5hpz3lys_esp_event_mailchimp_list_group.<br/> Data used was <br/> id => 20, event_id => 20, mailchimp_group_id => , mailchimp_list_id => d6c4e45e4b <br/> from table wp_dn5hpz3lys_events_mailchimp_event_rel.
Could not migrate old row {“id”:”21″,”event_id”:”21″,”mailchimp_group_id”:null,”mailchimp_list_id”:”d6c4e45e4b”} because there is no new event ID for old event with ID 21
Received error “Column ‘EVT_ID’ cannot be null” inserting row <br/> EVT_ID => (%d), AMC_mailchimp_list_id => d6c4e45e4b (%s), AMC_mailchimp_group_id => (%s) <br/> into table wp_dn5hpz3lys_esp_event_mailchimp_list_group.<br/> Data used was <br/> id => 21, event_id => 21, mailchimp_group_id => , mailchimp_list_id => d6c4e45e4b <br/> from table wp_dn5hpz3lys_events_mailchimp_event_rel.
Could not migrate old row {“id”:”22″,”event_id”:”22″,”mailchimp_group_id”:null,”mailchimp_list_id”:”d6c4e45e4b”} because there is no new event ID for old event with ID 22
Received error “Column ‘EVT_ID’ cannot be null” inserting row <br/> EVT_ID => (%d), AMC_mailchimp_list_id => d6c4e45e4b (%s), AMC_mailchimp_group_id => (%s) <br/> into table wp_dn5hpz3lys_esp_event_mailchimp_list_group.<br/> Data used was <br/> id => 22, event_id => 22, mailchimp_group_id => , mailchimp_list_id => d6c4e45e4b <br/> from table wp_dn5hpz3lys_events_mailchimp_event_rel.
Could not migrate old row {“id”:”23″,”event_id”:”23″,”mailchimp_group_id”:null,”mailchimp_list_id”:”c6eb53f6d5″} because there is no new event ID for old event with ID 23
Received error “Column ‘EVT_ID’ cannot be null” inserting row <br/> EVT_ID => (%d), AMC_mailchimp_list_id => c6eb53f6d5 (%s), AMC_mailchimp_group_id => (%s) <br/> into table wp_dn5hpz3lys_esp_event_mailchimp_list_group.<br/> Data used was <br/> id => 23, event_id => 23, mailchimp_group_id => , mailchimp_list_id => c6eb53f6d5 <br/> from table wp_dn5hpz3lys_events_mailchimp_event_rel.
Could not migrate old row {“id”:”24″,”event_id”:”24″,”mailchimp_group_id”:null,”mailchimp_list_id”:”d6c4e45e4b”} because there is no new event ID for old event with ID 24
Received error “Column ‘EVT_ID’ cannot be null” inserting row <br/> EVT_ID => (%d), AMC_mailchimp_list_id => d6c4e45e4b (%s), AMC_mailchimp_group_id => (%s) <br/> into table wp_dn5hpz3lys_esp_event_mailchimp_list_group.<br/> Data used was <br/> id => 24, event_id => 24, mailchimp_group_id => , mailchimp_list_id => d6c4e45e4b <br/> from table wp_dn5hpz3lys_events_mailchimp_event_rel.
Could not migrate old row {“id”:”25″,”event_id”:”25″,”mailchimp_group_id”:null,”mailchimp_list_id”:”d6c4e45e4b”} because there is no new event ID for old event with ID 25
Received error “Column ‘EVT_ID’ cannot be null” inserting row <br/> EVT_ID => (%d), AMC_mailchimp_list_id => d6c4e45e4b (%s), AMC_mailchimp_group_id => (%s) <br/> into table wp_dn5hpz3lys_esp_event_mailchimp_list_group.<br/> Data used was <br/> id => 25, event_id => 25, mailchimp_group_id => , mailchimp_list_id => d6c4e45e4b <br/> from table wp_dn5hpz3lys_events_mailchimp_event_rel.
More, but limit reached…
Event Espresso Level 2 Maintenance mode is active. That means EE can not run ANY database queries until the necessary migration scripts have run which will take EE out of maintenance mode level 2. Please inform support of this error.