Results 1 to 1 of 1

Thread: Error in "Repair Database" function whith 4.2.1

  1. #1
    cibo001 is offline Sugar Community Member
    Join Date
    Jul 2006
    Posts
    12

    Angry Error in "Repair Database" function with 4.2.1

    I have errors when I try to view details contact
    I Try to run the function "Repair database" to investigate problem
    I have this warning:

    ==============
    Repair Database:execute Print Help

    Warning: mysql_query() [http://www.mysql.com/doc]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 in c:\Inetpub\wwwroot\crm\include\database\MysqlManag er.php on line 142
    /* 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)
    /*INDEXES/*
    /* Table : acl_roles_actions */
    /*COLUMNS/*
    /*INDEXES/*
    /*MISSING INDEX IN DATABASE - idx_aclactions_roles -index ROW/*
    ALTER TABLE acl_roles_actions ADD
    ===========

    I am using mysql5 and IIS and it seems I have to modify something in the sintax of parameter $sql in function mysql_query() but I do not know where.

    I am in very difficult. I hope can use Sugarcrm But whit this problem is not possible.
    Many thanks to who can help me

    mario cibola
    Attached Files Attached Files
    Last edited by cibo001; 2006-07-11 at 05:47 PM. Reason: some little errors

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
  •