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 ...4.7.0 --> Vendors Details give ERROR4.7.0 --> Vendors Details give ERROR
Previous
 
Next
New Post
4/11/2007 2:45 PM
 

OK.   I took a look a DV's issue and fixed it.  I am posting what I found here so someone on the core team can be aware of it since it has happened on more than 1 install.

The entries for ROOT folders (FolderID 1) were missing from the FolderPermission table.  Not sure why.  Mine did not populate until I ran the sync in host filemanager.  However, running sync on his site did not correct the problem.

I inserted the 4 default rows from my install into the FolderPermission table for folderid 1 for roleid's 0,1,-1 and permissionID's 5 & 6.  Now it works!

Just FYI

 
New Post
4/11/2007 3:32 PM
 

Wallew, thanks for finding this. The issue is not completely clear. Personally, i've had similar issues in upgrading previous dnn version, and always tried to submit proper sql fixes to the core. From what i've seen there can be any number of reasons why the files / folders table and the corresponding permissions become corrupt... anyhow, this would be a good one to check in upgrade scripts.. i will follow up on that...


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

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

 
New Post
4/11/2007 3:39 PM
 

wallew wrote

{...}
I inserted the 4 default rows from my install into the FolderPermission table for folderid 1 for roleid's 0,1,-1 and permissionID's 5 & 6.  Now it works!
{...}

I do not know how to thank you wallew !!!! You are just perfect, I was about to forget DNN and going back to pure html language with FrontPage, thinking that DNN was for specialist only and not for people like me, who are doing a website for their hobby ! I had 2 problems in upgrading my DNN, and I was a little bit sad to see that I was alone.
1: I am not alone
2: there are people here to help us when we have problems. I also have other problems, and I am well helped by these people, THANK TO ALL OF THEM.

Wallew, if you have the script that you run, I would be very happy, because I have 3 other prod sites to migrate now (and the 2 have the problem). Thanks,

DV

 
New Post
4/11/2007 3:48 PM
 

I am listing these seperate because I don't know if all are really needed.  You could run one insert at a time and test the results.

WARNING!!  This code is posted as a coutesy and has NOT been fully tested.  Use at your own risk!

---Begin Script---

INSERT INTO [FolderPermission]
           ([FolderID]
           ,[PermissionID]
           ,[RoleID]
           ,[AllowAccess])
     VALUES
           (1
           ,5
           ,1
           ,1)

INSERT INTO [FolderPermission]
           ([FolderID]
           ,[PermissionID]
           ,[RoleID]
           ,[AllowAccess])
     VALUES
           (1
           ,5
           ,-1
           ,1)
INSERT INTO [FolderPermission]
           ([FolderID]
           ,[PermissionID]
           ,[RoleID]
           ,[AllowAccess])
     VALUES
           (1
           ,5
           ,0
           ,1)

INSERT INTO [FolderPermission]
           ([FolderID]
           ,[PermissionID]
           ,[RoleID]
           ,[AllowAccess])
     VALUES
           (1
           ,6
           ,0
           ,1)

 

 

---EndScript---

 
New Post
4/13/2007 6:06 PM
 

None of the ideas here worked for me, anybody have any other ideas?  I haven't launched my site yet, but I will need to be able to do Host level banners.  I am working with a 4.5 site that was upgraded from 4.41.

 

Thanks,

Rob

 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...4.7.0 --> Vendors Details give ERROR4.7.0 --> Vendors Details give ERROR


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