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

#2946 - can't create contact

Closed Bug? created by Shimmy 5 years ago

Hi There is the following error in our log when trying to add new contact:

Thu Mar 16 12:56:21 2017 [3817][d9d9ff58-6deb-3fcb-185b-5469f7483a85][FATAL] 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 ('bd125748-b4b3-49d1-83d1-58ca8b0cab86','','2017-03-16 12:56:21','2017-03-16 12:56:21','d9d9ff58-6deb-3fcb-185b-5469f7483a85','d9d9ff58-6deb-3fcb-185b-5469f7483 a85',0,'Contacts','b5e90df1-3c74-a116-d61c-58ca8b850c75'): MySQL error 1146: Table 'crm.smartlist_queue' doesn't exist

  1. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    5 years ago

    Hello,

    Your server is not finding the smartlist_queue table, which points to an installation issue. The first thing to try is to go into Sugar and do an admin > Repair > Quick Repair and Rebuild. After that, go back and try to create the new Contact now.

    If that does not work, then we need to figure out why the table is not added in your db from SugarChimp installation. I look forward to hearing back on how the Repair goes.

    Thanks, Jon

  2. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    5 years ago

    Hello again,

    We didn't hear back from you and your trial was cancelled so I'm going to close this case out. Let us know if you want to come back and give it a go again down the road.

    Thanks! Jon

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating
  • "We do a lot of highly-segmented outbound marketing and SugarChimp is exactly what we needed. The list and field syncing are great, and it allows us to do more sophisticated campaigns that exactly target certain Lead profiles in Sugar. The SugarChimp team is also really great, and they are totally committed to our success."

    Read More Reviews