5.1 Contacts export file shows email1 column twice but with invalid data.

**thowden** · 2008-09-26, 03:31 AM

Hi

Using the contacts Export option to generate a .csv file gives a column called email1 twice. The second column showing with the account_name values not an email address.

modules\contact\contacts.php has a query around line 339.

PHP Code:

 $query = "SELECT 

               contacts.*,email_addresses.email_address email1, 

               accounts.name as account_name, 

               users.user_name as assigned_user_name ";

The issue comes from having an upgraded database where the contacts table has a deprecated email1 column while the 5.1 code is trying to alias the email_addresses table column email_address as email1. Either remove the two deprecated contacts table columns email1 & email2 or modify the above query to

PHP Code:

 $query = "SELECT 

                        contacts.*, 

                        email_addresses.email_address as email_address, 

                        accounts.name as account_name, 

                        users.user_name as assigned_user_name ";

Which changes the alias for the column, stops the clash with the old column, and adds in the missing SQL 'as" as a formality.

Hope this helps someone who is upgrading from earlier versions to 5.1 and using the contact / accounts export.

cheers
Tony

Marble Bay Pty Ltd
Wren/Maxwell Web Management