Running DNN 6.01.01 and User Profile 4.03.17 and get the following when adding UserProfile - Profile to a page...
Error: Smart-Thinker - UserProfile - Profile is currently unavailable. DotNetNuke.Services.Exceptions.ModuleLoadException: Cannot insert the value NULL into column 'PublicProfile', table 'pac1135403390033.dbo.SmartThinker_UserProfile'; column does not allow nulls. INSERT fails. The statement has been terminated. ---> System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'PublicProfile', table 'pac1135403390033.dbo.SmartThinker_UserProfile'; column does not allow nulls. INSERT fails. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at SmartThinker.DNN.Modules.UserProfile.Data.SqlDataProvider.AddUserProfile(Int32 userID, Int32 portalID, Boolean validUserData, String invalidMessage, Int32 censorRatingID, DateTime dOB, DateTime dOBEmailedDate, DateTime lastShownDate, Int32 viewCounter, DateTime createdDate, DateTime changedDate, Int32 createdByUserID, Int32 changedByUserID, String profileStatus, DateTime profileStatusUpdate) at SmartThinker.DNN.Modules.UserProfile.Business.SmartThinker_UserProfileController.Add(SmartThinker_UserProfileInfo objSmartThinker_UserProfile) at SmartThinker.DNN.Modules.UserProfile.UserProfile.CreateNewUserProfile(UserInfo userInfo, SmartThinker_UserProfileInfo smartThinker_UserProfileInfo) at SmartThinker.DNN.Modules.UserProfile.UserProfile.LoadUserProfile(Int32 userID, Int32 selectedProfileTypeID) at SmartThinker.DNN.Modules.UserProfile.UserProfile.Page_Init(Object sender, EventArgs e) --- End of inner exception stack trace ---