Hello, I upgraded to 7-10-1 today and when i Check and repair SuiteCRM with the following, Quick Repair and Rebuild I receive the following:
/* Table : oauth2clients */
/*COLUMNS*/
/*MISMATCH WITH DATABASE - duration_value - ROW [name] => 'duration_value' [type] => 'int' [len] => '11' */
/* VARDEF - duration_value - ROW[name] => 'duration_value' [type] => 'integer' [required] => '' [reportable] => '' [api-visible] => '' [inline_edit] => '' [dbType] => 'integer' [len] => '' */
/*MISMATCH WITH DATABASE - duration_amount - ROW [name] => 'duration_amount' [type] => 'int' [len] => '11' */
/* VARDEF - duration_amount - ROW[name] => 'duration_amount' [vname] => 'LBL_DURATION_AMOUNT' [type] => 'integer' [required] => '' [reportable] => '' [api-visible] => '' [inline_edit] => '' [dbType] => 'integer' [len] => '' */
/* INDEXES */
ALTER TABLE oauth2clients modify COLUMN duration_value integer NULL , modify COLUMN duration_amount integer NULL ;
I run the script but it always reappears. It doesn’t appear to have any real affect that I can see yet. Please advise. Thanks