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.

Free 30 day trial
Try it Now

#4227 - HTTP: 500 Internal Server Error

Closed Bug? created by billiewilson Verified Purchase a year ago

I upgraded our SugarChimp module yesterday and since then our users have been receiving the below server error when utilizing SugarCRM. It appears to have something to do with SugarChimp. Do you have a revised module that I can upload? The Module Loader will not let me revert it back to the previous one.

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_accounts sugarchimpactivity_accounts ON (sugarchimpactivity.id = sugarchimpactivity_accounts.sugarchimpactivity_id) AND (sugarchimpactivity_accounts.deleted = ?) INNER JOIN accounts jt3_sugarchimpactivity ON (jt3_sugarchimpactivity.id = sugarchimpactivity_accounts.account_id) AND (jt3_sugarchimpactivity.deleted = ?) AND (jt3_sugarchimpactivity.id = ?) LEFT JOIN accounts_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 12' with params ["SugarChimpActivity", "aacb084f-d359-073b-d365-4cb756cf8d2e", 0, 0, 0, 0, "719544d2-4295-96b9-f934-54e78feddb1c", "0", "SugarChimpActivity", "aacb084f-d359-073b-d365-4cb756cf8d2e", 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

    a year ago

    Hi Billie,

    Thanks for reaching out. We just recently updated SugarOutfitters with a new version, SugarChimp 9.2.0. Can you update to the latest version and see if you're still encountering these issues?

    Thanks,
    Heidi

  2. billiewilson member avatar

    billiewilson Verified Purchase

    a year ago

    Thank you, the latest version appears to have fixed the issue.

  3. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    a year ago

    Wonderful! Let us know if anything else seems out of the ordinary.

    Best,
    Heidi

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating

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.