Hi,
I'm installing a database on godaddy. I'm ending with the error
dotnetlover: Hi, I'm installing a database on godaddy. I'm ending with the error Schema Already Exists The Installer does not support installing Community Server into a database with an existing Community Server schema. Please run the appropriate upgrade script to upgrade your database. Can someone please tell me what I need to run an update? Thanks
First of all, you need to delete the current database on godaddy and create a new one. Open the Default.aspx in Installer folder and find the code from line 563 to 606 :
try { SqlConnection connection = new SqlConnection(GetConnectionString()); SqlDataReader dr; SqlCommand command = new SqlCommand("select name from master..sysdatabases order by name asc", connection);
connection.Open();
// Change to the master database // connection.ChangeDatabase("master");
dr = command.ExecuteReader();
db_name_list.Items.Clear();
while (dr.Read()) { string dbName = dr["name"] as String; if( dbName != null ) { if( dbName == "master" || dbName == "msdb" || dbName == "tempdb" || dbName == "model" ) { // skip the system databases continue; } else { db_name_list.Items.Add( dbName ); } } }
connection.Close(); errorMessage = ""; return true; } catch( Exception e ) { errorMessage = e.Message; return false; }}
Replace the above code by the below code:
{ db_name_list.Items.Clear(); db_name_list.Items.Add("DBName"); errorMessage = ""; return true; }
In which DBName is the Name of the dabase you created
When run the Installer remember to uncheck Script ASP.NET MemberRoles
Are you trying to install a new instance of Community Server, or are you trying to upgrade an existing database? Your first lines says you're "installing", but your second last line says that you're updating.
If you're doing an update, you can't upgrade CS2007 to CS2008 through a sql update - you have to use the CS Upgrader application to do that, although I understand doing that with GoDaddy can be a bit tricky as GoDaddy doesn't provide direct database access. The post at http://dev.communityserver.com/forums/p/498711/617982.aspx#617982 explains the options you have for upgrading on GoDaddy shared hosting.
If you're installing a fresh copy of CS, then you're trying to install CS into a database with an existing installation of CS in it. Trying to remove everything can be a pain so I'd recommend that you delete your database totally and recreate it before running the install script.
CS Documentation - now available in downloadable PDF form
My CS Site
Hi, Thank you for helping me.. This is my very first time installing cs2008 on godaddy.com. For some reason they have asked me to update a schema or something like that...I'm not sure what to do from here...
I'm still not 100% clear if you're upgrading an existing version of CS to CS2008, or doing your first install of CS.
If it's the latter, I suggest that you delete the database completely, and create a new one before trying the web installer. You can go through your database removing everything CS added to the database but it very quickly gets messy and you end up going round and round in circles.
Thank you..
I did tried all these steps. Unfortunately, I'm ending up with the error schema already exist?. I've tried to run asp.net 2.0 schema was provided from CS2008, but nothing to work. This is a step before it allows me to uncheck Script ASP.NET MemberRoles.
Copyright© 2008 Telligent Systems Inc. All rights reserved CommunityServer.com • Telligent.com