5.0.0.i Repair Database for emails_text generates bad ALTER TABLE?
After upgrading from 4.5.1d to 5.0.0i on the SiteGround hosting service (Linux/Apache/PHP 5.1.6), the 5.0.0->5.2 upgrade is hanging.
I tried repairing the database before retrying and most of the syncing went fine, but there is a vardefs/database sync item that is not going through:
/* Table : emails_text */
/*COLUMNS*/
/*MISMATCH WITH DATABASE - email_id - ROW [Field] => 'email_id' [Type] => 'varchar(36)' [Null] => 'NO' [Key] => 'PRI' [Default] => '' [Extra] => '' */
/* VARDEF - email_id - ROW[Field] => 'email_id' [Type] => 'varchar(36)' [Null] => 'NO' [Key] => 'PRI' [Default] => '' [Extra] => '' */
/* INDEXES */
ALTER TABLE emails_text modify column email_id varchar(36) NULL ;
Here are the problems I see:
- There doesn't seem to be a mismatch between the database column email_id and the vardef according to the comments, and
- The ALTER TABLE statement generated tries to make the primary key email_id NULLable.
Should I just ignore this "mismatch" repair script? If not, what should I do?
John Benson
Codeasaurus Rex
Bookmarks