#3808 - Sugar 'Quick Repair' warns of missing columns 'date_entered' -But Sugarchimp is working! (8.01a)
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 ;
6 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