Turn Marketing Data into Revenue Intelligence. SugarChimp seamlessly syncs your SugarCRM and Mailchimp data in both directions—no manual updates, no stale lists. This real-time connection arms your sales team with richer, more meaningful insights into customer behavior.
#3863 - Unable to DELETE accounts
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!
-
"Does a great job of syncing all of our registrant information. They go the extra mile with one-on-one support!"
Read More Reviews
7 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
7 years ago
Hi Jon,
Thanks for your prompt response. It's fixed!
7 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