By linguaetc on

I have been using Drupal for over a year with three sites using one code base but three different databases. All three sites have their own TLD. Yesterday I tried to install three subdomains to one of the TLD using the same code base but with three new databases. I have setup the subdomains in the CPanel of Bluehost.com
When I typed in anyone of the three subdomains in my browser (i.e. www.bankruptcy.rdhamilton.com), I received a page full of error messages:

Warning: Table 'linguaet_bankruptcy.bankruptcyaccess' doesn't exist query: SELECT 1 FROM bankruptcyaccess WHERE type = 'host' AND LOWER('XX.XX.XX.XXX') LIKE LOWER(mask) AND status = 0 LIMIT 0, 1 in /home/linguaet/drupal-6.1/includes/database.mysql.inc on line 128

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/linguaet/drupal-6.1/includes/database.mysql.inc:128) in /home/linguaet/drupal-6.1/includes/bootstrap.inc on line 976

It does not seem to be automatically go to the install.php file. Therefore, to get around the above error I must type subdomain.domain.com/install.php

The installation starts, I choose the language (English), it verifies the requirements, sets-up the database tables and then skips the Database Configuration window and provides me with the following error:

Drupal already installed

* To start over, you must empty your existing database.
* To install to a different database, edit the appropriate settings.php file in the sites folder.
* To upgrade an existing installation, proceed to the update script.
* View your existing site.

I have seen this problem in the forums but there has been no explanation of why it is happening or how to fix it.

I have spent hours trying to get it working and need some help on where I should be looking. The file structures have been set-up exactly the same as I have for the two "non main" TLD since they affectively work as subdomains on Bluehost.com (i.e. www.itslife.ca). I have used the following with success (until now) as my guide: http://justinhileman.info/blog/2007/06/a-more-secure-drupal-multisite-in...

⋅ Categories: Drupal 6.x

Comments

linguaetc’s picture

linguaetc commented

I have continued to play with settings.php and found that line 174 is causing the problem:

'site_name' => 'bankruptcy.rdhamilton.com',

As soon as I put a # in front of the line and run install.php, the install works.

Is this a bug in 6.1 as I had no problem with it in version 5.x?

w00’s picture

w00 commented

It's repeatable. Whether the bug is in allowing a settings.php to specify a conf['name'] or in testing for re-installing over existing site is undecided.

What's happening is that there's some code in install.php that's testing for existing site_name and exiting.

If you have a conf['site_name'] specified in a multisite (or main installation?) settings.php, then it will fail because install.php line:710(-ish) has this:

if ($task == 'configure') {
if (variable_get('site_name', FALSE) || variable_get('site_mail', FALSE)) {
// Site already configured: This should never happen, means re-running
// the installer, possibly by an attacker after the 'install_task' variable
// got accidentally blown somewhere. Stop it now.
install_already_done_error();
}

There is a similar statement on line #717.

Note that to tweak this, do it in the install.php in the base of your Drupal, NOT the multisite specific folder where the custom settings.php file with the conf['site_name']="my site" setting is.

I'm looking at a better way to test for an existing site while allowing a multisite settings.php file be loaded with conf settings. Perhaps query for count of nodes > 0?

However, isn't it more likely that this current safety feature is causing more harm (failed multisite installs with incorrect message) than someone attempting to reinstall a current installation? I haven't looked, but aren't there other mechanisms to detect existing site, such as failure at creating tables due to them already existing?

NB It's mid-October, 2010. Thread started April 2008!?!

w00’s picture

w00 commented

I'd forgotten the Drupal version number I'm using, and it's the current one (6.19).

I'm going to check if the same "bug" is in v7.

Phish’s picture

Phish commented

just wanted to say THANK YOU! I was having a problem installing 5.7 for a couple weeks now, though I had absolutely no problems with 6.1... Anywho, I did as you said and went to the install.php manually and everything created great! No more errors...yet :)

mirjana’s picture

mirjana commented

Hi,

I am new in Drupal.
Also keep getting the same error as stated above "Drupal already installed", after trying to add SMF forum in the site. Cannot get rid of it. Read lot of posts in the forum, but no luck with any option.

Anyone has any idea about it.

Many thanks in advance,
Regards,
Mirjana