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

#3808 - Sugar 'Quick Repair' warns of missing columns 'date_entered' -But Sugarchimp is working! (8.01a)

Closed General Question created by DJuserDJ Verified Purchase 8 months ago

Our SugarChimp is working fine as far as we can tell.
For many months.
We have just run Sugar's Quick Repair - for the first time in many months.

We noticed it warns of some missing columns - as below.

Should we allow Sugar to add these columns?

thanks!

Our Setup

  • Linux
  • 4.8.0-53-generic #56~16.04.1-Ubuntu SMP Tue May 16 01:18:56 UTC 2017 x86_64
  • SugarChimp Version: 8.0.1a
  • SugarChimp Edition: basic
  • SugarCRM CE - 'sugar_version' => '6.5.20',
  • nginx/1.13.3
  • PHP/5.6.31
  • MySQL 5.7.19-1debian8

Text from 'Quick Repair'

/* Table : sugarchimpactivity_contacts /
/
COLUMNS/
/
MISSING IN DATABASE - date_entered - ROW/
/
INDEXES */
ALTER TABLE sugarchimpactivity_contacts add COLUMN date_entered datetime NULL ;

/* Table : sugarchimpactivity_prospects /
/
COLUMNS/
/
MISSING IN DATABASE - date_entered - ROW/
/
INDEXES */
ALTER TABLE sugarchimpactivity_prospects add COLUMN date_entered datetime NULL ;

/* Table : sugarchimpactivity_accounts /
/
COLUMNS/
/
MISSING IN DATABASE - date_entered - ROW/
/
INDEXES */
ALTER TABLE sugarchimpactivity_accounts add COLUMN date_entered datetime NULL ;

/* Table : sugarchimpactivity_leads /
/
COLUMNS/
/
MISSING IN DATABASE - date_entered - ROW/
/
INDEXES */
ALTER TABLE sugarchimpactivity_leads add COLUMN date_entered datetime NULL ;

  1. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    8 months ago

    Hello DJ,

    We added the date_entered column for those records on a recent update. It is only used internally so you probably don't see any difference in the integration currently. You should go ahead and update the database to the new definitions.

    Let me know if you have any other questions.

    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

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.