Error Message in "Contact List View"

[sman99]

Wow, in a lame newbie attempt to insert column headers (fields? labels?) I apparently removed something of importance. The following error message appears when attempting to view my Contacts List:

Error retrieving Contact list: Query Failed:SELECT contacts.*, accounts.name as account_name, accounts.id as account_id, accounts.assigned_user_id account_id_owner, users.user_name as assigned_user_name , contacts_cstm.* FROM contacts LEFT JOIN users ON contacts.assigned_user_id=users.id LEFT JOIN accounts_contacts ON contacts.id=accounts_contacts.contact_id and accounts_contacts.deleted=0 LEFT JOIN accounts ON accounts_contacts.account_id=accounts.id LEFT JOIN contacts_cstm ON contacts.id = contacts_cstm.id_c where (contacts.assigned_user_id = 'bcc9a972-25ac-1b35-2ae5-47ebb7648e19') AND contacts.deleted=0 AND (accounts.deleted is NULL or accounts.deleted=0) ORDER BY contacts.account_name asc LIMIT 0,20::MySQL error 1054: Unknown column 'contacts.account_name' in 'order clause'

Any way of getting back my Contact List View?

HELP!

Thanks

Sman99

[andopes]

Hi, sman99.

Which version you are using?

--
André Lopes
Lâmpada Global Services
Rua Bela Cintra, 299 conjunto. 51
São Paulo, SP 01415-000
tel1. 55 11 3237-3110
cel. 55 11 7636-5859
e-mail: info@lampadacrm.com.br