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. Created by Fanatical Labs, 2023 SugarCRM Partner Award Winner.
#2946 - can't create contact
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
-
"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
melissa- Westcoat
- Mark Westerhoff
- danielolivas
- kgm
- Evolution Marketing
7 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
7 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