SugarChimp

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