Repair database script

[wp.rauchholz]

As I got some strange behaviour from sugar 4.2, I ran he repair databsae script to see where the error could be. THe following is part of the message. How can I fix all this?


/* Table : relationships */
/*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 relationships modify column id char(36) NOT NULL
/*INDEXES/*
/* Table : acl_roles */
/*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 acl_roles modify column id char(36) NOT NULL
/*MISMATCH WITH DATABASE - date_entered - ROW [Field] => 'date_entered' [Type] => 'datetime' [Null] => 'NO' [Key] => '' [Default] => '0000-00-00 00:00:00' [Extra] => '' */
/* VARDEF - date_entered - ROW[Field] => 'date_entered' [Type] => 'datetime' [Null] => 'NO' [Key] => '' [Default] => '' [Extra] => '' */
alter table acl_roles modify column date_entered datetime NOT NULL
/*MISMATCH WITH DATABASE - date_modified - ROW [Field] => 'date_modified' [Type] => 'datetime' [Null] => 'NO' [Key] => '' [Default] => '0000-00-00 00:00:00' [Extra] => '' */
/* VARDEF - date_modified - ROW[Field] => 'date_modified' [Type] => 'datetime' [Null] => 'NO' [Key] => '' [Default] => '' [Extra] => '' */

..

[cywolf]

That's not error output, it's a summary of the changes SugarCRM would make to the database schema to make it consistent with the schema defined by SugarCRM. There's no real impact from the changes listed in that message, although it looks like you only posted part of the output. To perform the changes, just change the value of the drop-down on the Repair Database page to Execute SQL and run it again.