Here's the original stored procedure out of 3.3.5.

Then SELECT SCOPE_IDENTITY() statement is moved up into the IF @FileID IS NULL block as shown in red.

Hopes this helps with your problem.

CREATE PROCEDURE dbo.AddFile
 @PortalId    int,
 @FileName    nvarchar(100),
 @Extension   nvarchar(100),
 @Size        int,
 @WIdth       int,
 @Height      int,
 @ContentType nvarchar(200),
 @Folder      nvarchar(200),
 @FolderID    int

AS

DECLARE @FileID int
SET @FileID = (SELECT FileId FROM Files WHERE FolderID = @FolderID and FileName = @FileName)

IF @FileID IS NULL
 BEGIN
  INSERT INTO Files (
    PortalId,
    FileName,
    Extension,
    Size,
    Width,
    Height,
    ContentType,
    Folder,
    FolderID
  )
  VALUES (
    @PortalId,
    @FileName,
    @Extension,
    @Size,
    @Width,
    @Height,
    @ContentType,
    @Folder,
    @FolderID
  )
  SELECT SCOPE_IDENTITY() 
 END
ELSE
 BEGIN
  UPDATE Files
   SET FileName = @FileName,
    Extension = @Extension,
    Size = @Size,
    Width = @Width,
    Height = @Height,
    ContentType = @ContentType,
    Folder = @Folder,
    FolderID = @FolderID
   WHERE  FileId = @FileID
 END

UPDATE Folders
 SET LastUpdated = getUtcDate()
 WHERE FolderID = @FolderID

--SELECT SCOPE_IDENTITY()
GO

Hello,

I had the same problem, but the solutions that where told above didn't work.

My solution was a problem with the file-rights:

Go on your webserver to your dnnwebsite folder.
1. Make a right-mouse click on the folder and choose 'properties' and go the the securtiy tab.

2. Make sure that the following users/rights are added to the list:

- IIS_[user] (in my case IIS_WPG) - Full control
- System - Full control
- Users - Read & Write access & special permission.

Good luck,

Greetings,
Koen Cornelissen