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.
#437 - No initital Campaign Sync
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
-
"Amazing product and amazing people. Thanks a lot for all the help at any question! :D"
Read More Reviews
- Most Recent Love from Users
melissa- Westcoat
- Mark Westerhoff
- danielolivas
- kgm
- Evolution Marketing
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?
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?
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?
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.
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:
Here are some more common reasons for this error: http://dev.mysql.com/doc/refman/5.6/en/gone-away.html
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
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.
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!