Results 1 to 3 of 3

Thread: Message; Differences found between database and vardefs??

  1. #1
    dekleinemedia is offline A Prolific Poster
    Join Date
    May 2009
    Location
    Netherlands
    Posts
    241

    Default Message; Differences found between database and vardefs??

    Hi,

    When i want to try quick repair and rebuild, i get the following message;

    /* Table : comp_complaints_projecten */
    /*COLUMNS*/
    /*MISMATCH WITH DATABASE - invoice_amount - ROW [name] => 'invoice_amount' [type] => 'float' [len] => '' */
    /* VARDEF - invoice_amount - ROW[required] => '' [name] => 'invoice_amount' [vname] => 'LBL_INVOICE_AMOUNT' [type] => 'float' [massupdate] => '0' [comments] => '' [help] => 'invoice amount' [importable] => 'true' [duplicate_merge] => 'disabled' [duplicate_merge_dom_value] => '0' [audited] => '1' [reportable] => '0' [len] => '10' [precision] => '0' [dbType] => 'float' */
    /*MISMATCH WITH DATABASE - discount_amount - ROW [name] => 'discount_amount' [type] => 'float' [len] => '' */
    /* VARDEF - discount_amount - ROW[required] => '' [name] => 'discount_amount' [vname] => 'LBL_DISCOUNT_AMOUNT ' [type] => 'float' [massupdate] => '0' [comments] => '' [help] => 'discount amount' [importable] => 'true' [duplicate_merge] => 'disabled' [duplicate_merge_dom_value] => '0' [audited] => '1' [reportable] => '0' [len] => '10' [precision] => '0' [dbType] => 'float' */
    /* INDEXES */
    ALTER TABLE comp_complaints_projecten modify column invoice_amount float(10) NULL , modify column discount_amount float(10) NULL ;

    Does anybody knows what this message means and how i can fix this? Thankssssss

    Much appreciate
    Kind regards,

    De Kleine Media


    SugarCRM CE v.5.2.0h
    Windows platform
    MySQL v.5.1
    phpMyAdmin - 2.11.2.2
    Apache Server v.2.0

  2. #2
    sugarcane is offline Sugar Community Member
    Join Date
    Apr 2005
    Location
    Chicago, IL
    Posts
    1,207

    Default Re: Message; Differences found between database and vardefs??

    this just means that there is a difference between the database and your vardefs. This usually occurs when you create new fields in the code or upload a patch which contains new fields or modules.

    Simply hit the 'Execute' button that appears below and then you should be fine.
    Intelestream has a great deal of experience hosting and customizing the SugarCRM application. Our company is made up by former employees of SugarCRM, and together we have over 50 years of experience working with the application. To learn more about us, please visit our website at www.intelestream.net or contact us directly at 800-391-4055 or by email at info@intelestream.net

  3. #3
    dekleinemedia is offline A Prolific Poster
    Join Date
    May 2009
    Location
    Netherlands
    Posts
    241

    Thumbs up Re: Message; Differences found between database and vardefs??

    Okay, thanks. Now i know why this message has shown.

    Much appreciate
    Kind regards,

    De Kleine Media


    SugarCRM CE v.5.2.0h
    Windows platform
    MySQL v.5.1
    phpMyAdmin - 2.11.2.2
    Apache Server v.2.0

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Database Support was not found.
    By jfill in forum Installation and Upgrade Help
    Replies: 2
    Last Post: 2011-12-19, 01:26 PM
  2. Replies: 11
    Last Post: 2010-03-19, 04:38 PM
  3. No Record found : Message in Quick serch
    By paraggoel in forum Developer Help
    Replies: 0
    Last Post: 2009-04-22, 10:09 AM
  4. Database Not Found
    By chrislynch8 in forum Installation and Upgrade Help
    Replies: 2
    Last Post: 2007-10-25, 09:35 AM
  5. Replies: 3
    Last Post: 2006-03-21, 10:24 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •