Hello -

I've got an old DNN3 site that I've decided to just "recreate" since I want to make a bunch of changes anyway.

I've got the new site up (v5.6.6) and working fine.
I've created the "Documents" objects that I want to carry over from the old site.
I've also moved the files and synched the filesystem.
I have copied data from the old SQL server table (Documents) and created corresponding records in the URLTracking table.
I've also adjusted the ModuleID & FileID values to match those in the new system.

At this point I'm able to view or download the documents successfully.
The various Documents modules are also populated with the proper files.
Everything seems to be perfect - that is until I try to EDIT and save ANY document.

When I click "Update" I get the following error:
    Error: is currently unavailable.
    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 ---

Apparently I've missed creating entries in a table - but I've gone over the stored procs for adding or editing documents and can't find any tables other than Documents & UrlTracking being updated...

Does anyone know the piece of the puzzle I'm missing???
If I can get this method to work it would be MUCH better than manually having to add several hundred documents manually and one at a time...

Thanks all,
Doug

There is a mis-match in the number of parameters being passed in the documents module SqlDataProvider.UpdateDocument method and those expected in the SQL Server database's UpdateDocument stored procedure. Most likely the DotNetNuke.Modules.Documents.dll assembly file is the incorrect version or one of the sql scripts run when installing or upgrading the Documents module did not run or encountered an error.

If you can provide the version numbers of the Document's module on the old DNN 3.x site and that of the Document's module on the new DNN 5.6.6 site I can take a look at the method code and the stored procedure to see which one is "out of sync". It would also be helpful if you could check the file version of the DotNetNuke.Modules.Documents.dll in the site's /bin folder. As I recall there was a packaging error in one of the Documents 4.1.x releases that may also be at fault.

---

Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner