Error retrieving Opportunity list: Query Failed:SELECT accounts.id as account_id, accounts.name as account_name, accounts.assigned_user_id account_id_owner, users.user_name as assigned_user_name , opportunities_cstm.* ,opportunities.* FROM opportunities LEFT JOIN users ON opportunities.assigned_user_id=users.id LEFT JOIN accounts_opportunities ON opportunities.id=accounts_opportunities.opportunit y_id LEFT JOIN accounts ON accounts_opportunities.account_id=accounts.id LEFT JOIN opportunities_cstm ON opportunities.id = opportunities_cstm.id_c where (accounts_opportunities.deleted is null OR accounts_opportunities.deleted=0) AND (accounts.deleted is null OR accounts.deleted=0) AND opportunities.deleted=0 ORDER BY opportunities.account_name asc LIMIT 0,1::MySQL error 1054: Unknown column 'opportunities.account_name' in 'order clause'
I received this error message and I am no longer able to view my "Opportunities List" on the Opportunities page. Any ideas on how to resolve this?


LinkBack URL
About LinkBacks



Reply With Quote
Bookmarks