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.
#4045 - Erros in sugarcrm.log
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
-
"Hi there! I just wanted to drop a note and tell you that Chad Hutchins is a GREAT guy! He really helped me get setup with you guys and made it very..." - MNGHLLC
Read More Reviews
- Most Recent Love from Users
melissa- Westcoat
- Mark Westerhoff
- danielolivas
- kgm
- Evolution Marketing
5 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
5 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
5 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
5 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
5 years ago
Hello Heidi,
Sorry I was on something else. I've just send you the log file at mailchimp@fanaticallabs.com
Thanks,
Sylvain
5 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 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
5 years ago
Hi Heidi,
Thanks for the follow up.
Best, Sylvain
5 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