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?
error in softbounce log
Moderator: moderator
-
- Site Admin
- Posts: 2628
- Joined: Thu Aug 03, 2006 10:20 am
- Location: Munich, Germany
- Contact:
Re: error in softbounce log
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