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

#4045 - Erros in sugarcrm.log

Closed Bug? created by sgreze 2 years ago

Hello,

We have recuring errors appearing in the sugarcrm.log. They appear in the sugarcrm.log because it doesn't manage to send it by email.

Here is the content of the error:

Error: An exception occurred while executing 'INSERT INTO sugarchimpactivity (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, activity, timestamp, url, ip, mailchimp_list_id, mailchimp_campaign_id, include_empty, assigned_user_id) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params .......
[a lot of lines] (confidential)
................
Data too long for column 'description' at row 1

Thank you for your help,

Regards,

Sylvain

  1. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    2 years ago

    Hi Sylvain,

    Thanks for reaching out. Can you tell me the version of SugarChimp you're using? You can see this information by navigating to Health Status from within the Administration page.

    In addition to the error below, are your clients seeing any performance issues with SugarChimp or have you just noticed this error?

    Thanks,
    Heidi

    • sgreze member avatar

      sgreze

      2 years ago

      Hello Heidi,

      We are using 8.2.1a.
      Our client is not complaining, we have noticed the error when we were investigating another problem.

      Thank you

  2. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    2 years ago

    Hi Sylvain,

    Thanks for your patience while I looked further into this. To troubleshoot further, can you put SugarChimp into debug mode and send us the full error? To maintain privacy you can send it to mailchimp@fanaticallabs.com.

    To put SugarChimp into debug mode, follow these directions: Within Sugar Admin, navigate to SugarChimp's Health Status page. Open the console by right-clicking the background and choosing 'inspect'. Find the Console tab, and type in:

    SUGAR.App.api.call('CREATE',SUGAR.App.api.buildURL('SugarChimp/setting/logger/debug'),{},{});

    You can return SugarChimp to it's normal logger level by using the command below:

    SUGAR.App.api.call('CREATE',SUGAR.App.api.buildURL('SugarChimp/setting/logger/normal'),{},{});

    We'd like to take a look at the full log to see if something is failing or broken.

    Thanks for your help in troubleshooting.

    Best,
    Heidi

  3. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    2 years ago

    Hello there,

    We haven't heard from you regarding the issue in a few days. Is there anything we can help with?

    Let me know how I can help.

    Thanks,
    Heidi
    Fanatical Labs Support

    • sgreze member avatar

      sgreze

      2 years ago

      Hello Heidi,

      Sorry I was on something else. I've just send you the log file at mailchimp@fanaticallabs.com

      Thanks,

      Sylvain

  4. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    2 years ago

    Hi Sylvain,

    No worries. Thanks for sending that along. We're working on a solution and will follow up again shortly.

    Best,
    Heidi

  5. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    2 years ago

    Hi Sylvain,

    Just wanted to quickly follow up here to let you know we're still working on a solution. I'll follow up again when I have it ready for you.

    Thanks,
    Heidi

    • sgreze member avatar

      sgreze

      2 years ago

      Hi Heidi,

      Thanks for the follow up.

      Best,
      Sylvain

  6. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    2 years ago

    Hi Sylvain,

    Thanks for your patience! This issue has been resolved in our most recent version, which has been uploaded to the Purchases page here on SugarOutfitters. More information on installing the latest version can be found here: https://fanaticallabs.zendesk.com/hc/en-us/articles/360004608392-Update-to-the-latest-version-of-SugarChimp

    Please let me know if you have any further trouble!

    Heidi

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating

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.