#4008 - Unknown column 'sugarchimpactivity_contacts.date_entered' in 'field list'
Hello team,
We are running sugarCRM version 8.0.2 and Sugarchimp ultimate version 8.2.1a. When we try to merge two contacts, the merging status goes to 100% and then I get a 500 Internal Error with the message.
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 ["1785af20-c7***-11e8-a2**05056a0017b", 0]:
Unknown column 'sugarchimpactivity_contacts.date_entered' in 'field list'
I also checked the database for the column and I could only find date_created rather than date_entered.
Any help here would be much appreciated.
Thanks,
Ram
6 years ago