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

#3863 - Unable to DELETE accounts

Closed Bug? created by Jessica Chin Verified Purchase 7 months ago

Dear Sir/Madam,

I have just upgraded my SugarChimp to the latest version. My Sugar is 7. After upgrading, I am unable to delete accounts. It keeps popping an error message with codes.

HTTP: 500 Internal Server Error
An exception occurred while executing 'SELECT sugarchimpactivity_contacts.sugarchimpactivity_id id, sugarchimpactivity_contacts.date_created, sugarchimpactivity_contacts.date_entered FROM sugarchimpactivity INNER JOIN sugarchimpactivity_contacts sugarchimpactivity_contacts ON sugarchimpactivity_contacts.sugarchimpactivity_id = sugarchimpactivity.id WHERE (sugarchimpactivity_contacts.contact_id = ?) AND (sugarchimpactivity_contacts.deleted = ?)' with params ["e8659dd6-a28d-11e8-badc-06ef823b1b8a", 0]: Unknown column 'sugarchimpactivity_contacts.date_entered' in 'field list'

Help!

  1. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    7 months ago

    Hello Jessica,

    I apologize for any issues you are seeing from the upgrade. The latest version of SugarChimp added a new column to a few of our database tables. It seems that your columns were not added correctly. Can you go Admin > Repair > Quick Repair and Rebuild. At the bottom of the Repair page, it should ask you if you would like to execute a query to fix any discrepancies. Execute those queries and try the Account saving again.

    Let me know if that fixes you up.

    Thanks,
    Jon

    • cytan member avatar

      Jessica Chin Verified Purchase

      7 months ago

      Hi Jon,

      Thanks for your prompt response. It's fixed!

  2. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    7 months ago

    Hello Jessica,

    I'm glad to see it's fixed up for you. I'll go ahead and close this case out now. I see your other open case and have just responded. We'll get this cleared up!

    Thanks,
    Jon

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating
  • "We do a lot of highly-segmented outbound marketing and SugarChimp is exactly what we needed. The list and field syncing are great, and it allows us to do more sophisticated campaigns that exactly target certain Lead profiles in Sugar. The SugarChimp team is also really great, and they are totally committed to our success."

    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.