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/8/2009 5:32 PM
 
Matthias Schlomann


Joined: 8/10/2003
Posts: 3594

Where will no patch be availible from the team.  It looks to be a issue on migrating the database.  Not sure what is going on with your migrating.  But I also never get any information how you done your migrate. So I can not help. 

Some issue on migrating to a other server is that some web.config settings not well setting up.  I have see this several times.  But you can rework the spocs with MS SQL Server Management Studio.

Regards
Matthias
DNN MVP
www.aarsys.de
Metro7 Skin
ShoutCastStats Module for DNN
 
New Post
8/11/2009 6:41 PM
 
Ferit Nuri


www.fnthosting.com
Joined: 9/4/2003
Posts: 15

Same problem with dnn version 05.01.01 and forum version 04.05.03. If complete generate script dnn database with "MS SQL Server Database Publishing Wizard" then executing this generated script to another new database, the query completed with following error:

Msg 207, Level 16, State 1, Procedure Forum_ForumUserViewsUpdate, Line 13
Invalid column name 'LastForumsView'.

To fix the issue, add the forgatten field "LastForumView" following line to the table "Forum_Users" create section in the script, then simply re-execute the script:
[LastForumsView] [datetime] NULL

I am not good at writing english. sorry..
 
New Post
8/12/2009 7:29 AM
 
Chris Paterra


Joined: 4/5/2003
Posts: 4377

OK, something didn't fire off in your upgrade scripts. For example, the Forum_AA_Statistics stored procedure shouldn't even exist. I am not sure why this wasn't dropped but I can assure you it shouldn't be there now. I am not sure why the UserViewsUpdate one isn't up to date, so I am going to paste what it should look like today.  What I would like to know from anyone having issues is: Was it an upgrade or a new install (which version were you using previously, I assume new installs don't have this issue). Also, are you using any object qualifier or database owner parameters. Thanks.

ALTER

PROCEDURE [dbo].[dnn_Forum_ForumUserViewsUpdate]

(

@UserID

int,

@ForumID

int

)

AS

UPDATE

 dbo.dnn_Forum_Users

SET

[LastForumsView]

 = getdate()

WHERE

[UserID]

 = @UserID

-- If read/unread tracking record for this user has not been created yet, create

IF

 NOT EXISTS(SELECT UserID FROM dbo.dnn_Forum_ThreadsRead (nolock) WHERE ForumID = @ForumID AND UserID = @UserID)

BEGIN

print

 'insert'

 

INSERT dbo.dnn_Forum_ThreadsRead

 

(UserID, ForumID, ReadThreads, LastPurseDate)

 

 

VALUES(@UserID, @ForumID, '', '01/01/2000')

END

Chris Paterra

Get direct answers to your questions in the Community Exchange.
 
 Page 2 of 2
Previous12 
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