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.

Cancel at any time!
Free Trial

#3167 - Unable to Delete Accounts

Closed Bug? created by ITServices1 Verified Purchase a year 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

    a year 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

    a year 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

    a year 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

    a year 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
  • "Amazing product and amazing people. Thanks a lot for all the help at any question! :D"

    Read More Reviews

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.