Results 1 to 3 of 3

Thread: Quick Repair -- Differences Found between database and vardefs -- missing in database

  1. #1
    battle is offline Member
    Join Date
    Apr 2009
    Posts
    7

    Default Quick Repair -- Differences Found between database and vardefs -- missing in database

    I upgraded from 6.1.4. to 6.1.6 on a mac.

    I got a database failure message. I couldn't locate the sugarcrm.log so I just ran QuickRepair and got the following message.

    Differences found between database and vardefs

    It suggests I run the following script...
    /* Table : calls */
    /*COLUMNS*/
    /*MISSING IN DATABASE - - ROW*/
    /*MISSING IN DATABASE - - ROW*/
    /* INDEXES */
    ALTER TABLE calls add column 0 DEFAULT '0' NULL ,add column NULL ,add column NULL , add column 0 DEFAULT '0' NULL ,add column NULL ,add column NULL ;

    I am unclear on what this will actually do, and what is missing in the data base row.

  2. #2
    kbrill's Avatar
    kbrill is offline SugarCRM PS Engineer
    Join Date
    Jul 2004
    Location
    St Louis, MO
    Posts
    3,183

    Default Re: Quick Repair -- Differences Found between database and vardefs -- missing in data

    Do you have anything in

    custom/modules/Calls/Ext/vardefs

    I would also look into permissions and get the log file working again. It might really help here.
    Kenneth Brill - Help Forum Moderator

    I do not respond to 'Private Messages'. Please email me directly instead

    When asking for help, PLEASE give us your Server Information and Version Numbers as asked for on the 'Post New Message' screen as well as any JavaScript errors shown at the bottom of the browser window.
    Help us Help You

  3. #3
    battle is offline Member
    Join Date
    Apr 2009
    Posts
    7

    Default Re: Quick Repair -- Differences Found between database and vardefs -- missing in data

    OK. I located the log and discovered the %c date set up had been over written by a hard date e.g. 12/31/2010 so there were no accurate dates and times in the log.

    So... I downgraded back to 6.1.4 to fix the log problem. I set it to warn and above. I did a quick repair, repair activiites, and repair non lower case fields all of which ran successfully.

    Everything seemed to be working OK except that reschedule call add on module was not updating the history field. So I went ahead and upgraded again using the wizard from 6.1.4 to 6.1.6 on mac osx 10.6.7.

    I do have some custom modules and layouts. I particular I am using reschedule call and have modified the layouts to handle the reschedule drop down and history fields.

    The file at custom/modules/Calls/Ext/vardefs after the update contains
    <?php
    //WARNING: The contents of this file are auto-generated
    // created: 2011-02-15 10:40:33
    $dictionary['Call']['fields']['direction']['default']='Outbound';
    // created: 2011-02-15 14:24:32
    $dictionary['Call']['fields']['duration_minutes']['default']='05';
    // created: 2011-06-09 16:26:34
    // created: 2011-06-09 16:26:02
    ?>

    So after the update calls will not edit correctly. When I go to save them sugar dumps out to the search window with the subject of the call in the search field. The edits are not saved.

    In any case it looks like I will probably downgrade again, disable the reschedule calls module, delete the custom fields for it, and then upgrade back to 6.1.6...

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Quick Repair: Mismatch with Database
    By Ali Akbar in forum Help
    Replies: 0
    Last Post: 2011-03-18, 06:10 AM
  2. Quick Repair and Rebuild - Mismatch with Database
    By jeffbrumbaugh in forum Help
    Replies: 2
    Last Post: 2010-03-24, 11:31 AM
  3. Replies: 11
    Last Post: 2010-03-19, 04:38 PM
  4. Replies: 2
    Last Post: 2009-07-05, 08:03 PM
  5. Replies: 2
    Last Post: 2009-06-23, 09:23 AM

Tags for this Thread

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
  •