Message; Differences found between database and vardefs??
Hi,
When i want to try quick repair and rebuild, i get the following message;
/* Table : comp_complaints_projecten */
/*COLUMNS*/
/*MISMATCH WITH DATABASE - invoice_amount - ROW [name] => 'invoice_amount' [type] => 'float' [len] => '' */
/* VARDEF - invoice_amount - ROW[required] => '' [name] => 'invoice_amount' [vname] => 'LBL_INVOICE_AMOUNT' [type] => 'float' [massupdate] => '0' [comments] => '' [help] => 'invoice amount' [importable] => 'true' [duplicate_merge] => 'disabled' [duplicate_merge_dom_value] => '0' [audited] => '1' [reportable] => '0' [len] => '10' [precision] => '0' [dbType] => 'float' */
/*MISMATCH WITH DATABASE - discount_amount - ROW [name] => 'discount_amount' [type] => 'float' [len] => '' */
/* VARDEF - discount_amount - ROW[required] => '' [name] => 'discount_amount' [vname] => 'LBL_DISCOUNT_AMOUNT ' [type] => 'float' [massupdate] => '0' [comments] => '' [help] => 'discount amount' [importable] => 'true' [duplicate_merge] => 'disabled' [duplicate_merge_dom_value] => '0' [audited] => '1' [reportable] => '0' [len] => '10' [precision] => '0' [dbType] => 'float' */
/* INDEXES */
ALTER TABLE comp_complaints_projecten modify column invoice_amount float(10) NULL , modify column discount_amount float(10) NULL ;
Does anybody knows what this message means and how i can fix this? Thankssssss
Much appreciate
Kind regards,
De Kleine Media
SugarCRM CE v.5.2.0h
Windows platform
MySQL v.5.1
phpMyAdmin - 2.11.2.2
Apache Server v.2.0
Bookmarks