by Fanatical Labs

Save Your Team Countless Hours. SugarChimp syncs your lists in both directions so that you can work in your preferred application. Segment and Group your MailChimp subscribers based on SugarCRM data so you can market to the right people at the right time. Fully compatible with all versions and editions of Sugar and SuiteCRM.

Free 30 day trial
Try it Now

#3809 - SugarcRM _Quick Repair_ warns of missing columns "date_entered"; but SugarChmp works! 8.01a

Closed General Question created by DJuserDJ Verified Purchase a year ago

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 ;

  1. DJuserDJ member avatar

    DJuserDJ Verified Purchase

    a year ago

    please delete! this is a duplciate created in Error !

  2. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    a year ago

    No problem, We'll close this case out and respond on the original.

    Thanks!
    Jon

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating
  • "Nice product and nice team behind it. They helped us with everything we needed in order to get our system working as we wanted to."

    Read More Reviews

Keep up to date on the latest additions

We'll send you an email every month with handpicked add-ons, reviews, tricks and tips. Don't worry, we hate spam as much as you do.