#2786 - Error on Microsoft SQL
Using version 7.7.2 on a Microsoft SQL 2012 database, I get a Differences found between database and vardefs when running a QRR. This is causing an upgrade to fail. The mismatch is: /COLUMNS/ /MISMATCH WITH DATABASE - flag_data - ROW [name] => 'flag_data' [type] => 'bit' [len] => '1' [default] => '0' */ / VARDEF - flag_data - ROW[required] => '' [name] => 'flag_data' [vname] => 'LBL_FLAG_DATA' [type] => 'bit' [massupdate] => '' [default] => '0' [no_default] => '' [comments] => '' [help] => '' [importable] => 'false' [duplicate_merge] => 'disabled' [duplicate_merge_dom_value] => '0' [audited] => '' [reportable] => '' [unified_search] => '' [merge_filter] => 'disabled' [calculated] => '' [len] => '255' [size] => '20' [dbType] => 'bool' */ ALTER TABLE syno_dashboardtemplates DROP CONSTRAINT DF__syno_dash__flag___3E29BD87; ALTER TABLE syno_dashboardtemplates ALTER COLUMN flag_data bit NULL; ALTER TABLE syno_dashboardtemplates ADD DEFAULT 0 FOR flag_data;
Note the difference between [len] => '1' and [len] => '255'. I checked the vardefs and this field does have len set to 255. I believe a field of type bit should have a len of 1. I changed the len definition to 1 in ..\modules\SYNO_DashboardTemplates\vardefs.php and the error went away.
Can you tell me what the most recent version of this bundle is? I'm showing v20160510 installed.
Thank you, Justin Kuehlthau