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 ForumsForumForumError in view: Forum_vw_ForumUsersError in view: Forum_vw_ForumUsers
Previous
 
Next
New Post
4/15/2011 5:18 PM
 
This view refers to 2 fields that do not exist in the table: Forum_Users

The field names are: EnableDisplayInMemberList and EnablePM.

SELECT U.Username, U.FirstName, U.LastName, U.DisplayName, U.Email, 
U.UserID, FU.PortalID, FU.EnablePM, FU.EnableOnlineStatus, 
FU.EnableDisplayInMemberList, FU.PostCount, UP.CreatedDate
FROM dbo.Users U INNER JOIN
dbo.Forum_Users FU ON U.UserID = FU.UserID INNER JOIN
dbo.UserPortals UP ON U.UserID = UP.UserId AND 
FU.PortalID = UP.PortalId
WHERE (FU.EnableDisplayInMemberList = 1)
 
New Post
4/15/2011 8:41 PM
 
please check, whether you are using latest version of the stored procedure and all upgrade scripts have been processed successfully.

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
4/16/2011 7:36 AM
 
Hello Sebastian.

I checked the Upgrade Logs on the Host Settings page for version 5.6.2, DotNetNuke Schema, and DotNetNuke.Data.  The response is that the logs are empty.  When I ran the 5.6.2 upgrade, I did it manually, and there were no errors returned.  I have also re-run the Forum 5.0.1 install to try to repair the module installation.  There were no errors during the installation, but the forum still returns the same error.

I am going to try uninstalling 5.0.1 and installing 5.0.0.

Thanks for your help

 
New Post
4/16/2011 9:53 AM
 
Chris, to rerun an upgrade script, load it into textbox in Host > SQL, check "run as script" and execute. Do same with all subsequent scripts in proper order.

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
4/16/2011 10:27 AM
 
Hi Sebastian.
Are you referring to the SqlDataProvider scripts, or is there an overall module upgrade script?
Thanks.
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForumForumError in view: Forum_vw_ForumUsersError in view: Forum_vw_ForumUsers


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