Results 1 to 2 of 2

Thread: vardef error during repair (related to customoizations)

  1. #1
    sptrsn is offline Sugar Community Member
    Join Date
    Dec 2007
    Posts
    18

    Default vardef error during repair (related to customoizations)

    We had some custom work done a while back. The first guy completely left us hanging. The second guy got it mostly working, but never really got it working 100%.

    So, here is one of the problems...
    When I run repair/rebuild. it generates this error.

    /* Table : raz_payments */
    /*COLUMNS*/
    /*MISMATCH WITH DATABASE - currency_id - ROW [name] => 'currency_id' [type] => 'char' [len] => '36' */
    /* VARDEF - currency_id - ROW[required] => '' [name] => 'currency_id' [vname] => 'LBL_CURRENCY' [type] => 'char' [massupdate] => '0' [comments] => '' [help] => '' [importable] => 'true' [duplicate_merge] => 'disabled' [duplicate_merge_dom_value] => '0' [audited] => '0' [reportable] => '0' [len] => '255' [studio] => 'visible' [function] => 'Array' [dbType] => 'id' */
    /* INDEXES */
    ALTER TABLE raz_payments modify column currency_id char(36) NUL

    Can someone suggest the best way to fix this. Should I modify the table or per the error msg suggestion.
    It won't do it on it's own.

    running 5.1 on shared webhost.

    Thanks,
    Steve

  2. #2
    Editha is offline Sugar Community Member
    Join Date
    Feb 2008
    Posts
    58

    Default Re: vardef error during repair (related to customoizations)

    I would try to change the vardefs.php of the concerned module.
    in <sugarroot>/modules/<your_module>/vardefs.php:

    'currency_id' => array (
    //-- check these fielddefs start
    'required' => true,
    'len' => '36',
    'type' => 'id',
    //-- check these fielddefs end

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Repair SQL Error after 5.0.0d patch
    By piccirm2 in forum Help
    Replies: 2
    Last Post: 2008-05-13, 10:37 AM
  2. Error with repair database
    By aheuermann in forum Help
    Replies: 1
    Last Post: 2006-08-31, 05:39 PM
  3. Error in repair screen
    By wjohnson in forum Help
    Replies: 1
    Last Post: 2006-08-24, 11:04 PM
  4. Error: Repair Config after 3.5.1d
    By metamaps in forum Help
    Replies: 0
    Last Post: 2005-11-23, 06:33 PM
  5. Repair Error
    By Ericmuc in forum Downloads
    Replies: 1
    Last Post: 2005-11-13, 04:41 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
  •