Errors occured during the execution of this wizard.

Reply

Şener KOÇ Posted: Fri, Mar 28 2008 7:06 AM

rated by 0 users

 I'm trying to install CS 2008 Beta 2, following error accured;

 Errors occured during the execution of this wizard.

My system information;

Operating system : Vista Ultimate
Operating System      6.0.6000
Microsoft Internet Explorer      7.0.6000.16609
Microsoft .NET Framework      2.0.50727.312
SQL Server : Microsoft SQL Server Standard Edition
Microsoft SQL Server Management Studio      9.00.3042.00
Microsoft Analysis Services Client Tools      2005.090.3042.00
Microsoft Data Access Components (MDAC)      6.0.6000.16386 (vista_rtm.061101-2205)
Microsoft MSXML      3.0 4.0 5.0 6.0
Server Collation : Turkish_CS_AS

I think error coused by CI_AS collation, Its happend before other applications. In CI_AS UserId and UserID is totaly diffrent words.

if anybody say where do I need the fix in sql script, I will be happy for it,

thank you,

Sener

Reply

Şener KOÇ replied on Fri, Mar 28 2008 7:52 AM

rated by 0 users

I added a new database  Latin1_General_CI_AS, this time I get following error.

Reply

Şener KOÇ replied on Fri, Mar 28 2008 9:43 AM

rated by 0 users

 ###------------- cs_Schema.sql -------------###

Error : ExecuteSqlInFile Error in file:D:\WorkROOT\BisikletcilerCS\PUBLISH\installer\SqlScripts\cs_Schema.sql
Message:Foreign key 'FK__cs_Folder__UserI__57A801BA' references invalid column 'UserId' in referenced table 'cs_Users'. Could not create

constraint. See previous errors.

Fix 1: ----------------

CREATE TABLE [dbo].[cs_Folder]
(
 FolderId INT IDENTITY(1, 1) NOT NULL
  PRIMARY KEY NONCLUSTERED,
 UserId INT NOT NULL
  REFERENCES cs_Users(UserId),
 FolderName NVARCHAR(50) NOT NULL,
 ParentFolderId INT NULL
  REFERENCES cs_Folder(FolderId),
 SettingsID INT NOT NULL
  REFERENCES cs_SiteSettings(SettingsID)
)

CREATE TABLE [dbo].[cs_Folder]
(
 FolderId INT IDENTITY(1, 1) NOT NULL
  PRIMARY KEY NONCLUSTERED,
 UserId INT NOT NULL
  REFERENCES cs_Users(UserID),
 FolderName NVARCHAR(50) NOT NULL,
 ParentFolderId INT NULL
  REFERENCES cs_Folder(FolderId),
 SettingsID INT NOT NULL
  REFERENCES cs_SiteSettings(SettingsID)
)

Fix 2 ----------------

CREATE TABLE [dbo].[cs_UserReadPost]
(
 UserId INT NOT NULL
  PRIMARY KEY NONCLUSTERED (UserId, FeedPostId)
  FOREIGN KEY REFERENCES cs_Users(UserId) ,
 FeedPostId INT NOT NULL
  REFERENCES cs_FeedPost(FeedPostId)
 
)

CREATE TABLE [dbo].[cs_UserReadPost]
(
 UserId INT NOT NULL
  PRIMARY KEY NONCLUSTERED (UserId, FeedPostId)
  FOREIGN KEY REFERENCES cs_Users(UserID) ,
 FeedPostId INT NOT NULL
  REFERENCES cs_FeedPost(FeedPostId)
 
)

###------------- cs_UpdateSchemaAndProcedures.sql -------------###
Error : Message:Invalid column name 'UrlID'. Invalid column name 'UrlID'. Invalid column name 'Url'. Invalid column name 'Description'.

Invalid column name 'Impressions'.

Desc : its coused by "cs_UrlRedirects" table.. so we need to go back to cs_Schema.sql for fixing...

Fix 3 ----------------

CREATE TABLE [dbo].[cs_UrlRedirects] (
            [urlID] [int] IDENTITY (1, 1) NOT NULL ,
            [url] [nvarchar] (4000) NOT NULL ,
            [impressions] [int] NOT NULL ,
            [description] [nvarchar] (2000) NULL
) ON [PRIMARY]

CREATE TABLE [dbo].[cs_UrlRedirects] (
            [UrlID] [int] IDENTITY (1, 1) NOT NULL ,
            [Url] [nvarchar] (4000) NOT NULL ,
            [Impressions] [int] NOT NULL ,
            [Description] [nvarchar] (2000) NULL
) ON [PRIMARY]

Fix 4 ----------------

CONSTRAINT [IX_cs_UrlRedirects] UNIQUE  NONCLUSTERED ([urlID]) ON [PRIMARY]

CONSTRAINT [IX_cs_UrlRedirects] UNIQUE  NONCLUSTERED ([UrlID]) ON [PRIMARY]

Fix 5 ----------------

CONSTRAINT [DF_cs_UrlRedirects_views] DEFAULT (0) FOR [impressions],

CONSTRAINT [DF_cs_UrlRedirects_views] DEFAULT (0) FOR [Impressions],

###------------- cs_UpdateSchemaAndProcedures.sql -------------###
ExecuteSqlInFile Error in file:D:\WorkROOT\BisikletcilerCS\PUBLISH\installer\SqlScripts\cs_UpdateSchemaAndProcedures.sql
Message:Invalid column name 'UserID'.

Desc : so.. we need to back again!

Fix 6 ----------------

