OpenEMM Technical Support Forum

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?

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.