SugarChimp

I uploaded 9.2.0 and the error I received which is documented in case #4225 no longer occurs when I click on a Target in my Target List however if I click on the Mailchimp Activity tab in my Contact I once again encounter the error. In order to get back to normal I am forced to exit Sugar clear my cache and then reenter Sugar. The error received is below (this is the same error documented in case 4225)

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