SugarChimp

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!

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!

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

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!

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