IshaInsight does not have any add-ons for sale.

• Error inserting into table: sugarchimp : Query Failed

  Support September 2nd, 2015 @ 11:48 am
  

  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

  View Comment
  
  

IshaInsight has not rated any add-ons.

IshaInsight has not verified any add-ons.

IshaInsight has not created any Wanted Add-ons.