Repair Database does not

[mmakowski]

MySQL 4.1.12
Windows 2003 Web Edition
System Windows NT PLATO 5.2 build 3790
Build Date Jan 11 2006 16:35:21
Configure Command cscript /nologo configure.js "--enable-snapshot-build" "--with-gd=shared"
Server API Apache 2.0 Handler
Virtual Directory Support enabled
Configuration File (php.ini) Path C:\WINDOWS\php.ini
PHP API 20041225
PHP Extension 20050922
Zend Extension 220051025
Debug Build no
Thread Safety enabled
Zend Memory Manager enabled
IPv6 Support enabled
Registered PHP Streams php, file, http, ftp, compress.zlib
Registered Stream Socket Transports tcp, udp
Registered Stream Filters convert.iconv.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, zlib.*

I did Repair Database on 4.5.0h and the following entries appear. They will not go away - even after telling it to Execute SQL. Also did a fresh 4.5h full install and pointed it to the same database. The messages persist. I have verified in mySql that the database tables have varchar(3) in them (which I suppose is correct) but I can't figure out out where the unmatching VARDEF char(3) entries are coming from. Everything appears to be functioning OK but I have a feeling that this is going to bite me somewhere along the way.



/* Table : leads */
/*COLUMNS/*
/*MISMATCH WITH DATABASE - do_not_call - ROW [Field] => 'do_not_call' [Type] => 'varchar(3)' [Null] => 'YES' [Key] => '' [Default] => '0' [Extra] => '' */
/* VARDEF - do_not_call - ROW[Field] => 'do_not_call' [Type] => 'char(3)' [Null] => 'YES' [Key] => '' [Default] => '0' [Extra] => '' */
alter table leads modify column do_not_call varchar(3) DEFAULT '0' NULL
/*MISMATCH WITH DATABASE - email_opt_out - ROW [Field] => 'email_opt_out' [Type] => 'varchar(3)' [Null] => 'YES' [Key] => '' [Default] => '0' [Extra] => '' */
/* VARDEF - email_opt_out - ROW[Field] => 'email_opt_out' [Type] => 'char(3)' [Null] => 'YES' [Key] => '' [Default] => '0' [Extra] => '' */
alter table leads modify column email_opt_out varchar(3) DEFAULT '0' NULL
/*INDEXES/*
/* Table : contacts */
/*COLUMNS/*
/*MISMATCH WITH DATABASE - do_not_call - ROW [Field] => 'do_not_call' [Type] => 'varchar(3)' [Null] => 'YES' [Key] => '' [Default] => '0' [Extra] => '' */
/* VARDEF - do_not_call - ROW[Field] => 'do_not_call' [Type] => 'char(3)' [Null] => 'YES' [Key] => '' [Default] => '0' [Extra] => '' */
alter table contacts modify column do_not_call varchar(3) DEFAULT '0' NULL
/*MISMATCH WITH DATABASE - email_opt_out - ROW [Field] => 'email_opt_out' [Type] => 'varchar(3)' [Null] => 'YES' [Key] => '' [Default] => '0' [Extra] => '' */
/* VARDEF - email_opt_out - ROW[Field] => 'email_opt_out' [Type] => 'char(3)' [Null] => 'YES' [Key] => '' [Default] => '0' [Extra] => '' */
alter table contacts modify column email_opt_out varchar(3) DEFAULT '0' NULL
/*INDEXES/*
/* Table : email_templates */
/*COLUMNS/*
/*MISMATCH WITH DATABASE - published - ROW [Field] => 'published' [Type] => 'varchar(3)' [Null] => 'YES' [Key] => '' [Default] => '' [Extra] => '' */
/* VARDEF - published - ROW[Field] => 'published' [Type] => 'char(3)' [Null] => 'YES' [Key] => '' [Default] => '' [Extra] => '' */
alter table email_templates modify column published varchar(3) NULL
/*INDEXES/*
/* Table : currencies */
/*COLUMNS/*
/*MISMATCH WITH DATABASE - iso4217 - ROW [Field] => 'iso4217' [Type] => 'varchar(3)' [Null] => '' [Key] => '' [Default] => '' [Extra] => '' */
/* VARDEF - iso4217 - ROW[Field] => 'iso4217' [Type] => 'char(3)' [Null] => '' [Key] => '' [Default] => '' [Extra] => '' */
alter table currencies modify column iso4217 varchar(3) NOT NULL
/*INDEXES/*
/* Table : import_maps */
/*COLUMNS/*
/*MISMATCH WITH DATABASE - is_published - ROW [Field] => 'is_published' [Type] => 'varchar(3)' [Null] => '' [Key] => '' [Default] => 'no' [Extra] => '' */
/* VARDEF - is_published - ROW[Field] => 'is_published' [Type] => 'char(3)' [Null] => '' [Key] => '' [Default] => 'no' [Extra] => '' */
alter table import_maps modify column is_published varchar(3) DEFAULT 'no' NOT NULL
/*INDEXES/*
/* Table : prospects */
/*COLUMNS/*
/*MISMATCH WITH DATABASE - do_not_call - ROW [Field] => 'do_not_call' [Type] => 'varchar(3)' [Null] => 'YES' [Key] => '' [Default] => '0' [Extra] => '' */
/* VARDEF - do_not_call - ROW[Field] => 'do_not_call' [Type] => 'char(3)' [Null] => 'YES' [Key] => '' [Default] => '0' [Extra] => '' */
alter table prospects modify column do_not_call varchar(3) DEFAULT '0' NULL
/*MISMATCH WITH DATABASE - email_opt_out - ROW [Field] => 'email_opt_out' [Type] => 'varchar(3)' [Null] => 'YES' [Key] => '' [Default] => '0' [Extra] => '' */
/* VARDEF - email_opt_out - ROW[Field] => 'email_opt_out' [Type] => 'char(3)' [Null] => 'YES' [Key] => '' [Default] => '0' [Extra] => '' */
alter table prospects modify column email_opt_out varchar(3) DEFAULT '0' NULL
/*INDEXES/*
/* Table : documents */
/*COLUMNS/*
/*MISMATCH WITH DATABASE - mail_merge_document - ROW [Field] => 'mail_merge_document' [Type] => 'varchar(3)' [Null] => 'YES' [Key] => '' [Default] => 'off' [Extra] => '' */
/* VARDEF - mail_merge_document - ROW[Field] => 'mail_merge_document' [Type] => 'char(3)' [Null] => 'YES' [Key] => '' [Default] => 'off' [Extra] => '' */
alter table documents modify column mail_merge_document varchar(3) DEFAULT 'off' NULL
/*INDEXES/*
/* Table : */

[mmakowski]

Somehow this corrected itself. I just left it alone for few days and when I did "repair" later it showed no exceptions. Very strange.