Support

Home Forums MailChimp Integration Mailchimp addon fails

Mailchimp addon fails

Posted: February 12, 2020 at 9:48 am


Terri Shinners

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.


Tony

  • Support Staff

February 12, 2020 at 2:11 pm

Hi there,

The info here doesn’t provide anything useful but I had a look over the report you sent through EE and that shows an issue with the MailChimp key.

May I ask, have you previously used the MailChimp add-on on that site or is this the first time you have installed/activated it?

The support post ‘Mailchimp addon fails’ 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.

Status: closed

Updated by  Tony 6 months ago ago

Topic Tags

Notifications

This topic is: not resolved
Do NOT follow this link or you will be banned from the site!