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

#4237 - HTTP: 500 Internal Server Error

Closed Bug? created by meuhus Verified Purchase 5 months ago

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

  1. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    5 months ago

    Hi Melody,

    Thanks for reaching out. To confirm, it looks like you're currently on 9.2.0a, is that correct? (You can see this from your Health Status page.) Our developer released some more recent updates so our latest version is 9.2.0b.

    Can you follow the steps below and let me know if you continue to get these errors:

    1. Upload the latest SugarChimp version (the latest version on SugarOutfitters is currently 9.2.0b)
    2. Navigate to Sugar's Admin page and click Repair.
    3. Click Quick Repair and Rebuild.
    4. Navigate back to Sugar Admin and click Repair.
    5. Click Rebuild Relationships. This will just say done.

    Let me know if you continue to get errors once you walk through the above steps. Thanks for your help in solving this issue!

    Best,
    Heidi

    • meuhus member avatar

      meuhus Verified Purchase

      5 months ago

      Thanks Heidi, that took care of the problem

  2. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    5 months ago

    Awesome; thanks for letting me know.

    Please let us know if you have any further trouble.

    Best,
    Heidi

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating
  • "We do a lot of highly-segmented outbound marketing and SugarChimp is exactly what we needed. The list and field syncing are great, and it allows us to do more sophisticated campaigns that exactly target certain Lead profiles in Sugar. The SugarChimp team is also really great, and they are totally committed to our success."

    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.