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


LinkBack URL
About LinkBacks



Reply With Quote

Bookmarks