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.
#883 - List Sync Sugar - Mailchimp
Hi threre
A sugar customer of mine would like to use mailchimp in future. in installed the package in module loader witthout any problems. scheduler works fine. Health check does not show any problems. the creation and mapping of lists work also fine. the only problem is the target list from sugar is not synced to mailchimp. in sugar i see some nasty errors: 0/28/14 14:22:01 [5312][1][FATAL] SugarChimp:debug:1414495321: SugarChimp_Helper::get_lists found 1 synced lists with ids: Array ( [0] => bd78103e26 )
10/28/14 14:22:01 [5312][1][FATAL] SugarChimp:debug:1414495321: SugarChimp_Scheduler_SugarToMailchimp->get_next_job_name_to_process get oldest job: SELECT TOP 1 * FROM ( SELECT name , ROW_NUMBER() OVER (ORDER BY date_entered ASC) AS row_number FROM sugarchimp WHERE mailchimp_list_id = 'bd78103e26'
) AS a
WHERE row_number > 0
10/28/14 14:22:01 [5312][1][FATAL] SugarChimp:debug:1414495321: SugarChimp_Scheduler_SugarToMailchimp->get_jobs_to_process get next oldest job: SELECT TOP 1 * FROM ( SELECT date_entered , ROW_NUMBER() OVER (ORDER BY ASC) AS row_number FROM sugarchimp WHERE mailchimp_list_id = 'bd78103e26' && name != 'AddWebhook'
) AS a
WHERE row_number > 0
10/28/14 14:22:01 [5312][1][FATAL] Query Failed:SELECT TOP 1 * FROM ( SELECT date_entered , ROW_NUMBER() OVER (ORDER BY ASC) AS row_number FROM sugarchimp WHERE mailchimp_list_id = N'bd78103e26' && name != N'AddWebhook'
) AS a
WHERE row_number > 0::: [Microsoft][SQL Server Native Client 11.0][SQL Server]Falsche Syntax in der N�he des ASC-Schl�sselworts.
10/28/14 14:22:01 [5312][1][FATAL] SugarChimp:debug:1414495321: SugarChimp_Scheduler_SugarToMailchimp->get_jobs_to_process get the jobs to process: SELECT TOP 500 * FROM ( SELECT id, param1, param2, param3, param4, param5 , ROW_NUMBER() OVER (ORDER BY date_entered ASC) AS row_number FROM sugarchimp WHERE mailchimp_list_id = 'bd78103e26' && name = 'AddWebhook'
) AS a
WHERE row_number > 0
10/28/14 14:22:01 [5312][1][FATAL] Query Failed:SELECT TOP 500 * FROM ( SELECT id, param1, param2, param3, param4, param5 , ROW_NUMBER() OVER (ORDER BY date_entered ASC) AS row_number FROM sugarchimp WHERE mailchimp_list_id = N'bd78103e26' && name = N'AddWebhook'
) AS a
WHERE row_number > 0::: [Microsoft][SQL Server Native Client 11.0][SQL Server]Falsche Syntax in der N�he von '&'.
10/28/14 14:22:01 [5312][1][FATAL] SugarChimp:debug:1414495321: SugarChimp_Scheduler_SugarToMailchimp->get_jobs_to_process jobs to process: Array ( )
Installation: SugarCRM Professional Version 6.5.12 (Build 1046) Onsite Installation, Built on Windows Server and MS-SQL
Questions: - are there any bugs on windows environment known - fixes or recommended procedure
Please infor customer also directly per email: oliver.latsch@lipomed.ch
thanks, i appreciate your helpt felix
-
"Awesome product. Even better support."
Read More Reviews
- Most Recent Love from Users
melissa- Westcoat
- Mark Westerhoff
- danielolivas
- kgm
- Evolution Marketing
10 years ago
Hi Felix, thanks for the feedback.
I'm looking into the issue now and will let you know what I find. Thanks!
10 years ago
I just wanted to follow up on this. I found a couple of issues related to systems running on mssql. I'm working on patching those now. I hope to have an update out to you soon. Thanks for your patience!
10 years ago
Hi Felix, we've cleared up the remaining mssql issues that you've identified. Please download the latest from your orders, install it over your current version and give it a try. Thanks!
10 years ago
Hi Felix, I'm going to close this case. Feel free to followup with a new case or send me an email if you need anything else. Thanks!