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 ForumsForumForumSame errorSame error
Previous
 
Next
New Post
9/4/2009 2:02 PM
 

Hello Mathias -

This is a site that I've recently upgraded from v3.2.2 through to 5.1.1
The only apparent problems were that I lost the Events that were stored in the old site during the v4.4.1 to 4.6.2 upgrade.
I was using ActiveForums on the old site - since most posts were <2 years old I decided to completely dump the 3rd party forum and use the new one after I got to v5.1.1 and recreate the few posts that were still relevant (it's basically a set of user group discussion forums).

Once I got the upgrade to DNN v5.1.1 the Forum module was at v4.4.3.
I saw that an update was available to v4.5.3 so I downloaded the Install version and ran "Install Module".

The errors I got above were from that initial install.

I then did a second install (which detected the v4.5.3 and allowed me to do a repair) and it finished with no errors.
HOWEVER, when I tried to change Settings for the new Forum Module I had just added to the page I got the following error:
    A critical error has occurred.
    The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Forum_UserForums_Forum_Forums".
    The conflict occurred in database "Portal", table "dbo.Forum_Forums", column 'ForumID'.
    The statement has been terminated.

What I have done at this point is to roll back to Forums v4.4.3 - I have added the forums module to a page, changed settings,
added discussions, threads, etc. ALL successful with this version!!

I did try uninstalling the v4.4.3 Forums module and then installing the v4.5.3 package, but got additional SQL type errors so gave that up as a bad deal :(

As an aside (sort of), I'm trying to provide several different departments forum access - but only to a "General" section PLUS their departmental section.
I am unable to find a way to control access to discussions WITHIN a forum by security role.
I tried adding 4 forums (as 'Add New Module') to the same page so that I could control access to each separately.
The access control works, however, when I open a thread from one of the forums it displays in ALL the visible forums on the page.
For example (as an administrator with all 4 visible - a department user displays only General + 1 Dept forum of the list below):
If I open the Dept3 Forum / Dept3 Forum / Dept3 Discussion / Subject1 / Thread1 the contents of Thread1 also displays in the other forums with the paths below
General Forum / General Forum / Dept3 Discussion / Subject1 / Thread1
Dept1 Forum / Dept1 Forum / Dept3 Discussion / Subject1 / Thread1
Dept2 Forum / Dept2Forum / Dept3 Discussion / Subject1 / Thread1

What's strange is that the "Dept3 Discussion" only exists in the "Dept3 Forum" when I go to "Forums Home"
In "Forums Home" the Discussions all appear correctly within their respective Forum modules...
Any ideas what's up with this?
Am I using the module incorrectly?
Or is there a way to control access to discussion groups within a single forum module (which is really how I'd like to do it)

Thanks for the help,
Doug

 
New Post
9/4/2009 8:07 PM
 

Hi Doug,

please uninstall the new form, then check the Database tables, spocs, views and functions if there still any Forum artifacts and delete them from the database.  After this check all your physical permissions on your DNN Files, and make sure all subfolders and files have the permissions setup well. Then go back to DNN, login as host, restart application in Host Settings, and re-try install the new Forum module.

If the Install fail It could be that any Forum artifacts still in the database, and so a new install fails.

Regards

Matthias

 
New Post
9/4/2009 8:11 PM
 

I don't suggest to use 4 module on one page!  You can control the permissions using the Forum manager for each forum module by role!

 
New Post
9/8/2009 3:03 PM
 

Thanks Mathias!

I figured out how to work the permissions - they are configurable at the forum level only (I've grouped forums into department 'groups' for clarity).
I also hadn't found the "private with post restrictions' options which lets me configure the various permissions...

I'll go back and look at the database side of things for 'leftovers' - I've checked file permissions and that's fine.

Thanks again,
Doug

 
New Post
9/8/2009 4:55 PM
 

THe FK_ issue you reported looks to me is by a issue on installing the forum 4.4.3.  The problem on upgrating modules on DNN is, if you have a issue on your databse of the installed module, and you try to upgrade to a newer version the SQL Cripts can run into a error.  Especially all keys like FK, DF, anc contrains cane make problems if they are not well setting in the existing database if you try to make a upgrade. 

To find out what happens with it it need a manual check of all Forum database artifacts.

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForumForumSame errorSame 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