#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