From e9a3b0cf3bce76757780c68676a3ccff3d0b2d3f Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Tue, 24 Jan 2017 08:55:07 -0500 Subject: [PATCH] Fix for correcting the mailing address state use correct mailing_state field --- models/admin/management/import/mailingAddresses.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/models/admin/management/import/mailingAddresses.php b/models/admin/management/import/mailingAddresses.php index ace5a939..07ab3d39 100644 --- a/models/admin/management/import/mailingAddresses.php +++ b/models/admin/management/import/mailingAddresses.php @@ -89,7 +89,7 @@ if (!$failure) { $sql = " SELECT m.member_id,m.member_name,m.mailing_address,m.mailing_city,s.state_abb as mailing_state,m.mailing_zip FROM members.member m, members.state s - WHERE m.state_id = s.state_id + WHERE m.mailing_state_id = s.state_id AND (m.mailing_address IS NOT NULL OR m.mailing_address != '') AND (m.mailing_city IS NOT NULL OR m.mailing_city != '') ORDER BY member_id -- 2.17.1