Getting following error in sugarcrm Database failure. Please refer to sugarcrm.log for details.

I am getting the following error on my campaign page, when I checked the error log following MySQL query is causing the issue

Query Failed:(SELECT , ,  prospect_lists.description ,  prospect_lists.list_type ,  prospect_lists.assigned_user_id  ,  'prospectlists' panel_name  FROM prospect_lists  INNER JOIN  prospect_list_campaigns ON AND prospect_list_campaigns.campaign_id='c411d0f1-f5b1-288b-62ab-49ae9e5d7982' AND prospect_list_campaigns.deleted=0

  where prospect_lists.deleted=0) ORDER BY asc LIMIT 0,10::: MySQL error 1250: Table 'prospect_lists' from one of the SELECTs cannot be used in global ORDER clause

Sugar crm version - 6.5.26

PHP - 5.6
Mysql - 8.0

can you guys help me to fix the issue

Parents Reply Children