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.

Free 30 day trial
Try it Now

#1553 - Error inserting into table: sugarchimp : Query Failed

Closed Installation created by IshaInsight 3 years ago

Hi,

Just deployed the module(ver 6) in SuiteCRM 7.2

It fails in configuration with the following error in Suitecrm.log

[1][FATAL] Error inserting into table: sugarchimp: Query Failed: INSERT INTO sugarchimp (id,name,date_entered,date_modified,modified_user_id,created_by,deleted,mailchimp_list_id)
                                        VALUES ('601c15af-946c-eae3-a97d-55e1b50dc6ef','AddWebhook','2015-08-29 13:37:43','2015-08-29 13:37:43','1','1',0,'7b792d810b'): MySQL error 1146: Table 'insightcrm.sugarchimp' doesn't exist

When i check the db, it has the following tables only. sugarchimp table is not found.
    sugarchimpactivity_accounts
    sugarchimpactivity_contacts
    sugarchimpactivity_leads
    sugarchimpactivity_prospects
    sugarchimp_activity_tracker

Pls let me know how to fix this.

Thanks.

  1. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    3 years ago

    Hi there,

    We can help get this fixed. Sometimes the SuiteCRM Module Installer just misses this step. Thankfully it's easy to fix whenever this happens with any add-on install. To fix, go to Admin -> Repair -> Quick Repair and Rebuild. Once the page finishes loading just scroll to the bottom and click on the "Execute SQL" button. This will create any missing tables such as the sugarchimp table that is missing.

    Let us know how that goes!

  2. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    3 years ago

    Hello,

    I just wanted to follow up and see if you were able to get everything installed correctly. If you have any more questions let me know!

  3. IshaInsight member avatar

    IshaInsight

    3 years ago

    Yes, Was able to get pass the configuration. Thanks!
    However it is stuck in sync now. Created a new target list in Suite and mapped it to a list in Mailchimp. Scheduler shows the job as 'running ' for a long time now but it doesnt sync. Notice the following lines in the suite log.

    [FATAL] SugarChimp:debug:1441193595: SugarChimp_Helper::get_synced_lists sql: SELECT pl.id as id, pl.name as name, pl.mailchimp_list_name_c as mailchimp_list_id
                    FROM prospect_lists pl
                    WHERE
                        pl.deleted=0 AND
                        pl.mailchimp_list_name_c IS NOT NULL AND
                        pl.mailchimp_list_name_c != ''
    Wed Sep 2 17:03:15 2015 [3566][1][FATAL] SugarChimp:debug:1441193595: SugarChimp_Helper::get_synced_lists found 3 synced lists: Array
    (
        [0] => Array
            (
                [id] => 260e0c27-4b25-1ef6-07b6-55e68f48c943
                [name] => testsugarchmip
                [mailchimp_list_id] => 748404e068
            )

    [1] => Array
        (
            [id] => 279905a3-f0d6-901e-232c-55e197bba855
            [name] => Insight 2014 Targets
            [mailchimp_list_id] => 7b792d810b
        )
    
    [2] => Array
        (
            [id] => 766be5ec-ee32-edd1-7a4e-55e2aabd6d70
            [name] => Sugarchimptest
            [mailchimp_list_id] => a41e03c955
        )
    

    )

    Wed Sep 2 17:03:15 2015 [3566][1][FATAL] SugarChimp:debug:1441193595: SugarChimp_Helper::get_lists sql: SELECT DISTINCT pl.mailchimp_list_name_c as mailchimp_list_id
                    FROM prospect_lists pl
                    WHERE
                        pl.deleted=0 AND
                        pl.mailchimp_list_name_c IS NOT NULL AND
                        pl.mailchimp_list_name_c != ''
    Wed Sep 2 17:03:15 2015 [3566][1][FATAL] SugarChimp:debug:1441193595: SugarChimp_Helper::get_lists found 3 synced lists with ids: Array
    (
        [0] => 748404e068
        [1] => 7b792d810b
        [2] => a41e03c955
    )

    Wed Sep 2 17:03:15 2015 [3566][1][FATAL] SugarChimp:debug:1441193595: SugarChimp_Helper::queue_jobs queueing AddWebhook for 748404e068
    Wed Sep 2 17:03:15 2015 [3566][1][FATAL] SugarChimp:debug:1441193595: Instantiate SugarChimp_Job Driver SugarChimp_Job_AddWebhook
    Wed Sep 2 17:03:15 2015 [3566][1][FATAL] SugarChimp:debug:1441193595: SugarChimp_Helper::queue_jobs queueing AddWebhook for 7b792d810b
    Wed Sep 2 17:03:15 2015 [3566][1][FATAL] SugarChimp:debug:1441193595: Instantiate SugarChimp_Job Driver SugarChimp_Job_AddWebhook
    Wed Sep 2 17:03:15 2015 [3566][1][FATAL] SugarChimp:debug:1441193595: SugarChimp_Helper::queue_jobs queueing AddWebhook for a41e03c955
    Wed Sep 2 17:03:15 2015 [3566][1][FATAL] SugarChimp:debug:1441193595: Instantiate SugarChimp_Job Driver SugarChimp_Job_AddWebhook

  4. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    3 years ago

    Glad to hear you were able to get through the configuration. A couple questions for the new issue:

    1) How long has it appeared to be stuck? Depending on how many subscribers you are syncing, it can take a while to run (30 minutes to an hour).

    2) Can you please send your full Sugar log and screenshot of the full SugarChimp Health Status page (Sugar > Admin > Health Status) to support@sugarchimp.com?

    Thanks!

  5. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    3 years ago

    We were able to fix the issues through email support. If you have any more questions let us know!

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

    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.