SugarChimp

by Fanatical Labs

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

#437 - No initital Campaign Sync

Closed Bug? created by thammer 10 years ago

Hey there,

i installed SugarChimp with help of the installation guide. Unfortunately the initial Campaign Sync doesnt work. It only sync 1 of 33 Campaigns although I chose the right time period. What can I do?

Thank you and Best regards

  1. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    10 years ago

    Hi Tilo, it may take a while to sync all of the Campaigns over. Have more campaigns come through since you created this case?

    What version/edition of Sugar are you using? Is it a on-site or on-demand instance?

    Lastly, if you go to "Admin" > "SugarChimp Process Queue", are there any events with an "Error" status?

  2. thammer member avatar

    thammer

    10 years ago

    Hey,

    we are using Sugar CE on a local installation 6.5.16. I have tried twice to install SugarChimp and Job initial Campaign Sync, but only 1 Campaign was synced. In the Process Queue are no Error Processes :( Maybe log file?

  3. thammer member avatar

    thammer

    10 years ago

    Wed Feb 26 17:40:35 2014 [21039][1][ERROR] ATC_Campaigns: tracker url is invalid url Wed Feb 26 17:42:15 2014 [21039][1][ERROR] ATC_Campaigns: tracker url is invalid url Wed Feb 26 17:42:15 2014 [21039][1][FATAL] Query Failed: INSERT INTO campaign_trkrs_cstm (id_c ,total_clicks_c ,unique_clicks_c ) VALUES ('87d902a7-eef1-199e-b71a-530e197f784b' ,7 ,7 ): MySQL error 2006: MySQL server has gone away Wed Feb 26 17:42:15 2014 [21039][1][FATAL] Error inserting into table: campaign_trkrs: Query Failed: INSERT INTO campaign_trkrs (id,tracker_name,tracker_url,date_entered,date_modified,modified_user_id,created_by,is_optout,deleted) VALUES ('87d902a7-eef1-199e-b71a-530e197f784b','http://www.myfeelix.de/nutzen-','http://www.myfeelix.de/nutzen-sie-die-hausse/?utm_source=feelix+Mitglied+Club-Portal&utm_campaign=b232306b80-Experten_Blog_Newsletter_The_European&utm_medium=email&utm_term=0_3f0992fd34-b232306b80-[LIST_EMAIL_ID]&goal=0_3f0992fd34-b232306b80-[LIST_EMAIL_I','2014-02-26 16:37:14','2014-02-26 16:37:14','1','1',0,0): MySQL error 2006: MySQL server has gone away Wed Feb 26 17:42:15 2014 [21039][1][FATAL] Job 8c5c0b0e-0156-28d3-c15d-530e18471421 (SugarChimp - Initiate Campaigns Update) failed in CRON run

    what does that mean?

    • fanaticallabs member avatar

      Fanatical Labs Provider Affiliate

      10 years ago

      Can you verify in your database that the id_c, total_clicks_c and unique_clicks_c fields exist on the campaign_trkrs_cstm table?

      The INSERT queries themselves are valid queries and generated by Sugar's framework.

      Have you made any customizations to the Sugar Campaigns or Campaign Tracker modules in the past?

      Also check the PHP error log to see if anything is going on there.

    • fanaticallabs member avatar

      Fanatical Labs Provider Affiliate

      10 years ago

      I noticed the "MySQL server has gone away" errors in the log. This is the cause of the issue. There are several reasons that this could happen. Some possibilities:

      • max_allowed_packet in my.cnf may need to be increased http://stackoverflow.com/questions/19463181/mysql-server-has-gone-away
      • Increasing the mysql.connect_timeout setting in your php.ini to something larger like 300
      • Increasing default_socket_timeout in php.ini to something larger like 300

      Here are some more common reasons for this error: http://dev.mysql.com/doc/refman/5.6/en/gone-away.html

  4. thammer member avatar

    thammer

    10 years ago

    I changed mysql.connect_timeout and default_socket_timeout -- no result -- But I cant find the file my.cnf for max_allowed_packet , do you know where i can find it?

    Output from initial Job:

    Fri Feb 28 18:55:17 2014 [23923][1][ERROR] Scheduler: Function process_filling_up_queue Start Fri Feb 28 18:55:17 2014 [23923][1][ERROR] SugarChimp: QueueProcessorFillingUpQueue:process - Start Fri Feb 28 18:55:17 2014 [23923][1][ERROR] SugarChimp :: Function createURL - Sets apiUrl as required in MCAPI Fri Feb 28 18:55:17 2014 [23923][1][ERROR] SugarChimp :: Function getMCAPIKey - To get API Key Fri Feb 28 18:55:17 2014 [23923][1][ERROR] SugarChimp: QueueProcessorFillingUpQueue:process - get campaigns for 240 days Fri Feb 28 18:56:55 2014 [23923][1][ERROR] SugarChimp: QueueProcessorFillingUpQueue:process - Updating campaign with mc campaign id b232306b80 Fri Feb 28 18:56:55 2014 [23923][1][ERROR] ATC_Campaigns: Function update_campaign_from_MC Start Fri Feb 28 18:56:55 2014 [23923][1][ERROR] array ( ..... Hier folgt die erste Kampagne .. Fri Feb 28 18:56:55 2014 [23923][1][ERROR] ATC_Campaigns: Function update_campaign_data_from_MC Start Fri Feb 28 18:56:55 2014 [23923][1][ERROR] Unable to load custom logic file: include/SugarSearchEngine/SugarSearchEngineQueueManager.php Fri Feb 28 18:56:55 2014 [23923][1][ERROR] Unable to load custom logic file: include/SugarSearchEngine/SugarSearchEngineQueueManager.php Fri Feb 28 18:56:55 2014 [23923][1][ERROR] ATC_Campaigns: Function update_campaign_data_from_MC Campaign created with id d05d5b7a-f089-dd18-3bb4-530cf17a65c2 Fri Feb 28 18:56:55 2014 [23923][1][ERROR] Unable to get proper side for link assigned_user_link Fri Feb 28 18:56:55 2014 [23923][1][ERROR] Unable to get proper side for link assigned_user_link Fri Feb 28 18:56:55 2014 [23923][1][ERROR] SugarChimp :: Function createURL - Sets apiUrl as required in MCAPI Fri Feb 28 18:56:55 2014 [23923][1][ERROR] SugarChimp :: Function getMCAPIKey - To get API Key Fri Feb 28 18:56:57 2014 [23923][1][ERROR] ATC_Campaigns: Function populate_campaign_trackers Start Fri Feb 28 18:56:57 2014 [23923][1][ERROR] ATC_Campaigns: Function update_campaign_trackers_from_MC Start

    • fanaticallabs member avatar

      Fanatical Labs Provider Affiliate

      10 years ago

      If the max_allowed_packet isn't set, it's probably using the default. You could add it to the my.cnf and set it to what you want.

      I'm going to follow up via email now. I'd like to see the entire sugar log if possible.

  5. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    10 years ago

    Hi there, just a reminder that the latest version of SugarChimp solves all of these issues and is very easy to use.

    If you're interested giving it another go, let me know!

    Closing this case in the meantime. Thanks!

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
  • SugarCRM Editions
  • Sugar Community
  • Sugar Professional
  • Sugar Enterprise
  • Sugar Sell
  • Sugar Serve
  • Sugar Market
  • Compatible Versions
  • 14.2, 14.1, 14.0, 13.3, 13.2, 13.1, 13.0, 12.3, 12.2, 12.1, 12.0, 11.3, 11.2, 11.1, 11.0, 10.3, 10.2, 10.1, 10.0, 9.3, 9.2, 9.1, 9.0, 8.3, 8.2, 8.1, 8.0, 7.11, 7.10, 7.9, 7.8, 7.7, 7.6, 7.5, 7.2, 6.7, 6.5
Rating
Rating

  • "This plugin basically functions as it says it does. Very fast to respond and very thorough in their work. I respect that."

    Read More Reviews
Integrations Marketing Sales mailchimp email marketing marketing Drip Campaigns Inbound Marketing Marketing Automation email automation chimp drip