how to install database on godaddy.com hosting

Reply

dotnetlover Posted: Sat, May 24 2008 5:21 PM

rated by 0 users

Hi,

I'm installing a database on godaddy.  I'm ending with the error

Reply

Alex Crome replied on Sat, May 24 2008 5:30 PM

rated by 0 users

 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.

Reply

dotnetlover replied on Sat, May 24 2008 5:41 PM

rated by 0 users

 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...

Reply

Alex Crome replied on Sat, May 24 2008 6:18 PM

rated by 0 users

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.

Reply

Khoai replied on Sun, May 25 2008 12:13 AM

rated by 0 users

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

Reply

dotnetlover replied on Sun, May 25 2008 2:30 PM

rated by 0 users

 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.