I am not sure how I did this but I keep getting a Mismatch with every QRR that won't go away.
It seems to be a false one. We are on 18.104.22.168 Pro. I updated the precision and length from Studio
the Extension shows the change
// created: 2016-07-26 13:51:42
/*MISMATCH WITH DATABASE - reseller_discount - ROW [name] => 'reseller_discount' [type] => 'decimal' [len] => '18,8' [default] => '0.00000000' */
/* VARDEF - reseller_discount - ROW[required] => '' [name] => 'reseller_discount' [vname] => 'LBL_RESELLER_DISCOUNT' [type] => 'decimal' [massupdate] => '' [default] => '' [no_default] => '' [comments] => '' [help] => '' [importable] => 'true' [duplicate_merge] => 'enabled' [duplicate_merge_dom_value] => '1' [audited] => '1' [reportable] => '1' [unified_search] => '' [merge_filter] => 'disabled' [full_text_search] => 'Array ( [boost] => 0 [enabled] => ) ' [calculated] => '' [len] => '18,8' [size] => '20' [enable_range_search] => '' [precision] => '8' [dbType] => 'decimal' */
ALTER TABLE wcont_contractpdetails modify COLUMN reseller_discount decimal(18,8) DEFAULT 0 NULL ;
The Alter Table executes, the resulting row in the table desc:
yet the mismatch just keeps on coming at every QRR,
any thoughts on how to fix this?