#4225 - Exception occurred when selecting target from target list
I just uploaded 9.1.4a and when I went to select a target from my target list I was taken to the target then it immediately throws the following exception:
HTTP: 500 Internal Server Error An exception occurred while executing 'SELECT case when jt4_favorite_link.id IS NOT NULL then 1 else 0 end my_favorite, sugarchimpactivity.name, sugarchimpactivity.activity, jt2_mailchimp_list_name.name mailchimp_list_name, jt2_mailchimp_list_name.created_by mailchimp_list_name_owner, sugarchimpactivity.timestamp, sugarchimpactivity.sugarchimpmccampaign_id, sugarchimpactivity.sugarchimpmclist_id, sugarchimpactivity.id, sugarchimpactivity.date_modified, sugarchimpactivity.assigned_user_id, sugarchimpactivity.created_by FROM sugarchimpactivity LEFT JOIN sugarfavorites sf_sugarchimpactivity ON (sf_sugarchimpactivity.module = ?) AND (sf_sugarchimpactivity.record_id = sugarchimpactivity.id) AND (sf_sugarchimpactivity.assigned_user_id = ?) AND (sf_sugarchimpactivity.deleted = ?) LEFT JOIN sugarchimp_mc_campaign jt1_mailchimp_campaign_name ON sugarchimpactivity.sugarchimpmccampaign_id = LEFT JOIN sugarchimp_mc_list jt2_mailchimp_list_name ON (sugarchimpactivity.sugarchimpmclist_id = jt2_mailchimp_list_name.id) AND (jt2_mailchimp_list_name.deleted = ?) INNER JOIN sugarchimpactivity_prospects sugarchimpactivity_prospects ON (sugarchimpactivity.id = sugarchimpactivity_prospects.sugarchimpactivity_id) AND (sugarchimpactivity_prospects.deleted = ?) INNER JOIN prospects jt3_sugarchimpactivity ON (jt3_sugarchimpactivity.id = sugarchimpactivity_prospects.prospect_id) AND (jt3_sugarchimpactivity.deleted = ?) AND (jt3_sugarchimpactivity.id = ?) LEFT JOIN prospects_cstm jt3_sugarchimpactivity_cstm ON jt3_sugarchimpactivity_cstm.id_c = jt3_sugarchimpactivity.id LEFT JOIN sugarfavorites sugarchimpactivity_favorite ON (sugarchimpactivity.id = sugarchimpactivity_favorite.record_id) AND (sugarchimpactivity_favorite.deleted = ?) AND (sugarchimpactivity_favorite.module = ?) AND (sugarchimpactivity_favorite.created_by = ?) LEFT JOIN users jt4_favorite_link ON (jt4_favorite_link.id = sugarchimpactivity_favorite.modified_user_id) AND (jt4_favorite_link.deleted = ?) WHERE sugarchimpactivity.deleted = ? ORDER BY sugarchimpactivity.date_modified DESC, sugarchimpactivity.id DESC LIMIT 6' with params ["SugarChimpActivity", "2fd31892-c32c-3728-462c-5452449651e0", 0, 0, 0, 0, "1532df0a-251e-11e9-b4d1-02a870dc2252", "0", "SugarChimpActivity", "2fd31892-c32c-3728-462c-5452449651e0", 0, 0]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'JOIN sugarchimp_mc_list jt2_mailchimp_list_name ON (sugarchimpactivity.sugarchim' at line 1
5 years ago
Happy to help. Can you follow these steps (they may seem a bit redundant):
Once you do this, let this know if you're still having any trouble.
Best, Heidi
5 years ago
I actually closed my sugar instance, cleared my cache and no longer see the problem. If I encounter it again I will try your procedure. Thanks for the quick response
5 years ago
Glad that worked for you! Let us know if you encounter any further trouble.
Best, Heidi