Quick Repair and Rebuild - Mismatch with Database

[jeffbrumbaugh]

We have upgraded from Pro version 5.0.0f to 5.1.0 and when we run a "Quick Repair and Rebuild" we receive the following:

/* Table : report_cache */
/*COLUMNS*/
/*MISMATCH WITH DATABASE - contents - ROW [name] => 'contents' [type] => 'image' [len] => '2147483647' */
/* VARDEF - contents - ROW[name] => 'contents' [type] => 'text' [comment] => 'contents of report object' [default] => '' [dbType] => 'text' [len] => '' */
ALTER TABLE report_cache ALTER COLUMN contents text NULL ;

/*MISMATCH WITH DATABASE - deleted - ROW [name] => 'deleted' [type] => 'varchar' [len] => '1' [default] => '0' */
/* VARDEF - deleted - ROW[name] => 'deleted' [type] => 'varchar' [len] => '1' [required] => 'true' [dbType] => 'varchar' */
ALTER TABLE report_cache DROP CONSTRAINT DF__report_ca__delet__309193BF ALTER TABLE report_cache ALTER COLUMN deleted varchar(1) NOT NULL ;

/* INDEXES */
/* Table : linked_documents */
/*COLUMNS*/
/* INDEXES */
/*MISSING INDEX IN DATABASE - idx_parent_document -index ROW */
create index idx_parent_document on linked_documents ( parent_type, parent_id, document_id );

When I execute the script inside the Repair & Rebuild section, I receive an error saying SQL can't convert report_cache.contents to text.

Any thoughts on how we can fix this?

[maloner]

Hi Jeff,

I am getting the same error after installing a custom module. Did you fix this?

Thanks,

James

[agcopley]

Hi Jeff,

I am getting the same error after installing a custom module. Did you fix this?

Thanks,

James

Thats becasue there is data in the table.
backup table, truncate table, rerun script, reload script.