Results 1 to 1 of 1

Thread: Repair Database Not Working (Well maybe not)

  1. #1
    roland3000 is offline Sugar Community Member
    Join Date
    Oct 2006
    Posts
    13

    Default Repair Database Not Working (Well maybe not)

    Not sure if it's actually doing anything but this has shown up ever since SUGAR 4 came out this year.

    When you click display SQL or execute SQL it always says

    /* Table : files */
    /*COLUMNS/*
    /*MISMATCH WITH DATABASE - id - ROW [Field] => 'id' [Type] => 'varchar(36)' [Null] => 'NO' [Key] => 'PRI' [Default] => '' [Extra] => '' */
    /* VARDEF - id - ROW[Field] => 'id' [Type] => 'char(36)' [Null] => 'NO' [Key] => 'PRI' [Default] => '' [Extra] => '' */
    alter table files modify column id char(36) NOT NULL
    /*MISMATCH WITH DATABASE - assigned_user_id - ROW [Field] => 'assigned_user_id' [Type] => 'varchar(36)' [Null] => 'YES' [Key] => 'MUL' [Default] => '' [Extra] => '' */
    /* VARDEF - assigned_user_id - ROW[Field] => 'assigned_user_id' [Type] => 'char(36)' [Null] => 'YES' [Key] => '' [Default] => '' [Extra] => '' */
    alter table files modify column assigned_user_id char(36) NULL
    /*INDEXES/*
    /* Table : */

    It never goes away. Is it actually doing anything? Regardless how many times you reinstall, executeSQL, display etc.. it always has shown this message.

    Note this shows even for a fresh install with only 1 user in it.

    Currently using 4.5.0d but has been like this for all previous versions of 4.x.x
    Last edited by roland3000; 2006-10-10 at 06:39 AM.

Thread Information

Users Browsing this Thread

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

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
  •