Database Repair Issue

[kgeving]

When I run the Repair Database from Admin -> Repair, I receive the following error:

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


If I go into MySQL and manually change the data type on the two listed fields, I received the same error telling me the data types are reversed of what I just changed.

This appears to have happened since I upgraded to 4.5.0 from 4.2.1 several months ago. I just never noticed it. Now, I'm having problems upgrading to 4.5.1, so I'm checking my current system first and this issue came up.

Any help would be greatly appreciated!! Thank you!!


Keith


Sugar: 4.5.0b
OS: Mac OS X 10.4.9
PhP: 5.1
MySQL: 5.0.27
Server: Apache

[sacramentojoe]

Well, I know that the Repair Database pulls the indexes that are defined at the bottom of the var defs files in each module.
From this snippet, it appears it's trying to alter table 'files' but not sure what that is.
You might need to compare your vardefs files with NEW vardefs from an NON upgraded version.