New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

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

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsDocumentsDocumentsError on Edit of Document SettingsError on Edit of Document Settings
New Post
11/1/2012 5:12 PM

I receive the following error when ever I update the settings for a document.  I can add a document without issue.  I am on version 5.0.0 of the Documents module and DNN 6.2.3 (141).

Any help would be appreciated as it is annoying to have to delete and re-add documents to get things correct.

Thanks, Rob

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 ---

New Post
11/2/2012 9:06 PM

I just tested a new install of Documents module v 5.0.0 in a DNN 6.2.3 install and was not able to duplicate this issue. Typically the error that is logged results from a mis-match of versions of the module's assembly (DotNetNuke.Modules.Documents.dll) and the module's MS SQL Server database stored proceedures. In this case the mis-match is in the UpdateDocument stored procedure.

Please check the following:

1. Version of bin\DotNetNuke.Modules.Documents.dll assembly. It should be version
2. Definition of the UpdateDocument stored procedure in the site's database using a tool such as MS SQL Server Management Studio Express. The stored procedure should have 9 parameters as follows:

CREATE PROCEDURE {databaseOwner}{objectQualifier}UpdateDocument

@ModuleId                      INT,
@ItemId                           INT,
@Title                              nvarchar(150),
@URL                              nvarchar(250),
@UserId                           INT,
@Category                       nvarchar(50),
@OwnedByUserID           INT,
@SortOrderIndex             INT,
@Description                   nvarchar(255)

If it has only 5 parameters, the appropriate database SqlDataProvider script for v 5.00.00 did not successfully run during installation. We can then try to re-run this one stored procedure creation script after manually deleting the existing UpdateDocument stored procedure.

Another possibility if this installation was an upgrade from an earlier version is that the bin\DotNetNuke.Modules.Documents.SqlDataProvider.dll assembly file used in the 3.x versions of the module did not get automatically deleted during the upgrade. If so, delete it and re-try to update an existing document item.

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
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsDocumentsDocumentsError on Edit of Document SettingsError on Edit of Document Settings

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.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out