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.
#3167 - Unable to Delete Accounts
After installing SugarChimp, i am unable to delete account records. I am using the On-Demand version of SugarCRM. I've contacted SugarCRM support and they refered me to SugarChimp. Here is the error that i'm receiving:
HTTP: 500 Internal Server Error An exception occurred while executing 'SELECT sugarchimpactivity_accounts.0 id, sugarchimpactivity_accounts.1 sugarchimpactivity_id, sugarchimpactivity_accounts.2 account_id, sugarchimpactivity_accounts.3 date_created, sugarchimpactivity_accounts.4 date_modified, sugarchimpactivity_accounts.5 deleted FROM sugarchimpactivity INNER JOIN sugarchimpactivity_accounts sugarchimpactivity_accounts ON sugarchimpactivity_accounts.sugarchimpactivity_id = sugarchimpactivity.id WHERE (sugarchimpactivity_accounts.account_id = ?) AND (sugarchimpactivity_accounts.deleted = ?)' with params ["a08a38d6-551e-11e7-b546-06eb7fcc0457", 0]: Unknown column 'sugarchimpactivity_accounts.0' in 'field list'
-
"Support was fantastic. Great bit of programming and we will be using it for the foreseeable future."
Read More Reviews
- Most Recent Love from Users
melissa- Westcoat
- Mark Westerhoff
- danielolivas
- kgm
- Evolution Marketing
6 years ago
Hello,
Thank you for reaching out and letting us know of the issue. I apologize for the trouble. In certain cases in Sugar 7.9, we are able to replicate the error you've found. Thus, we should be able to pinpoint the problem and get a resolution out shortly. This is our top priority, so we will get back to you as soon as we need more information or have found the solution.
Thanks for your patience, I will update as soon as possible.
Kind Regards, Jon
6 years ago
Hello again,
We were able to resolve the issues with our package and SugarCRM 7.9. We've coordinated our SugarChimp 7.9.0 release with this SugarCRM 7.9 compatibility. You can download the latest package from your Purchases page, and install it over the top of your previous installation. There is no need to uninstall or disable the old SugarChimp package. Once the new one is installed in Sugar, check the Account removal and let me know if the issue is resolved.
Thanks, Jon
6 years ago
Hello,
Can you confirm that everything is working as intended now after installing the new package? Is there anything else we can help you with?
Thanks, Jon
6 years ago
Hello,
I'm going to close this case out now, as I see you've installed the compatible version of the software. Let us know if you need anything else!
Thanks, Jon