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.

Free 30 day trial
Try it Now

By clicking you consent to share your profile with the developer

#3863 - Unable to DELETE accounts

Closed Bug? created by Kwek Jian Wen Verified Purchase 3 years 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

    3 years 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

      Kwek Jian Wen Verified Purchase

      3 years ago

      Hi Jon,

      Thanks for your prompt response. It's fixed!

  2. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    3 years 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
  • "SugarChimp is exactly what we needed, it syncs nicely between MailChimp and Sugar. The added MailChimp dashlet is very sophisticated. Works great – thank you!"

    Read More Reviews