Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...File Manager invisible - Error installing Documents ManagerFile Manager invisible - Error installing Documents Manager
Previous
 
Next
New Post
10/18/2013 10:52 AM
 

I have just upgraded from 6.2.7 to 7.1.2 but the File Manager under admin and host is invisible. I have tried to install the Document Manager but I get the following error:

 

StartJob Starting Installation
Info Starting Installation - DNN_Documents
Info Starting Installation - Script
Info Begin Sql execution
Info Creating backup of previous version - Providers\DataProviders\SQLDataProvider\06.00.00.SqlDataProvider
Info Created
Info Executing 06.00.00.SqlDataProvider
Info Start Sql execution: 06.00.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'OwnedByUserID'. Invalid column name 'ModifiedByUserID'. Invalid column name 'ModifiedDate'. Invalid column name 'SortOrderIndex'. Invalid column name 'Description'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (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.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:ee921fc5-9abd-454e-8f3c-925715688366 CREATE PROCEDURE dbo.UpdateDocument @ModuleId INT, @ItemId INT, @Title nvarchar(150), @URL nvarchar(250), @UserId INT, @Category nvarchar(50), @OwnedByUserID INT, @SortOrderIndex INT, @Description nvarchar(255), @ForceDownload BIT AS UPDATE dbo.Documents SET Title = @Title, URL = @URL, Category = @Category, OwnedByUserID = @OwnedByUserID, ModifiedByUserID = @UserId, ModifiedDate = getdate(), SortOrderIndex = @SortOrderIndex, Description = @Description, ForceDownload = @ForceDownload WHERE ItemId = @ItemId AND ModuleId = @ModuleId System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'CreatedByUserID'. Invalid column name 'OwnedByUserID'. Invalid column name 'ModifiedByUserID'. Invalid column name 'OwnedByUserID'. Invalid column name 'ModifiedByUserID'. Invalid column name 'ModifiedDate'. Invalid column name 'CreatedByUserID'. Invalid column name 'SortOrderIndex'. Invalid column name 'Description'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (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.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:de03d64e-9534-4554-b535-a10f6e1e7717 CREATE PROCEDURE dbo.GetDocument @ItemId INT, @ModuleId INT AS SELECT Documents.Itemid, Documents.Moduleid, Documents.Title, Documents.Url, Documents.Category, CreatedByUser.FirstName + ' ' + CreatedByUser.LastName AS "CreatedByUser", OwnedByUser.FirstName + ' ' + OwnedByUser.LastName AS "OwnedByUser", ModifiedByUser.FirstName + ' ' + ModifiedByUser.LastName AS "ModifiedByUser", Files.Size, Files.ContentType, UrlTracking.TrackClicks, UrlTracking.Clicks, UrlTracking.NewWindow, Documents.OwnedByUserID, Documents.ModifiedByUserID, Documents.ModifiedDate, Documents.CreatedByUserID, Documents.CreatedDate, Documents.SortOrderIndex, Documents.Description, Documents.ForceDownload FROM dbo.Documents LEFT OUTER JOIN dbo.Users AS CreatedByUser on Documents.CreatedByUserID = CreatedByUser.UserId LEFT OUTER JOIN dbo.Users AS OwnedByUser on Documents.OwnedByUserID = OwnedByUser.UserId LEFT OUTER JOIN dbo.Users AS ModifiedByUser on Documents.ModifiedByUserID = ModifiedByUser.UserId LEFT OUTER JOIN dbo.UrlTracking on Documents.URL = UrlTracking.Url and UrlTracking.ModuleId = @ModuleID LEFT OUTER JOIN dbo.Files on Documents.URL = 'fileid=' + convert(varchar,dbo.Files.FileID) WHERE dbo.Documents.ItemId = @ItemId and dbo.Documents.ModuleId = @ModuleId System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'CreatedByUserID'. Invalid column name 'OwnedByUserID'. Invalid column name 'ModifiedByUserID'. Invalid column name 'OwnedByUserID'. Invalid column name 'ModifiedByUserID'. Invalid column name 'ModifiedDate'. Invalid column name 'CreatedByUserID'. Invalid column name 'SortOrderIndex'. Invalid column name 'Description'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (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.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:b28f2752-22e2-471b-981e-94c02ce91df9 CREATE PROCEDURE dbo.GetDocuments @ModuleId INT, @PortalId INT AS SELECT Documents.ItemId, Documents.Moduleid, Documents.Title, Documents.Url, CreatedByUser.FirstName + ' ' + CreatedByUser.LastName AS "CreatedByUser", OwnedByUser.FirstName + ' ' + OwnedByUser.LastName AS "OwnedByUser", ModifiedByUser.FirstName + ' ' + ModifiedByUser.LastName AS "ModifiedByUser", Documents.Category, Files.Size, UrlTracking.TrackClicks, UrlTracking.Clicks, UrlTracking.NewWindow, Documents.OwnedByUserID, Documents.ModifiedByUserID, Documents.ModifiedDate, Documents.CreatedByUserID, Documents.CreatedDate, Documents.SortOrderIndex, Documents.Description, Documents.ForceDownload FROM dbo.Documents LEFT OUTER JOIN dbo.Users AS CreatedByUser on dbo.Documents.CreatedByUserID = CreatedByUser.UserId LEFT OUTER JOIN dbo.Users AS OwnedByUser on dbo.Documents.OwnedByUserID = OwnedByUser.UserId LEFT OUTER JOIN dbo.Users AS ModifiedByUser on dbo.Documents.ModifiedByUserID = ModifiedByUser.UserId LEFT OUTER JOIN dbo.Files on dbo.Documents.URL = 'fileid=' + convert(varchar,dbo.Files.FileID) LEFT OUTER JOIN dbo.UrlTracking on dbo.Documents.URL = dbo.UrlTracking.Url and dbo.UrlTracking.ModuleId = @ModuleID WHERE Documents.ModuleId = @ModuleId ORDER by Documents.Title System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'CreatedByUserID'. Invalid column name 'OwnedByUserID'. Invalid column name 'ModifiedByUserID'. Invalid column name 'ModifiedDate'. Invalid column name 'SortOrderIndex'. Invalid column name 'Description'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (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.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:a573c61c-aed6-4b6d-8971-f1568bcd39f6 CREATE PROCEDURE dbo.AddDocument @ModuleId INT, @Title NVARCHAR(150), @URL NVARCHAR(250), @UserId INT, @OwnedByUserId INT, @Category NVARCHAR(50), @SortOrderIndex INT, @Description NVARCHAR(255), @ForceDownload BIT AS INSERT INTO dbo.Documents ( ModuleId, Title, URL, CreatedByUserID, CreatedDate, Category, OwnedByUserID, ModifiedByUserID, ModifiedDate, SortOrderIndex, Description, ForceDownload ) VALUES ( @ModuleId, @Title, @URL, @UserId, getdate(), @Category, @OwnedByUserId, @UserId, getdate(), @SortOrderIndex, @Description, @ForceDownload ) SELECT SCOPE_IDENTITY()
Info End Sql execution: 06.00.00.SqlDataProvider file
Info Finished Sql execution
Failure Installation Failed - Script
Info Installation Failed - DNN_Documents
Info Deleted temporary install folder
EndJob Installation Failed

Any ideas?

 
New Post
10/19/2013 1:55 AM
 

Abot your file Manager issue have try a IIS reset or System reboot?  Also check your Skin and custom modules for compatibility with DNN 7.1 that comes with new jQuery and jQueryUI library.

Are you running the database on SQL 2008 (100) or higher mode or is it still on SQL 2005?  Have you changed the application pool to use .NET 4.x on 64Bit mode only ? 

Did you try to install the last or old Version of DNN Documents? Did your database use an other databaseOwner else dbo and/or an objectQualifier ?

 
New Post
10/19/2013 5:01 AM
 
Abot your file Manager issue have try a IIS reset or System reboot?
- Yes, I have but no luck.
Also check your Skin and custom modules for compatibility with DNN 7.1 that comes with new jQuery and jQueryUI library.
- I have applied 2 default skins but I had the same results.
Are you running the database on SQL 2008 (100) or higher mode or is it still on SQL 2005?
- I'm using SQL Server 2008 R2
Have you changed the application pool to use .NET 4.x on 64Bit mode only ?
- I'm using Integrated .NET v4.0.30319
Did you try to install the last or old Version of DNN Documents?
- I have tried to upgrade to the latest version of DNN Documents.
Did your database use an other databaseOwner else dbo and/or an objectQualifier ?
- No

Thanks
 
New Post
10/19/2013 5:51 AM
 
Dis you use the install or upgrade package?  Have you unblock the zip file before you extract the files ?  From Internet downloaded files files ar blocked to executable files from newer OS.
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...File Manager invisible - Error installing Documents ManagerFile Manager invisible - Error installing Documents Manager


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.

Content Layout

Subscribe to DNN Digest

Subscribe to DNN Digest

DNN Digest is our monthly email newsletter. It highlights news and content from around the DNN ecosystem, such as new modules and themes, messages from leadership, blog posts and notable tweets. Keep your finger on the pulse of the ecosystem by subscribing.  


Copyright 2017 by DNN Corp Terms of Use Privacy
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out