AnsweredAssumed Answered

Problem with sorting accounts by email in Targets List tab.

Question asked by elviszoparo elviszoparo on Feb 12, 2015
Latest reply on Jul 12, 2018 by Sonu K
Hello,

I'm running SugarCrm CE version 6.5.18 (Build 1110). For some time struggling with the problem sorting accounts by email in Targets List.
I can add account sort it by name, creation date, but when i want to sort it by email address, I get an error message: Database error: See SugarCrm Log file for more details.

Log file:
 AND jt0.deleted=0 INNER JOIN  prospect_lists_prospects ON accounts.id=prospect_lists_prospects.related_id AND prospect_lists_prospects.prospect_list_id='306527d8-cffd-a038-fbbf-54dca7accc24' AND prospect_lists_prospects.deleted=0
AND prospect_lists_prospects.related_type = 'Accounts'
  where accounts.deleted=0) ORDER BY email1 desc LIMIT 0,10: MySQL error 1054: Unknown column 'email1' in 'order clause'
Thu Feb 12 14:33:36 2015 [18794][987a00f1-cbc7-1980-5f6e-528607524fa6][DEBUG] Hook called: ::server_round_trip
Thu Feb 12 14:33:36 2015 [18794][987a00f1-cbc7-1980-5f6e-528607524fa6][DEBUG] Calling MySQLi::disconnect()
Thu Feb 12 14:33:36 2015 [18794][987a00f1-cbc7-1980-5f6e-528607524fa6][ERROR] File cache/themes/Sugar5/pathCache.php cannot be written to
Can somebody help me with this problem

Outcomes