SugarChimp

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.

Free 30 day trial

Try it Now

By clicking you consent to share your profile with the developer

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

Closed Installation created by IshaInsight 8 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.

Fanatical Labs Provider Affiliate
8 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!

reply
Fanatical Labs Provider Affiliate
8 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!

reply
IshaInsight
8 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
reply
Fanatical Labs Provider Affiliate
8 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!

reply
Fanatical Labs Provider Affiliate
8 years ago

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

reply