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.
#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 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
- Most Recent Love from Users
Westcoat- mikeruijters
- danielolivas
- kgm
- Evolution Marketing
- MorganLee
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 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