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 ForumsAnnouncementsAnnouncementsYou Do Not Have Permission To View The Requested FileYou Do Not Have Permission To View The Requested File
Previous
 
Next
New Post
2/2/2007 2:34 PM
 
Did you ever get this issue resolved?
 
New Post
2/3/2007 10:26 AM
 

this is not an issue of the announcements module.

You can set folder permissions to everyone  for all folders in your filesystem through an sql script though:

declare @PermissionID int
select @PermissionID = PermissionID from {objectQualifier}Permission where PermissionCode = 'SYSTEM_FOLDER' and PermissionKey='READ'

declare @FolderID int
DECLARE FoldersCursor CURSOR FOR
  Select FolderID from {objectQualifier}Folders

OPEN FoldersCursor

FETCH NEXT FROM FoldersCursor
  into @FolderID

WHILE @@FETCH_STATUS = 0
BEGIN

   if not exists (select * from {objectQualifier}FolderPermission where (PermissionID = @PermissionID) and (FolderID = @FolderID) and (RoleID=-1))
   begin
   insert into {objectQualifier}FolderPermission (FolderID, PermissionID, RoleID, AllowAccess) values (@FolderID, @PermissionID, -1, 1)
   end
   FETCH NEXT FROM FoldersCursor
     into @FolderID
END


CLOSE FoldersCursor
DEALLOCATE FoldersCursor

Run this script from host > sql, and all your folders, in all your portals will have read permissions for all users set.


Erik van Ballegoij, Former DNN Corp. Employee and DNN Expert

DNN Blog | Twitter: @erikvb | LinkedIn: Erik van Ballegoij on LinkedIn

 
New Post
1/25/2008 8:18 PM
 

Hi - I've got exactly the same problem in the Announcements Module on a DNN installation of 3.7 (running announcements module 03.03.05) - I have tried going to ADMIN > FILE MANAGER and ensuring the root portal folder is set so All Users have permissions to view (with no joy) I have experimented with all the permissions in ADMIN > FILE MANAGER and have tried synchronise files etc... no joy!!!

I have copied and pasted your script directly into HOST > SQL and ran it with no joy. I have even tried to run it in Query Analyser but I get a "[Microsoft][ODBC SQL Server Driver]Syntax error or access violation" error message.

I then tried to update to v4 of the announcements module, but it doesnt seem to have worked succefully.

Anyway I read somewhere regarding that if you uncheck the track link checkbox it will work - and sure enough it did....!!!!

In my DNN 4.7 installation, (running announcements module 03.04) there appears to be no problem...? 

 
New Post
1/27/2008 3:06 AM
 

David, the 4.0 version of the module needs dnn 4.6.x or newer, it will not work in older versions of DNN

Anyhow, this is not a module issue, but a core issue, as explained above. Turning off tracking linked the file directly i think in older dnn versions, which would bypass dnn file security. Hence the error does not happen anymore...

After running sql scripts you really should also restart the application, as info might be cached by DNN


Erik van Ballegoij, Former DNN Corp. Employee and DNN Expert

DNN Blog | Twitter: @erikvb | LinkedIn: Erik van Ballegoij on LinkedIn

 
New Post
11/12/2008 9:16 PM
 

Okay...  this is a major issue impacting DotNetNuke.  Here is a link to the smartest guys in the room on this issue.  This will prevent the problem in the future:

http://eguanasolutions.com/Blog/tabid/54/EntryID/1/Default.aspx

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsAnnouncementsAnnouncementsYou Do Not Have Permission To View The Requested FileYou Do Not Have Permission To View The Requested File


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