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

#4008 - Unknown column 'sugarchimpactivity_contacts.date_entered' in 'field list'

Closed Bug? created by webdev1 Verified Purchase 6 months ago

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-a205056a0017b", 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

  1. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    6 months ago

    Hi Ram,

    Happy to help. Can you complete a Repair and Rebuild? Doing so will run a query that should resolve this issue. Steps for completing a Repair and Rebuild are below:

    1. From Sugar, navigate to Admin
    2. Under System, click Repair
    3. Click Quick Repair and Rebuild to start the process

    Please let me know if continue to run into any issues after this process is complete.

    Best,
    Heidi

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating
  • "Support was fantastic. Great bit of programming and we will be using it for the foreseeable future."

    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.