Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

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 ForumsForumForumForum Stored Procedure ProblemsForum Stored Procedure Problems
Previous
 
Next
New Post
6/13/2008 11:11 AM
 
anthony

Joined: 9/7/2007
Posts: 16

i am getting the following errors.  I know how the column can be missing.  does anyone have an idea why?

Msg 207, Level 16, State 1, Procedure Forum_AA_StatisticsSiteUpdate, Line 64
Invalid column name 'IsPrivate'.
Msg 207, Level 16, State 1, Procedure Forum_AA_StatisticsSiteUpdate, Line 78
Invalid column name 'IsPrivate'.
Msg 207, Level 16, State 1, Procedure Forum_ForumUserViewsUpdate, Line 0
Invalid column name 'LastForumsView'.
 
New Post
6/13/2008 11:22 AM
 
Matthias Schlomann


Joined: 8/10/2003
Posts: 3594

What have you done?  What DNN version, what Forum version? Have you a complete error log in the event viewer?

Regards
Matthias
DNN MVP
www.aarsys.de
Metro7 Skin
ShoutCastStats Module for DNN
 
New Post
1/28/2009 11:14 AM
 
SadisticRabbit

Joined: 4/11/2008
Posts: 61

DNN Version: 04.09.00
Forum Module: 04.04.03

I am getting this error also. I am doing an import of my Live database to a backup SQL server. I have used the Import Wizard as well as the Red Gate SQL Compare v7

"Msg 207, Level 16, State 1, Procedure pr_Forum_ForumUserViewsUpdate, Line 9
Invalid column name 'LastForumsView'."

I am also getting

"Msg 207, Level 16, State 1, Procedure pr_Forum_AA_StatisticsSiteUpdate, Line 61
Invalid column name 'IsPrivate'.
Msg 207, Level 16, State 1, Procedure pr_Forum_AA_StatisticsSiteUpdate, Line 75
Invalid column name 'IsPrivate'."

 
 
New Post
2/25/2009 7:38 AM
 
piet

Joined: 2/16/2009
Posts: 1

You get this error also if you script the latest DNN 5.0.0 version.

The problem is that the stored procedure forum_AA_statisticsSiteUpdate uses two references to the table column name "IsPrivate" in the table Forum and this field is not present in this table.

The same error can occur for the stored procedure forum_forumuserviewsupdate with the invalid columnname "LastForumsView".

I don't know why the stored procedures are not correct anymore, maybe after changing the forum tables the stored procedures where not all correctly adjusted.

To solve the problem the stored procedures have to be redesigned so they work correctly and possible "dead-ends" in the proc doesn't cause problems with scripting.

 P. Bos

www.dotprof.nl
 
New Post
6/8/2009 4:40 PM
 
Charles

Joined: 11/26/2008
Posts: 1

I am currently experiencing the exact same problems in migrating a DNN database to another server.

 

Has this been identified as a bug or fixed in some other patch?
 
 Page 1 of 2
12Next 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForumForumForum Stored Procedure ProblemsForum Stored Procedure Problems


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