error in softbounce log

Use this forum for all questions related to bounce management of OpenEMM

Moderator: moderator

snailsites.com
Posts: 2
Joined: Sat Jan 22, 2011 2:24 am

error in softbounce log

Post by snailsites.com »

i have following error message in 20111216-host-softbounce.log:

ERROR/merge: Failed: update failed: MySQL-1048: Column 'email' cannot be null (last query SELECT mt.customer_id, mt.mailing_id, cust.email FROM bounce_collect_tbl mt, customer_1_tbl cust WHERE cust.customer_id = mt.customer_id AND mt.company_id = 1 AND mt.status_id = 90 ORDER BY cust.email, mt.mailing_id) MySQL-1048: Column 'email' cannot be null

im using openemm 2011, upgraded from openemm 6.2
softbounce is installed as described in documentation
(crontab: 0 3 * * * /home/openemm/bin/softbounce.sh)


any suggestions or questions?
maschoff
Site Admin
Posts: 2597
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: error in softbounce log

Post by maschoff »

The SELECT statement tried to read email address from table customer_1_tbl for a customer_id that created a softbounce. For some reason the record in table customer_1_tbl has no value for field email. You should check your table customer_1_tbl for other records without a value in field email and find out the reason for it.
OpenEMM Maintainer
Post Reply