AnsweredAssumed Answered

Problem with sorting accounts by email in Targets List tab.

Question asked by elviszoparo elviszoparo on Feb 12, 2015
Latest reply on Feb 1, 2016 by Tamás Karádi
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