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.
#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
Other add-ons of interest
Advanced Marketing Lists
Advanced Marketing Lists automatically fill Target Lists and keep updated the Campaigns to which they are associated.
KINAMU GDPR Module
The new GDPR, which enters into force on May 25, 2018, gives data subjects extensive possibilities to exercise control over their personal data. This results in a variety of obligations for data controllers. In order to be able to pursue this in a compliant and controlled manner KINAMU has developed...