HomeHomeUsing DotNetNuk...Using DotNetNuk...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

 
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.

erik hinds
risdall marketing group
#1 Web Design Agency in the World

www.risdall.net | erik AT risdall DOT-COM

 
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 DotNetNuk...Using DotNetNuk...Administration ...Administration ...File upload permissionsFile upload permissions


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, 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 DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

Attend A Webinar
Start  Professional Edition Trial
Have Someone Contact Me

Like Us on Facebook Join our Network on LinkedIn Follow DNN Corporate on Twitter Follow DNN on Twitter

Advertisers

Sponsors

DotNetNuke Corporation

DotNetNuke (DNN) provides a suite of solutions that make designing, building and managing feature-rich sites and communities fast, easy and cost-effective. The DotNetNuke Platform CMS is the foundation for more than one million websites worldwide. DNN Social, our newest solution, enables businesses to create immersive, interactive communities. Thousands of organizations like True Value Hardware, Bose, Cornell University, Glacier Water, Dannon, Delphi, USAA, NASCAR, Northern Health and the City of Denver have leveraged DNN to deploy highly engaging business- critical websites. Our rapid growth in product sales and deployments resulted in DotNetNuke Corp. being named one of the fastest growing private companies in America by Inc. Magazine in 2011 and 2012.