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

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Bug/Issue with SQL Data Provider and exporting modules.  DNN 4.3.5Bug/Issue with SQL Data Provider and exporting modules. DNN 4.3.5
Previous
 
Next
New Post
10/22/2006 4:04 AM
 

I hope this is the correct place for this post. 

There appears to be an issue with the SqlDataProvider.AddFile method.  It only works correctly when adding new files IE; the first time you try to export the content of a module.

It has a single line here:

Return CType(SqlHelper.ExecuteScalar(ConnectionString, DatabaseOwner & ObjectQualifier & "AddFile", GetNull(PortalId), FileName, Extension, Size, GetNull(Width), GetNull(Height), ContentType, Folder, FolderID), Integer)

Notice it is casting the return value to an integer.  The return value comes from the AddFile stored procedure, the value is the result of the SCOPE_IDENTITY() command at the end of that stored procedure.

The AddFile SP checks to see if the file exists in the Files table already, if so it updates, otherwise it inserts.

The issue is that the SCOPE_IDENTITY value is only an integer when inserting records, so if the AddFile SP is updating, then the returned value from SCOPE_IDENTITY() is null.  Then the code is trying to cast null to an integer. 

Suggested Fix:

Check for null first, then if null return a NullInteger.  Otherwise cast to integer and return.

 Dim returnValue As Object = SqlHelper.ExecuteScalar(ConnectionString, DatabaseOwner & ObjectQualifier & "AddFile", GetNull(PortalId), FileName, Extension, Size, GetNull(Width), GetNull(Height), ContentType, Folder, FolderID)
            If returnValue Is DBNull.Value Then
                Return Null.NullInteger
            Else
                Return CType(returnValue, Integer)
            End If
 
New Post
10/22/2006 5:31 AM
 

First, this is NOT related to the Client API and shall be moved to one of the general forums.

Second this issue has been identified and will be solved in next DNN version.


Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Bug/Issue with SQL Data Provider and exporting modules.  DNN 4.3.5Bug/Issue with SQL Data Provider and exporting modules. DNN 4.3.5


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