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 Trial

By clicking you consent to share your profile with the developer

#2345 - Sugar CRM no longer creating contacts

Closed Installation created by jfbernard Verified Purchase 6 years ago

Hi there, We discovered yesterday that our Sugar CRM would no longer create Contacts. Our Sugar vendor looked into it and reports the following error in our log. Since then, we have disabled the Mailchimp plugin. Is this something you can help with? This is the third time this year this has happened and causes a disruption for us.

"Mon Jul 18 10:34:15 2016 [26779][e31df6d2-83d5-e3ba-c726-52812b37b551][FATAL] SugarChimpOutfittersLicense [result] => Key could not be found locally. Please go to the license configuration tool Mon Jul 18 10:34:15 2016 [26779][e31df6d2-83d5-e3ba-c726-52812b37b551][FATAL] SugarChimpOutfittersLicense::get_current_plan: no public key was provided in the last response. we still have invalid public key." Error inserting into table: smartlist_queue: Query Failed:INSERT INTO smartlist_queue (id,name,date_entered,date_modified,modified_user_id,created_by,deleted,module,record) VALUES ('1c5157ee-c156-68a2-86b7-578cea743850','','2016-07-18 14:39:44','2016-07-18 14:39:44','e31df6d2-83d5-e3ba-c726-52812b37b551','e31df6d2-83d5-e3ba-c726-52812b37b551',0,'Contacts','4e341e20-9658-f6a0-0b47-578ceaf8da9c')::: MySQL error 1146: Table 'c34prod_pei.smartlist_queue' doesn't exist

  1. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    6 years ago


    I apologize for the trouble. I'm unable to find your SugarChimp purchase from that account. Can you provide me with the SugarChimp license key that you are using so I can pull up your account here? I will be able to give you some more insight once I've done that. These support forums are public so please do not submit your license key here. If you would, email that information to and I'll get back to you once I've found the account.


  2. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    5 years ago


    I wanted to follow up and let you know that we've released a few new versions since this was last updated that could certainly have fixed any of your issues. MailChimp is no longer supporting their old v2 api, so our newest release has completely migrated to using their v3 api. I recommend upgrading to the latest version to ensure no interruption in services. Let me know if there is anything else I can do to help.


This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
  • "Amazing product and amazing people. Thanks a lot for all the help at any question! :D"

    Read More Reviews