Turn Marketing Data into Revenue Intelligence. SugarChimp seamlessly syncs your SugarCRM and Mailchimp data in both directions—no manual updates, no stale lists. This real-time connection arms your sales team with richer, more meaningful insights into customer behavior.
#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 ;
-
"The SugarChimp plugin was exactly what we needed to launch our Email Marketing from the contact base we had built in Sugar. Heidi gave clear steps and..." - Joell Denison
Read More Reviews
7 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