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

#883 - List Sync Sugar - Mailchimp

Closed Bug? created by Oliver Latsch 4 years ago

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

  1. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    4 years ago

    Hi Felix, thanks for the feedback.

    I'm looking into the issue now and will let you know what I find. Thanks!

  2. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    4 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!

  3. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    4 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!

  4. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    4 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!

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating
  • "Support was fantastic. Great bit of programming and we will be using it for the foreseeable future."

    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.