Turn Marketing Data into Revenue Intelligence. SugarChimp seamlessly syncs your SugarCRM and Mailchimp data in both directions—no manual updates, no stale lists. This real-time connection arms your sales team with richer, more meaningful insights into customer behavior.
#4240 - HTTP: 500 Internal Server Error
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
-
"SugarChimp is exactly what we needed, it syncs nicely between MailChimp and Sugar. The added MailChimp dashlet is very sophisticated. Works great – thank you!"
Read More Reviews
6 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.
6 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