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 ...File upload permissionsFile upload permissions
Previous
 
Next
New Post
9/22/2006 3:26 PM
 

Hi.  I'm also having the same problem.  I can't overwrite an existing file in the \portals\0\ folder, even though the file is NOT read-only.  I have the problem when I'm logged in as a Host account, too.  I can upload a file as long as another file with the same name does NOT already exist in that folder.

Here's my environment:
      OS       Windows 2000 Server SP4, Fully Patched
      DNN     3.3.5

I even ran the FileMon utility (www.sysinternals.com) on the server while I attempted to upload/overwrite an existing file, and it didn't report any file permission-related errors.

I can overwrite the file using "Windows Explorer" and browsing to the server from my laptop.

It doesn't appear to be an NTFS permission-related error. 

Thanks,
Van


See Ya! Van
 
New Post
9/26/2006 3:13 PM
 

Having the same problem with 3.3.5.

This is a very significent problem for the City of Wilmington. We've got about 20 content managers that depend on the ability to overwrite existing files when uploading.

Seems the community needs some helpful input from the DNN folks and soon.

 
New Post
9/28/2006 11:29 AM
 

Believe I've found a work-around at least for City of Wilmington's environment -

 

1.       Problem occurs due to the file name already being contained in the Files table.

 

2.       The source of the problem seems to be in stored procedure AddFile.

 

     SELECT SCOPE_IDENTITY() is returning NULL because it’s outside the IF .. ELSE block. When the file name exists in the Files table the UPDATE block of the IF statement runs but NULL is still returned. Fix seems to be to move the SELECT SCOPE_IDENTITY() statement up into the INSERT block of the IF statement so that a valid identity is returned when inserting new files and nothing is returned when updating an existing file name.

 
New Post
10/2/2006 2:47 PM
 
I posted the issue in Gemini today. I hope the core team will notice.
 
New Post
10/3/2006 9:20 AM
 

Can you please show how to change it. Here i show the original stored procedure.
Dont know where to put the select SCOPE_IDENTITY()

CREATE procedure mydomain.AddFile

@PortalId    int,
@FileName    nvarchar(100),
@Extension   nvarchar(100),
@Size        int,
@WIdth       int,
@Height      int,
@ContentType nvarchar(200),
@Folder      nvarchar(200),
@FolderID    int

as

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

 

 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...File upload permissionsFile upload permissions


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