search

veda-consulting-company / uk.co.vedaconsulting.mailchimp

Other
22 stars 43 forks source link

New "DB Error: constraint violation" #108

Closed jtbayly closed 9 years ago

jtbayly commented 9 years ago

I'm getting an error when trying to sync from CiviCRM to Mailchimp. Here is the text that is shown:

[Error: List 1 all-mailchimp group: Fetched data from Mailchimp]
DB Error: constraint violation

I looked in the log and found that it says the following: 

[info] $CRM_Queue_Page_AJAX_runNext_error = PEAR_Exception: "DB Error: constraint violation"

Then later on I have this at the end of a line of 

[nativecode=1048 ** Column 'email' cannot be null]
veda-consulting commented 9 years ago

@jtbayly we'd really need to be able to reproduce this in order to debug and fix. Could you provide some steps to do this on the civicrm demo data?

jtbayly commented 9 years ago

I'll try with 1.6 and if the issue persists then I'll try to reproduce it on the demo data. Thanks.

jtbayly commented 9 years ago

Still seeing it. Looks like it might just be an organization without an email address. Is that enough to go on?

Kajakaran commented 9 years ago

@jtbayly I have tested an organization without an email address. Sync works as normal without error.

jtbayly commented 9 years ago

Sorry to waste your time. I should have known it would be more complicated than that. Let me look into it again.

-Joseph

Joseph Bayly Pastor, Clearnote Church http://ClearnoteChurch.com Mobile: (812) 360-5909 Office: (317) 456-2456

veda-consulting commented 9 years ago

@jtbayly I'll close for now, re-open if you get to the bottom of it. Not had reports from anyone else on this.

jtbayly commented 9 years ago

I don't know what's going on. I am running 1.6 and here is what the debug says:

INSERT INTO tmp_mailchimp_push_m VALUES(NULL, NULL, NULL, NULL, NULL, '40cd750bba9870f18aada2478b24840a', 'a:0:{}') [nativecode=1048 \ Column 'email' cannot be null]

Any suggestion of how I can figure out what contact is causing that? Is that long hex number a checksum that I can decode? I'm happy to spend some time on this, but I've got no idea how to take it further. This is a group of 3000 contacts, so it's not like I can just look through them.

Thanks,