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.
#3809 - SugarcRM _Quick Repair_ warns of missing columns "date_entered"; but SugarChmp works! 8.01a
Sugarchimp works fine, For many months.
We ran Quick_Repair -first time for many months.
It warns of missing columns for SugarChimp tables -see below.
Should we allow QR to add those columns?
Our Setup
---------------
SugarChimp 8.01a
Sugar - 6.5.20
PHP - 5.6.31
MySQL - 5.7.19-1debian8
LInux- Ubuntu
-4.8.0-53-generic #56~16.04.1-Ubuntu SMP Tue May 16 01:18:56 UTC 2017 x86_64
-------------------------log form 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
please delete! this is a duplciate created in Error !
7 years ago
No problem, We'll close this case out and respond on the original.
Thanks! Jon