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

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

      a year ago

      Hi Jon,

      Thanks for your prompt response. It's fixed!

  2. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    a year 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
  • "The team is always proactive in assisting with any questions. Keep up the great work! Great product and great support!"

    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.