by Fanatical Labs

Save Your Team Countless Hours. SugarChimp syncs your lists in both directions so you can work in your preferred app. Segment and group your Mailchimp subscribers based on Sugar data so you can market to the right people at the right time. Compatible with all versions and editions of Sugar and SuiteCRM.

Free 30 day trial
Try it Now

By clicking you consent to share your profile with the developer

#4240 - HTTP: 500 Internal Server Error

Closed Bug? created by danrtaylor 2 years ago

After two days of using the integration I'm now getting a HTTP: 500 Internal Server Error. Ran fine for two days now when I click on contacts I get this error. Health status appears fine and am running version 9.2.0b.

HTTP: 500 Internal Server Error An exception occurred while executing 'SELECT sugarchimpactivity.name, sugarchimpactivity.activity, jt1_mailchimp_list_name.name mailchimp_list_name, jt1_mailchimp_list_name.created_by mailchimp_list_name_owner, sugarchimpactivity.timestamp, sugarchimpactivity.date_entered, sugarchimpactivity.date_modified, sugarchimpactivity.modified_user_id, sugarchimpactivity.assigned_user_id, sugarchimpactivity.created_by, sugarchimpactivity.description, sugarchimpactivity.url, sugarchimpactivity.ip, sugarchimpactivity.include_empty, sugarchimpactivity.sugarchimpmccampaign_id, sugarchimpactivity.sugarchimpmclist_id, sugarchimpactivity.id FROM sugarchimpactivity LEFT JOIN sugarchimp_mc_campaign jt0_mailchimp_campaign_name ON sugarchimpactivity.sugarchimpmccampaign_id = LEFT JOIN sugarchimp_mc_list jt1_mailchimp_list_name ON (sugarchimpactivity.sugarchimpmclist_id = jt1_mailchimp_list_name.id) AND (jt1_mailchimp_list_name.deleted = ?) WHERE (sugarchimpactivity.id IN (?,?,?,?,?,?)) AND (sugarchimpactivity.deleted = ?) ORDER BY sugarchimpactivity.date_modified DESC, sugarchimpactivity.id DESC' with params [0, "03dc6026-dc4a-11e9-800f-00163e7abda1", "03dbda2a-dc4a-11e9-97b7-00163e7abda1", "03d76b52-dc4a-11e9-a01a-00163e7abda1", "db3fc6cc-db80-11e9-95ce-00163e7abda1", "db3f417a-db80-11e9-aa18-00163e7abda1", "db3ea864-db80-11e9-8072-00163e7abda1", 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 jt1_mailchimp_list_name ON (sugarchimpactivity.sugarchim' at line 1

  1. danrtaylor member avatar

    danrtaylor

    2 years ago

    The error actually appears when I view Campaign Activity. It was erroring on the contacts list because I had the Mailchimp Activity Dashlet running. I've deleted it and the error has cleared. I still get this error however when I look at the activity.

  2. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    2 years ago

    Happy to help. Can you try completing a Quick Repair & Rebuild and see if the issue continues for you? Steps for completing this can be found here: https://support.sugarcrm.com/Knowledge_Base/Troubleshooting/Performing_a_Quick_Repair_and_Rebuild/#Steps_to_Complete

    Let me know if that doesn't resolve things and we can troubleshoot further.

    Best, Heidi

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating
  • "SugarChimp is working great. We're able to sync all of our lists and subscriber fields between MailChimp and SugarCRM. SugarChimp Support also did a great job supporting us as we were setting everything up."

    Read More Reviews