#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'
7 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
7 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
7 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
7 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