CREATE TABLE [dbo].[cs_UserReadPost]
(
 UserId INT NOT NULL
  PRIMARY KEY NONCLUSTERED (UserId, FeedPostId)
  FOREIGN KEY REFERENCES cs_Users(UserID) ,
 FeedPostId INT NOT NULL
  REFERENCES cs_FeedPost(FeedPostId)
 
)

CREATE TABLE [dbo].[cs_UserReadPost]
(
 UserID INT NOT NULL
  PRIMARY KEY NONCLUSTERED (UserID, FeedPostId)
  FOREIGN KEY REFERENCES cs_Users(UserID) ,
 FeedPostId INT NOT NULL
  REFERENCES cs_FeedPost(FeedPostId)
 
)

Fix 7 ----------------

CREATE CLUSTERED INDEX Idx_UserReadPost_UserIdFeedId ON [dbo].cs_UserReadPost(UserId, FeedPostId)

CREATE CLUSTERED INDEX Idx_UserReadPost_UserIdFeedId ON [dbo].cs_UserReadPost(UserID, FeedPostId)

FINALLY!!

Complete!

Your connectionStrings.config file was successfully updated with the new connection string
Click here to navigate to your new site.

IMPORTANT: You should now have a working Community Server installation. It is strongly recommended that you disable the Community Server Web

Wizard to prevent unauthorized access to your server. To disable the Community Server Web Installation Wizard open the

/Installer/default.aspx file found on your web server and follow the instructions (in the file) to disable the installer.

NAAAA!! when you clik "Click here to navigate to your new site." new error show up!!

--------------------------------------------------------------------------------

Server Error in '/' Application.
--------------------------------------------------------------------------------

The Registration object does not contain a property 'IsCommercial'
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more

information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: The Registration object does not contain a property 'IsCommercial'

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the

exception can be identified using the exception stack trace below. 

Stack Trace:

[InvalidOperationException: The Registration object does not contain a property 'IsCommercial']
   CommunityServer.Controls.RegistrationPropertyValueComparison.GetPropertyValue(String property) +250
   CommunityServer.Controls.RegistrationPropertyValueComparison.GetLeftValue() +59
   CommunityServer.Controls.ComparisonConditionBase.get_Result() +14
   CommunityServer.Controls.Conditions.get_Result() +139
   CommunityServer.Controls.WrappedContentBase.DataBind() +76
   CommunityServer.Controls.WrappedContentBase.OnPreRender(EventArgs e) +102
   System.Web.UI.Control.PreRenderRecursiveInternal() +77
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360

--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.312; ASP.NET Version:2.0.50727.833

--------------------------------------------------------------------------------

so... what is next??

Reply

Şener KOÇ replied on Fri, Mar 28 2008 10:09 AM

rated by 0 users

 http://communityserver.org/forums/t/489107.aspx

Reply

Şener KOÇ replied on Fri, Mar 28 2008 10:16 AM

rated by 0 users

 I found following related topic, but there is no solution.

http://communityserver.org/forums/t/489107.aspx

Reply

dpenton replied on Fri, Mar 28 2008 10:28 AM

rated by 0 users

All,

Until our next release of code, server collations other than Latin1_General_CI_AS don't work as expected easily.  I updated several locations in our schema patches to handle these situations.

Thanks,
David L. Penton

Reply

Şener KOÇ replied on Fri, Mar 28 2008 3:34 PM

rated by 0 users

 Hi David,

My bug report is usefull or not? if you allready fix this bugs, I'm not spend my time to figue out :)

thank you,

Sener Koc
Web Technologist

Reply

dpenton replied on Fri, Mar 28 2008 4:09 PM

rated by 0 users

 Sener,

Between Community Server 2007.1 and now, we have made many updates to handle case sensitive installations of Community Server and [now] to accommodate for alternate database collations.  Hopefully that will take care of your concerns.

Thanks,
David L. Penton

Reply

Şener KOÇ replied on Fri, Mar 28 2008 4:37 PM

rated by 0 users

 I decide to wait 2008 final and I tryed to install CS 2007.1 but there is same error occour :(

In the same time I'm trying to buy professional account and gold support, but I can't even install it.. How much time to take fix this case sensitivity issue?

Reply

Şener KOÇ replied on Fri, Mar 28 2008 6:03 PM

rated by 0 users

 I fixed same things on the CS2008 script to CS2007, then its show 2 diffrent UserId/UserID error.. I fixed them to.. then show me an new error in cs_UpdateSchemaAndProcedures.sql. I changed constraintName to ConstraintName. Its okay to..

then when I try again this time show me an diffrent error.

 Do you have an idea?

I replaced CS2007 InstallProfile.sql file with InstallProfile.sql file in CS2008. it must be same file right?

then new error show up

back to same file again :) ... there is one work in cs_UpdateSchemaAndProcedures.sql

I replaced isIndexed to IsIndexed

so.. I got new error,

I changed userID to UserID its okay. but Im stuck with others..

Reply

Şener KOÇ replied on Sat, Mar 29 2008 9:48 AM

rated by 0 users

Finally, I fixed CS2007 sql scripts to.. but result is same..

The Registration object does not contain a property 'IsCommercial'

if you give me an e-mail I can mail it to you both case sensitivity fixed sql scripts..

If next release will not be soon, What sql collation do I need to setup for CS2007.

thank you,

Sener

Reply

Şener KOÇ replied on Mon, Mar 31 2008 7:10 PM

rated by 0 users

any progress?

Reply

Jose Lema replied on Wed, Apr 16 2008 4:07 AM

rated by 0 users

Hi Sener,

Can you verify against the final RTM version of CS 2008 that's now available at http://get.communityserver.com/download?

Thanks..

Reply

Şener KOÇ replied on Wed, Apr 16 2008 5:58 AM

rated by 0 users

I changed my database collation and its solved.

thank you for asking