by Fanatical Labs

Save Your Team Countless Hours. SugarChimp syncs your lists in both directions so that you can work in your preferred application. Segment and Group your MailChimp subscribers based on SugarCRM data so you can market to the right people at the right time. Fully compatible with all versions and editions of Sugar and SuiteCRM.

Cancel at any time!
Free Trial

#4225 - Exception occurred when selecting target from target list

Closed Bug? created by meuhus Verified Purchase 2 years ago

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 IS NOT NULL then 1 else 0 end my_favorite,, sugarchimpactivity.activity, mailchimp_list_name, jt2_mailchimp_list_name.created_by mailchimp_list_name_owner, sugarchimpactivity.timestamp, sugarchimpactivity.sugarchimpmccampaign_id, sugarchimpactivity.sugarchimpmclist_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 = 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 = AND (jt2_mailchimp_list_name.deleted = ?) INNER JOIN sugarchimpactivity_prospects sugarchimpactivity_prospects ON ( = sugarchimpactivity_prospects.sugarchimpactivity_id) AND (sugarchimpactivity_prospects.deleted = ?) INNER JOIN prospects jt3_sugarchimpactivity ON ( = sugarchimpactivity_prospects.prospect_id) AND (jt3_sugarchimpactivity.deleted = ?) AND ( = ?) LEFT JOIN prospects_cstm jt3_sugarchimpactivity_cstm ON jt3_sugarchimpactivity_cstm.id_c = LEFT JOIN sugarfavorites sugarchimpactivity_favorite ON ( = sugarchimpactivity_favorite.record_id) AND (sugarchimpactivity_favorite.deleted = ?) AND (sugarchimpactivity_favorite.module = ?) AND (sugarchimpactivity_favorite.created_by = ?) LEFT JOIN users jt4_favorite_link ON ( = sugarchimpactivity_favorite.modified_user_id) AND (jt4_favorite_link.deleted = ?) WHERE sugarchimpactivity.deleted = ? ORDER BY sugarchimpactivity.date_modified DESC, 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

  1. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    2 years ago

    Happy to help. Can you follow these steps (they may seem a bit redundant):

    1. Navigate to Sugar's Admin page and click Repair.
    2. Click Quick Repair and Rebuild. At the bottom of that page, execute any queries that it asks you to.
    3. Navigate back to Sugar Admin and click Repair.
    4. Click Rebuild Relationships. This will just say done.
    5. Navigate back to Sugar's Admin page and click Repair again.
    6. Click Quick Repair and Rebuild once more.

    Once you do this, let this know if you're still having any trouble.


    • meuhus member avatar

      meuhus Verified Purchase

      2 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

  2. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    2 years ago

    Glad that worked for you! Let us know if you encounter any further trouble.


This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
  • "Have been very happy with the lights-out, just-works capability of both the Pro, and more recently Ultimate get Advanced Field Mappings ..." - Westcoat

    Read More Reviews

Keep up to date on the latest additions

We'll send you an email every month with handpicked add-ons, reviews, tricks and tips. Don't worry, we hate spam as much as you do.