Why would I get the error, Cannot insert the value NULL into column 'IsDeleted', table TabModules, when creating a new page on my site? Currently on dnn version 07.01.01 (385).
I am fairly new to DNN and am not sure where to start looking. Here's the stack trace from the Event Viewer:
DotNetNuke.Web.UI.DotNetNukeException: Unable to process
page template. ---> System.Data.SqlClient.SqlException: Cannot insert the
value NULL into column 'IsDeleted', table 'dartexp.dbo.TabModules'; column does
not allow nulls. INSERT fails. The statement has been terminated. at
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean
breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection, Action`1 wrapCloseInAction) at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior
runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream,
BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj,
Boolean& dataReady) 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,
Int32 timeout, Task& task, Boolean asyncWrite) at
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior,
RunBehavior runBehavior, Boolean returnStream, String method,
TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean
asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1
completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean
asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at
PetaPoco.Database.Execute(String sql, Object[] args) at
DotNetNuke.Data.PetaPoco.PetaPocoHelper.ExecuteNonQuery(String
connectionString, CommandType type, Int32 timeout, String sql, Object[] args)
at DotNetNuke.Data.SqlDataProvider.ExecuteNonQuery(String procedureName,
Object[] commandParameters) at DotNetNuke.Data.DataProvider.AddTabModule(Int32
TabId, Int32 ModuleId, String ModuleTitle, String Header, String Footer, Int32
ModuleOrder, String PaneName, Int32 CacheTime, String CacheMethod, String
Alignment, String Color, String Border, String IconFile, Int32 Visibility,
String ContainerSrc, Boolean DisplayTitle, Boolean DisplayPrint, Boolean
DisplaySyndicate, Boolean IsWebSlice, String WebSliceTitle, DateTime
WebSliceExpiryDate, Int32 WebSliceTTL, Guid UniqueId, Guid VersionGuid, Guid
DefaultLanguageGuid, Guid LocalizedVersionGuid, String CultureCode, Int32
createdByUserID) at
DotNetNuke.Entities.Modules.ModuleController.AddModule(ModuleInfo module) at
DotNetNuke.Entities.Modules.ModuleController.DeserializeModule(XmlNode
nodeModule, XmlNode nodePane, Int32 portalId, Int32 tabId,
PortalTemplateModuleAction mergeTabs, Hashtable hModules) at
DotNetNuke.Entities.Tabs.TabController.DeserializePanes(XmlNode nodePanes,
Int32 portalId, Int32 tabId, PortalTemplateModuleAction mergeTabs, Hashtable
hModules) at DesktopModules.Admin.Tabs.View.ApplyDefaultTabTemplate(TabInfo
tab) --- End of inner exception stack trace --- at
DesktopModules.Admin.Tabs.View.ApplyDefaultTabTemplate(TabInfo tab) at
DesktopModules.Admin.Tabs.View.CreateTabFromParent(TabInfo objRoot, String tabName,
Int32 parentId) at DesktopModules.Admin.Tabs.View.OnCreatePagesClick(Object
sender, EventArgs e)