If you anyone gets these errors from Dotnetnuke Forum Stored Procedures…
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’.
This is because the table columns were changed without updating their relevant stored procedures. After looking at the stored procs and the table structures, it seems that:
IsPrivate is now PublicView &
LastForumsView is now LastActivity.
Changing the variables mentioned temporarily fixed my problems.
HTHs,
Thuan