AnsweredAssumed Answered

Mismatch even after running SQL

Question asked by Francesca Shiekh on Jul 26, 2016
Latest reply on Aug 25, 2017 by Francesca Shiekh

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 7.6.2.1 Pro. I updated the precision and length from Studio

the Extension shows the change

 

// created: 2016-07-26 13:51:42

$dictionary['wcont_ContractPDetails']['fields']['reseller_discount']['len']='18';

$dictionary['wcont_ContractPDetails']['fields']['reseller_discount']['precision']=8;

 

/*COLUMNS*/

/*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:

reseller_discountdecimal(18,8)YES0.00000000

 

yet the mismatch just keeps on coming at every QRR,

any thoughts on how to fix this?

thanks,
FrancescaS

Outcomes