by Fanatical Labs

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.

Free Trial

By clicking you consent to share your profile with the developer

#3167 - Unable to Delete Accounts

Closed Bug? created by ITServices1 Verified Purchase 7 years ago

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'

  1. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    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

  2. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    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

  3. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    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

  4. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    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

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