I just upgraded from DNN 5.6.1 to 5.6.2 and installed the Documents module 4.1.2 that comes with it. Everything worked fine until my client decided they wanted to use Categories. I get a number of errors.

First, when I save the Category List in the Host Lists section I get this error:

AssemblyVersion: 5.6.2
PortalID: 0
PortalName: The Client Inc.
UserID: 1
UserName: Super****
ActiveTabID: 33
ActiveTabName: Lists
RawURL: /~/Default.aspx?tabid=33&Key=:Evelyn%20Drive&portalid=0
AbsoluteURL: /~/Default.aspx
AbsoluteURLReferrer: http://client.com/Host/Lists/tabid/33/portalid/0/Default.aspx
UserAgent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.0; Trident/4.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.5.21022; .NET CLR 3.5.30729; .NET CLR 3.0.30729; OfficeLiveConnector.1.5; OfficeLivePatch.1.3; .NET4.0C; Tablet PC 2.0; .NET4.0E)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: b45c5127-75a2-48c7-921c-25d7b2770d88
InnerException: The file '/~/Default.aspx' does not exist.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Web.UI.Util.CheckVirtualFileExists
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: The file '/~/Default.aspx' does not exist. ---> System.Web.HttpException: The file '/~/Default.aspx' does not exist. at System.Web.UI.Util.CheckVirtualFileExists(VirtualPath virtualPath) at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) at System.Web.Compilation.BuildManager.GetVirtualPathObjectFactory(VirtualPath virtualPath, HttpContext context, Boolean allowCrossApp, Boolean noAssert) at System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp, Boolean noAssert) at System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) at System.Web.UI.PageHandlerFactory.System.Web.IHttpHandlerFactory2.GetHandler(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) at System.Web.HttpApplication.MapHttpHandler(HttpContext context, String requestType, VirtualPath path, String pathTranslated, Boolean useAppConfig) at System.Web.HttpApplication.MapHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) --- End of inner exception stack trace ---

So, it seems the URL is not properly formed there. However, the List seems to have been created okay.
When I try to edit an item in the Documents module and assign it a Category from the list I get this error:

ModuleId: 441
ModuleDefId: 125
FriendlyName:
ModuleControlSource: DesktopModules/Documents/EditDocs.ascx
AssemblyVersion: 5.6.2
PortalID: 0
PortalName: The Client Inc.
UserID: 1
UserName: SuperTom
ActiveTabID: 75
ActiveTabName: Evelyn Drive
RawURL: /EvelynDrive/tabid/75/ctl/Edit/mid/441/ItemID/0/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://client.com/EvelynDrive/tabid/75/ctl/Edit/mid/441/ItemID/0/Default.aspx
UserAgent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.0; Trident/4.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.5.21022; .NET CLR 3.5.30729; .NET CLR 3.0.30729; OfficeLiveConnector.1.5; OfficeLivePatch.1.3; .NET4.0C; Tablet PC 2.0; .NET4.0E)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: ea72438c-558f-497e-816d-6b29f8c006b1
InnerException: Parameter count does not match Parameter Value count.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: Microsoft.ApplicationBlocks.Data.SqlHelper.AssignParameterValues
StackTrace:
Message: DotNetNuke.Services.Exceptions.ModuleLoadException: Parameter count does not match Parameter Value count. ---> System.ArgumentException: Parameter count does not match Parameter Value count. at Microsoft.ApplicationBlocks.Data.SqlHelper.AssignParameterValues(SqlParameter[] commandParameters, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.Documents.SqlDataProvider.UpdateDocument(Int32 moduleId, Int32 ItemId, String Title, String URL, Int32 UserId, Int32 OwnedByUserID, String Category, Int32 SortOrderIndex, String Description) at DotNetNuke.Modules.Documents.DocumentController.UpdateDocument(DocumentInfo objDocument) at DotNetNuke.Modules.Documents.EditDocs.Update(Boolean Override) --- End of inner exception stack trace ---

I thought it might be the list, so I created another one and got exactly the same results. Now I'm thinking that it might be because I put items in the Documents module without any Category specified (wasn't using it), and then after putting two items in, I enabled the Category list and put it in as a column. Then I tried to assign a Category to a Documents item.

Any ideas how to get this working?

Here's an update. I also found out that the Delete option in the module also causes this error, and so I can't delete a document from the list.
I looked through the database files to see if I could spot an inconsistency, but found none.
I un-installed the Documents module and all of its files; re-installed the new module again and found the exact same problem.

Last ditch effort, I un-installed the module and installed the old module, 4.1.0. Everything worked great.

That's what I'm delivering to the customer. It works. 4.1.2 seems not to work. That's my experience.

I noticed, there is a sqldataprovider file missing in manifest for 4.1.2 (which needs to be fixed)! Once you installed 4.1.0, upgrade from 4.1.0 to 4.1.2 should work as expected, previous versions need to be upgraded to 4.1.0 first.

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN