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 ForumsFeedbackFeedbackUnable to installUnable to install
Previous
 
Next
New Post
6/16/2010 6:42 PM
 
Hans,
That sounds like the same error that Marius M was having. It was due to a couple of missing {objectQualifier} tokens in the primary and foreign key constraint object names in the 05.00.00.SqlDataProvider script. I fixed it and uploaded refreshed install and source packages to CodePlex on May 26th.

Could you verify that you downloaded the package you tried to install after May 26th and if so, take a look at the created date of the DotNetNuke.Modules.Feedback.dll in the \bin folder. It should be Wednesday, ‎May ‎26, ‎2010, ‏‎5:32:32 PM. Also look at the first portion of the 05.00.00.SqlDataProvider script to confirm that it reads as follows:

ALTER TABLE {databaseOwner}{objectQualifier}Modules SET (LOCK_ESCALATION = TABLE)
GO

ALTER TABLE {databaseOwner}{objectQualifier}Feedback
       DROP CONSTRAINT PK_{objectQualifier}Feedback
GO

ALTER TABLE {databaseOwner}{objectQualifier}Feedback
       ADD CONSTRAINT
 PK_{objectQualifier}Feedback PRIMARY KEY CLUSTERED
 (
 FeedbackID
 ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
                                ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO

ALTER TABLE {databaseOwner}{objectQualifier}Feedback WITH NOCHECK ADD CONSTRAINT
 FK_{objectQualifier}Feedback_{objectQualifier}Modules FOREIGN KEY
 (
   ModuleID
 ) REFERENCES {databaseOwner}{objectQualifier}Modules
 (
 ModuleID
 ) ON UPDATE  NO ACTION
  ON DELETE  CASCADE
  NOT FOR REPLICATION

GO

If the created date and SqlDataProvider script matches, please confirm that you are running SQL Server 2005 in compatibility mode = 90 rather than 80 for the DNN installation's database.

Thanks!


Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
 
New Post
6/17/2010 4:44 PM
 
Bill,

Everything checks out as  you have stated in your reply.  However, I still get the same errors.

Now for the Database engine -- I am running SQL Server Developer Server 64 bit.  The version is 9.00.4053.00 for the AMD64 bit processor.  The issue seems to be the SET command from what I can tell.  However, if I remove this SET command, other issues are  exposed.

I have tried to re-install from scratch, after deleting Version 4.0.03 (?)..... and still come up with the same issues.

I will continue to investigate.

Regards
Hans
 
New Post
6/17/2010 9:37 PM
 
Hans,

I think we have solved this one. When I corrected the missing {objectQualifier} tokens primary key and foreign key constraint object names in the first part of the 05.00.00.SqlDataProvider script and uploaded refreshed beta packages to CodePlex on May 26th, I had just rebuilt my development system and switched from SQL Server 2005 to SQL Server 2008. Unfortunately when generating the new script I had not noticed that a SQL Server 2008 specific option set (LOCK_ESCALATION = TABLE) had been included. Since that is the only locking option available in SQL Server 2005, an invalid SQL syntax error was being raised causing the installation of the module to fail on systems running SQL Server 2005. Unfortunately, both the original poster of this thread and I had tested the script changes on systems running SQL Server 2008.

I have corrected the 05.00.00.SqlDataProvider script and have rebuilt/refreshed both install and source packages on CodePlex after testing installations against a DNN site running SQL Server 2005 with no {objectQualifier} token specified. Although the module version remains the same (05.00.00), you will note that the upload and created date is now June 17th. Please download and and test again.

Thanks for raising this issue! I have requested that the project be failed in the DotNetNuke extension projects Release Tracker and will quickly re-submit for further testing.

Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
 
New Post
6/18/2010 11:23 AM
 
Bill,

I had some other issues that I believe I have resolved in a manner that is SQL Server version  independent.  I sent you a separate message as well as a modified 05.00.00.SqlDataProvider script that worked on my installation for SQLServer 2005.

Really like the updates and modifications.  Thanks.

Regards
Hans
 
New Post
7/1/2010 2:03 PM
 
Version 05.00.01 RC has now been uploaded to Codeplex and has been submitted to the DotNetNuke Release Tracker for testing today. This version should correct all of the SQL Server 2005/2008 issues, several minor issues raised during previous release tracker testing, and add one enhancement - that being the conversion of the Feedback form to a tableless design that is much more customizable via modifications to the module.css style sheet.

Thanks Hans tracking down the SQL Server 2005 incompatibility and suggesting the addition of an IF EXISTS test around the drop of the primary key on the Feedback table. I was not able to recreate that later issue but agree that it's a good safety measure, particularly for the upgrade/re-install situation.

Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsFeedbackFeedbackUnable to installUnable to install


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