by Fanatical Labs

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.

Cancel at any time!
Free Trial

#2946 - can't create contact

Closed Bug? created by Shimmy a year 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

    a year 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

    a year 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
  • "Does a great job of syncing all of our registrant information. They go the extra mile with one-on-one support!"

    Read More Reviews

Keep up to date on the latest additions

We'll send you an email every month with handpicked add-ons, reviews, tricks and tips. Don't worry, we hate spam as much as you do.