There was nothing unusual during the upgrade. Eveything else went successful. I checked the DMX_Entries table and here are the columns in it. (They include Remarks_old , IsPrivate_old and no DateSubmitted). Is that how it is supposed to be?
I checked the triggers on DMX_Entries. DMX_EntryUpdatePath is disabled. All the other 3 triggers reference the Remarks, IsPrivate and DateSubmitted. Maybe the triggers were not updated during the upgrade. Is there a script I could run to fix it.
I have also pasted the error message I get when I try to add a document
---------------------------------------------------
DeltaEntries_insert trigger on DMX_Entries
----------------------------------------------------
ALTER TRIGGER [DeltaEntries_insert]
... stuff deleted
----------------------------------------------------
Error on trying to add a document
-------------------------------------------------------
Invalid column name 'Remarks'.
Invalid column name 'DateSubmitted'.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1948826
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4844747
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +204
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +175
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) +168
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +188
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) +247
Bring2mind.DNN.Modules.DMX.Data.SqlDataProvider.UpdateEntry(Int32 EntryId, String Author, Int32 CollectionId, DateTime Created, Boolean Deleted, String Entry, String EntryType, Int64 FileSize, Boolean IsApproved, String Keywords, DateTime LastModified, Int32 LastVersionId, Int32 LockedBy, DateTime LockedUntil, Guid LockKey, String MD5Hash, String OriginalFileName, Int32 Owner, String Path, Boolean PermissionsOnlyByAdmin, Int32 PortalId, String State, Int32 Version, Int32 VersionsToKeep, String WorkflowId) +1089
Bring2mind.DNN.Modules.DMX.Business.EntriesController.UpdateEntry(EntryInfo objEntry, Boolean IncludeMultiTexts, Boolean UpdatePermissions, Boolean UpdateAttributes, Boolean UpdateCategories) +559
Bring2mind.DNN.Modules.DMX.Business.EntriesController.UpdateEntry(EntryInfo objEntry) +16
Bring2mind.DNN.Modules.DMX.Controls.EditEntry.FinishWizard() +2128
Bring2mind.DNN.Modules.DMX.Controls.EditEntry.IntermediateFinishButton_Click(Object sender, EventArgs e) +309
System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e) +111
System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +79
System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +175
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565
[PageLoadException: Invalid column name 'IsPrivate'.
Invalid column name 'Remarks'.
Invalid column name 'DateSubmitted'.]
DotNetNuke.Services.Exceptions.Exceptions.ProcessPageLoadException(Exception exc, String URL) +271
DotNetNuke.Framework.PageBase.Page_Error(Object Source, EventArgs e) +591
System.Web.UI.TemplateControl.OnError(EventArgs e) +8686090
System.Web.UI.Page.HandleError(Exception e) +84
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +6776
System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +242
System.Web.UI.Page.ProcessRequest() +80
System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) +21
System.Web.UI.Page.ProcessRequest(HttpContext context) +49
ASP.default_aspx.ProcessRequest(HttpContext context) +37
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +181
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75
----------------------------
DMX_Entries columns
---------------------------
Author
CollectionId
Created
Deleted
Description
EditRoles
Entry
EntryId
EntryType
FileSize
IsApproved
Keywords
LastVersionId
LockedBy
OriginalFileName
PortalId
Remarks_old
Owner
Version
ViewRoles
LastModified
Categories
IsPrivate_old
LockedUntil
LockKey
MD5Hash
State
VersionsToKeep
WorkflowId
Path
PermissionsOnlyByAdmin