Results 1 to 6 of 6

Thread: Quick Repair and Rebuild Error

  1. #1
    KillJoy32670 is offline Junior Member
    Join Date
    Aug 2011
    Posts
    8

    Default Quick Repair and Rebuild Error

    When I do a quick repair and rebuild it runs through the entire process and then under the "Differences found between database and vardefs I get this

    /* 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 ;


    Once I hit execute I get a "Database error check sugarcrm.log for details"

    I am fairly new to sugar and I am looking for some help.

  2. #2
    andopes's Avatar
    andopes is offline A Sugar Hero | Help Forum Moderator
    Join Date
    Jul 2006
    Location
    São Paulo - Brazil
    Posts
    8,335

    Default Re: Quick Repair and Rebuild Error

    Probably there is some buggy extended vardefs which tries to update some field which doesn't exist on module Calls.
    Let us know the cached Calls vardefs, at cache/modules/Calls/Callvardefs.php

    Cheers
    André Lopes
    DevToolKit / Project of the Month - June 2009
    Lampada Global Services- Open Source Solutions
    Avenida Ipiranga, 318
    Bloco B - CJ 1602
    São Paulo, SP 01046-010
    Brazil
    Office: +55 11 3237-3110
    Mobile: +55 11 7636-5859
    e-mail: andre@lampadaglobal.com

    Lampada Global delivers offshore software development and support services to customers around the world.
    Lampada is proud to be a SugarCRM Gold Partner, revolutionizing Customer Relationship Management.

    I DO NOT answer questions through PM and Email. If you need some help post your question into SugarForum.

  3. #3
    KillJoy32670 is offline Junior Member
    Join Date
    Aug 2011
    Posts
    8

    Default Re: Quick Repair and Rebuild Error

    It is rather long.... not sure how to read it.
    Attached Files Attached Files

  4. #4
    andopes's Avatar
    andopes is offline A Sugar Hero | Help Forum Moderator
    Join Date
    Jul 2006
    Location
    São Paulo - Brazil
    Posts
    8,335

    Default Re: Quick Repair and Rebuild Error

    The issue is related to custom fields
    • history_c
    • reschedule_c

    which probably had been deleted but the extended vardefs for them are still loaded by SugarCRM.
    Delete the scripts with respect to them at custom/Extension/modules/Calls/Ext/Vardefs/, do a Quick Repair and Rebuild and try again.

    Cheers
    André Lopes
    DevToolKit / Project of the Month - June 2009
    Lampada Global Services- Open Source Solutions
    Avenida Ipiranga, 318
    Bloco B - CJ 1602
    São Paulo, SP 01046-010
    Brazil
    Office: +55 11 3237-3110
    Mobile: +55 11 7636-5859
    e-mail: andre@lampadaglobal.com

    Lampada Global delivers offshore software development and support services to customers around the world.
    Lampada is proud to be a SugarCRM Gold Partner, revolutionizing Customer Relationship Management.

    I DO NOT answer questions through PM and Email. If you need some help post your question into SugarForum.

  5. #5
    KillJoy32670 is offline Junior Member
    Join Date
    Aug 2011
    Posts
    8

    Default Re: Quick Repair and Rebuild Error

    Thanks so much. That worked for the database. Unfortunately all of this happened while updating. So now, even after the database repair, if I go back to the update wizard, and it takes me directly to the commit upgrade screen. I hit next, and nothing happens.

    Attached is my update wizard log. Appears to be something with my js style?

    Thanks for your help.
    Attached Files Attached Files

  6. #6
    KillJoy32670 is offline Junior Member
    Join Date
    Aug 2011
    Posts
    8

    Default Re: Quick Repair and Rebuild Error

    not sure what I did.... but the update completed normally after a couple of attempts.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Quick Repair and Rebuild
    By lcurrie in forum Help
    Replies: 5
    Last Post: 2010-09-23, 10:40 PM
  2. Cannot do Quick Repair and Rebuild
    By milkesd in forum Help
    Replies: 9
    Last Post: 2010-04-19, 12:34 AM
  3. Errore dopo il Quick Repair and Rebuild
    By coniglio in forum Italiano
    Replies: 1
    Last Post: 2008-05-05, 02:48 PM
  4. Replies: 1
    Last Post: 2008-04-10, 01:19 PM
  5. Lost Portion of Quick Repair and Rebuild
    By johnnyo2 in forum Help
    Replies: 2
    Last Post: 2008-03-02, 06:14 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
  •