We've developed unit config validator some time ago and it seems, that we have some unresolved issues found by it:
| Config Error: for prefix email-queue (EmailQueue) in unit config: Field LogData exists in the database, but is not defined in config |
| Config Error: for prefix lang (Languages) in unit config: Field Charset exists in the database, but is not defined in config |
| Config Errors: for prefix system-log (SystemLog) in unit config: Default value for field LogLevel not sync. to db (in config = 6 of integer, in db = 7 of integer) Field LogType is NOT NULL in the database, but is not configured as not_null Field LogInterface is described as NOT NULL in config, but is NULL in db |
| Config Error: for prefix permission-type (CategoryPermissionsConfig) in unit config: Default value for field ModuleId not sync. to db (in config = '' of string, in db = 0 of integer) |
| Config Errors: for prefix phrases (LanguageLabels) in unit config: Default value for field PhraseType not sync. to db (in config = 2 of integer, in db = 0 of integer) Default value for field Module not sync. to db (in config = 'Custom' of string, in db = 'In-Portal' of string) |
| Config Error: for prefix promo-block (PromoBlocks) in unit config: Field CSSClassName exists in the database, but is not defined in config |
| Config Errors: for prefix scheduled-task (ScheduledTasks) in unit config: Field RunTime must be NULL in config and database, since it contains date Field Timeout is described as NOT NULL in config, but is NULL in db Default value for field Timeout not sync. to db (in config = NULL of NULL, in db = 0 of integer) |
| Config Warning: Table 53x_StylesheetSelectors missing, but prefix selectors requires it! |
| Config Errors: for prefix st (Categories) in unit config: Field PromoBlockGroupId exists in the database, but is not defined in config Field RequireSSL exists in the database, but is not defined in config Field RequireLogin exists in the database, but is not defined in config |
| Config Warning: Table 53x_Stylesheets missing, but prefix css requires it! |
| Config Errors: for prefix system-event-subscription (SystemEventSubscriptions) in unit config: Calculated field BindToSystemEvent is missing corresponding virtual field Calculated field ItemName is missing corresponding virtual field Calculated field ParentItemName is missing corresponding virtual field |
| Config Error: for prefix ug (UserGroupRelations) in unit config: Virtual field PrimaryGroup cannot be not null, since it doesn't exist in database |
| Config Errors: for prefix u (Users) in unit config: Default value for field PortalUserId not set in config Field PortalUserId is described as NOT NULL in config, but does not have DEFAULT value Default value for field Username not set in config Field Username is described as NOT NULL in config, but does not have DEFAULT value Default value for field Password not set in config Default value for field PasswordHashingMethod not set in config Field PasswordHashingMethod is NOT NULL in the database, but is not configured as not_null Default value for field FirstName not set in config Field FirstName is described as NOT NULL in config, but does not have DEFAULT value Default value for field LastName not set in config Field LastName is described as NOT NULL in config, but does not have DEFAULT value Default value for field Company not set in config Field Company is described as NOT NULL in config, but does not have DEFAULT value Default value for field Email not set in config Field Email is described as NOT NULL in config, but does not have DEFAULT value Default value for field PrevEmails not set in config Default value for field CreatedOn not set in config Default value for field Phone not set in config Field Phone is described as NOT NULL in config, but does not have DEFAULT value Default value for field Fax not set in config Field Fax is described as NOT NULL in config, but does not have DEFAULT value Default value for field Street not set in config Field Street is described as NOT NULL in config, but does not have DEFAULT value Default value for field Street2 not set in config Field Street2 is described as NOT NULL in config, but does not have DEFAULT value Default value for field City not set in config Field City is described as NOT NULL in config, but does not have DEFAULT value Default value for field State not set in config Field State is described as NOT NULL in config, but does not have DEFAULT value Default value for field Zip not set in config Field Zip is described as NOT NULL in config, but does not have DEFAULT value Default value for field Country not set in config Field Country is described as NOT NULL in config, but does not have DEFAULT value Default value for field ResourceId not set in config Field ResourceId is described as NOT NULL in config, but does not have DEFAULT value Default value for field Status not set in config Field Status is described as NOT NULL in config, but does not have DEFAULT value Default value for field EmailVerified not set in config Field EmailVerified is described as NOT NULL in config, but does not have DEFAULT value Default value for field Modified not set in config Default value for field dob not set in config Default value for field TimeZone not set in config Field TimeZone is described as NOT NULL in config, but does not have DEFAULT value Default value for field IPAddress not set in config Field IPAddress is described as NOT NULL in config, but does not have DEFAULT value Default value for field IsBanned not set in config Field IsBanned is described as NOT NULL in config, but does not have DEFAULT value Default value for field PwResetConfirm not set in config Field PwResetConfirm is described as NOT NULL in config, but does not have DEFAULT value Default value for field PwRequestTime not set in config Default value for field FrontLanguage not set in config Default value for field AdminLanguage not set in config Default value for field DisplayToPublic not set in config Default value for field UserType not set in config Field UserType is described as NOT NULL in config, but does not have DEFAULT value Default value for field PrimaryGroupId not set in config Default value for field OldStyleLogin not set in config Field OldStyleLogin is described as NOT NULL in config, but does not have DEFAULT value Default value for field IPRestrictions not set in config Field EbayLogin exists in the database, but is not defined in config Field EbayEIASToken exists in the database, but is not defined in config Default value for virtual field PrimaryGroup not set in config Default value for virtual field RootPassword not set in config Default value for virtual field EmailPassword not set in config Default value for virtual field FullName not set in config Default value for virtual field AltName not set in config Default value for virtual field SameImages not set in config Default value for virtual field LocalThumb not set in config Default value for virtual field ThumbPath not set in config Default value for virtual field ThumbUrl not set in config Default value for virtual field LocalImage not set in config Default value for virtual field LocalPath not set in config Default value for virtual field FullUrl not set in config Default value for virtual field SubscribeToMailing not set in config |
| Config Error: for prefix addr (Addresses) in unit config: Default value for field Country not sync. to db (in config = 'USA' of string, in db = '' of string) |
| Config Errors: for prefix p (Products) in unit config: Field LastListingId exists in the database, but is not defined in config Field ScheduleId exists in the database, but is not defined in config |
| Config Warning: Table 53x_StylesheetSelectors missing, but prefix selectorsbase requires it! |
| Config Warning: Table 53x_StylesheetSelectors missing, but prefix selectorsblock requires it! |
| Config Error: for prefix g-ug (UserGroupRelations) in unit config: Virtual field PrimaryGroup cannot be not null, since it doesn't exist in database |
| Config Error: for prefix u-ug (UserGroupRelations) in unit config: Virtual field PrimaryGroup cannot be not null, since it doesn't exist in database |
I've executed it on In-Portal 5.3.x installation.