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. Created by Fanatical Labs, 2023 SugarCRM Partner Award Winner.

Free Trial

By clicking you consent to share your profile with the developer

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

Closed General Question created by DJuserDJ Verified Purchase 5 years 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

    5 years 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
  • "The team is always proactive in assisting with any questions. Keep up the great work! Great product and great support!"

    Read More Reviews