TheOracle,
Thank you for all your work. Now the duplicate fields are fixed.
As for the following error:
1054 Unknown column 'c.customers_default_address_id' in 'on clause'
in:
[select c.customers_id, c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_email_address, a.entry_company, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id, a.entry_country_id, c.customers_telephone, c.customers_fax, c.customers_newsletter, c.customers_default_address_id, c.customers_email_format, c.customers_group_pricing, c.customers_authorization, c.customers_referral, ac.field_name, ac.field_status from customers c, customers_additional ac left join address_book a on c.customers_default_address_id = a.address_book_id where a.customers_id = c.customers_id and c.customers_id = '9']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
This is how I fixed the error, and now I able to edit customers information. Hope this works for the rest of you. I changed the following code in file customers.php under additional_customers_fields\admin.
From original code:
from " . TABLE_CUSTOMERS . " c, " . TABLE_ADDITIONAL_CUSTOMERS . " ac
left join " . TABLE_ADDRESS_BOOK . " a
on c.customers_default_address_id = a.address_book_id
where a.customers_id = c.customers_id
and c.customers_id = '" . (int)$customers_id . "'");
To (needed c inner join):
from " . TABLE_CUSTOMERS . " c inner join " . TABLE_ADDITIONAL_CUSTOMERS . " ac
left join " . TABLE_ADDRESS_BOOK . " a
on c.customers_default_address_id = a.address_book_id
where a.customers_id = c.customers_id
and c.customers_id = '" . (int)$customers_id . "'");
So happy now, works with MYSQL 5
