Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

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 ForumsDocumentsDocumentsCanCan't add new files for download
Previous
 
Next
New Post
9/22/2006 10:32 AM
 
Hi.

I'm having a little trouble with my Documents Module running DNN 3.3.5 and Documents 3.1.5

I can download from instances that already points to files for download - but I can't add new files for download to either old or new instances. Error log entry at the end of this post.

I have tried to reinstall the module, but that didn't help.

Apparently my host had some issues last week that denied other people access to the File Manager on their portals. However, I didn't notice any of this. Also a possible connection to my recent update to 3.3.5.

Any help appreciated.

\tom



ModuleId
: 455
ModuleDefId: 95
FriendlyName: Rediger fil
ModuleControlSource: DesktopModules/Documents/EditDocs.ascx
AssemblyVersion: 03.03.05
PortalID: 0
PortalName: <myportal>
UserID: 1
UserName: host
ActiveTabID: 77
ActiveTabName: Tupla
RawURL: /Aktiviteter/Tupla/tabid/77/ctl/Edit/mid/455/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://<mydomain>/Aktiviteter/Tupla/tabid/77/ctl/Edit/mid/455/Default.aspx
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; da; rv:1.8.0.7) Gecko/20060909 Firefox/1.5.0.7
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: af2cabf3-f23c-40be-b80c-24390be656ab
InnerException: Parameter count does not match Parameter Value count.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: N/A - Reflection Permission required
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.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.Documents.SqlDataProvider.AddDocument(Int32 ModuleId, String Title, String URL, Int32 UserId, Int32 OwnedByUserID, String Category, Int32 SortOrderIndex, String Description) at DotNetNuke.Modules.Documents.DocumentController.AddDocument(DocumentInfo objDocument) at DotNetNuke.Modules.Documents.EditDocs.cmdUpdate_Click(Object sender, EventArgs e) --- End of inner exception stack trace ---
Source:
Server Navn: <hostsserver>
 
New Post
10/7/2006 9:49 PM
 

The error message "Parameter count does not match Parameter Value count" indicates that DNN is calling a stored procedure with a different number of parameters than the stored procedure actually requires - which points to a problem with your database.  It looks as though one or more table changes and/or stored procedures were not upgraded when you upgraded the documents module.

This issue is difficult to resolve without the error log from when you installed the module.  If this happened to me, I'd install a new DNN instance on my local machine, then use Red Gate SQL Compare to compare the schema of the local copy with the "live" database and generate SQL to make them match.  It may be that only the AddDocument stored procedure is affected - if this is true, you can just find the most recent "AddDocument" SQL from the .SqlDataProvider files and run it in Host->SQL.  But if one thing failed, then probably something else did, too.


 
New Post
10/8/2006 5:48 AM
 
I keep my logs.

There were no errors upon installing the module nor when I updated it or reinstalled it - everything went smooth according to the logs. By the way, would it make any difference if I try to delete the module before I reinstall it? I realize that I'd loose all my instances, but if that would make things work again...

I'm not exactly comfortable juggling with SQL, but I'll propably figure it out, if there are no oyher options :) In other words, I'd be really thankful if somebody would post a snippet that I could run.

\tom
 
New Post
10/8/2006 7:59 PM
 

Here's the SQL for AddDocument:

ALTER  PROCEDURE dbo.AddDocument
@ModuleId         INT,
@Title            nvarchar(150),
@URL              nvarchar(250),
@UserId           INT,
@OwnedByUserId    INT,
@Category         nvarchar(50),
@SortOrderIndex   INT,
@Description      nvarchar(255)
AS
INSERT INTO dbo.Documents (
  ModuleId,
  Title,
  URL,
  CreatedByUserID,
  CreatedDate,
  Category,
  OwnedByUserID,
  ModifiedByUserID,
  ModifiedDate,
  SortOrderIndex,
  Description
)
VALUES (
  @ModuleId,
  @Title,
  @URL,
  @UserId,
  getdate(),
  @Category,
  @OwnedByUserId,
  @UserId,
  getdate(),
  @SortOrderIndex,
  @Description
)
SELECT SCOPE_IDENTITY()

GO


 
New Post
10/8/2006 8:18 PM
 
Anthony, you're a life saver.

After I replaced dbo with my actual owner account name, it worked like a charm. Thanks a bunch.

\tom
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsDocumentsDocumentsCanCan't add new files for download


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