|
Failure
|
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: The multi-part identifier "dbo..nmuDocumentControl_Objects.tintObjectID" could not be bound. The multi-part identifier "dbo..nmuDocumentControl_Objects.tintModuleID" could not be bound. The multi-part identifier "dbo..nmuDocumentControl_Objects.tintPortalID" could not be bound. The multi-part identifier "dbo..nmuDocumentControl_Objects.tintObjectType" could not be bound. The multi-part identifier "dbo..nmuDocumentControl_ObjectProperties.tstrObjectTitle" could not be bound. The multi-part identifier "dbo..nmuDocumentControl_ObjectProperties.tstrObjectDescription" could not be bound. The multi-part identifier "dbo..nmuDocumentControl_ObjectProperties.tstrObjectName" could not be bound. The multi-part identifier "dbo..nmuDocumentControl_ObjectProperties.tboolObjectCheckOut" could not be bound. The multi-part identifier "dbo..nmuDocumentControl_ObjectProperties.tstrObjectType" could not be bound. The multi-part identifier "dbo..nmuDocumentControl_ObjectProperties.tboolObjectRecycled" could not be bound. The multi-part identifier "dbo..nmuDocumentControl_ObjectProperties.tintObjectSize" could not be bound. The multi-part identifier "dbo..nmuDocumentControl_ObjectProperties.tintUserIDCreated" could not be bound. The multi-part identifier "dbo..nmuDocumentControl_ObjectProperties.tdteDateCreated" could not be bound. The multi-part identifier "dbo..nmuDocumentControl_ObjectProperties.tdteDateCheckedOut" could not be bound. The multi-part identifier "dbo..nmuDocumentControl_ObjectProperties.tintUserIDCheckedOut" could not be bound. The multi-part identifier "dbo..nmuDocumentControl_ObjectProperties.tdteDateRecycled" could not be bound. The multi-part identifier "dbo..nmuDocumentControl_ObjectProperties.tintUserIDRecycled" could not be bound. The multi-part identifier "dbo..nmuDocumentControl_ObjectSettings.tboolHistory" could not be bound. The multi-part identifier "dbo..nmuDocumentControl_ObjectSettings.tboolVersioning" could not be bound. The multi-part identifier "dbo..nmuDocumentControl_Objects.tintObjectParentID" could not be bound. The multi-part identifier "dbo..nmuDocumentControl_ObjectProperties.tdteDateModified" could not be bound. The multi-part identifier "dbo..nmuDocumentControl_ObjectProperties.tintUserIDModified" could not be bound. The multi-part identifier "dbo..nmuDocumentControl_ObjectProperties.tintRecycledParent" could not be bound. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE VIEW dbo.nmuDocumentControl_Objects_Files AS SELECT dbo..nmuDocumentControl_Objects.tintObjectID, dbo..nmuDocumentControl_Objects.tintModuleID, dbo..nmuDocumentControl_Objects.tintPortalID, dbo..nmuDocumentControl_Objects.tintObjectType, dbo..nmuDocumentControl_ObjectProperties.tstrObjectTitle, dbo..nmuDocumentControl_ObjectProperties.tstrObjectDescription, dbo..nmuDocumentControl_ObjectProperties.tstrObjectName, dbo..nmuDocumentControl_ObjectProperties.tboolObjectCheckOut, dbo..nmuDocumentControl_ObjectProperties.tstrObjectType, dbo..nmuDocumentControl_ObjectProperties.tboolObjectRecycled, dbo..nmuDocumentControl_ObjectProperties.tintObjectSize, dbo..nmuDocumentControl_ObjectProperties.tintUserIDCreated, dbo..nmuDocumentControl_ObjectProperties.tdteDateCreated, dbo..nmuDocumentControl_ObjectProperties.tdteDateCheckedOut, dbo..nmuDocumentControl_ObjectProperties.tintUserIDCheckedOut, dbo..nmuDocumentControl_ObjectProperties.tdteDateRecycled, dbo..nmuDocumentControl_ObjectProperties.tintUserIDRecycled, dbo..nmuDocumentControl_ObjectSettings.tboolHistory, dbo..nmuDocumentControl_ObjectSettings.tboolVersioning, dbo..nmuDocumentControl_Objects.tintObjectParentID, dbo..nmuDocumentControl_ObjectProperties.tdteDateModified, dbo..nmuDocumentControl_ObjectProperties.tintUserIDModified, dbo..nmuDocumentControl_ObjectProperties.tintRecycledParent, Created.UserName As tstrCreatedUserName, Created.FirstName tstrCreatedFirstName, Created.LastName tstrCreatedLastName, CheckedOut.UserName As tstrCheckedOutUserName, CheckedOut.FirstName tstrCheckedOutFirstName, CheckedOut.LastName tstrCheckedOutLastName, Recycled.UserName As tstrRecycledUserName, Recycled.FirstName tstrRecycledFirstName, Recycled.LastName tstrRecycledLastName, Modified.UserName As tstrModifiedUserName, Modified.FirstName tstrModifiedFirstName, Modified.LastName tstrModifiedLastName FROM dbo.nmuDocumentControl_Objects LEFT OUTER JOIN dbo.nmuDocumentControl_ObjectProperties ON dbo.nmuDocumentControl_Objects.tintObjectID = dbo.nmuDocumentControl_ObjectProperties.tintObjectID LEFT OUTER JOIN dbo.nmuDocumentControl_ObjectSettings ON dbo.nmuDocumentControl_Objects.tintObjectID = dbo.nmuDocumentControl_ObjectSettings.tintObjectID LEFT OUTER JOIN dbo.Users Created ON tintUserIDCreated = Created.UserID LEFT OUTER JOIN dbo.Users CheckedOut ON tintUserIDCheckedOut = CheckedOut.UserID LEFT OUTER JOIN dbo.Users Recycled ON tintUserIDRecycled = Recycled.UserID LEFT OUTER JOIN dbo.Users Modified ON tintUserIDModified = Modified.UserID WHERE (dbo.nmuDocumentControl_Objects.tintObjectType = 2)
|