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 Sell & Enterprise. 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
-
"We have used SugarChimp for the past two years and it's a really simple, straightforward email solution. I love that it segments email campaigns base..." - tlemotte
Read More Reviews
- Most Recent Love from Users
melissa- Westcoat
- Mark Westerhoff
- danielolivas
- kgm
- Evolution Marketing
10 years ago
10 years ago
10 years ago
10 years ago