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 Sell & Enterprise. Created by Fanatical Labs, 2023 SugarCRM Partner Award Winner.
#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
- Most Recent Love from Users
melissa- Westcoat
- Mark Westerhoff
- danielolivas
- kgm
- Evolution Marketing
5 years ago
5 years ago