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

#437 - No initital Campaign Sync

Closed Bug? created by thammer 5 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

    5 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

    5 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

    5 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

      5 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

      5 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

    5 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

      5 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

    5 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...
Rating
Rating
  • "Nice product and nice team behind it. They helped us with everything we needed in order to get our system working as we wanted to."

    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.