Cool. That did it!

Thanks much,

Miles

Greg Holsclaw wrote:

I have seen this a few times. Go straight to the install.php file in your broswers, instead of relying on Drupal to know to find it.

Greg

-----Original Message----- From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Miles Fidelman Sent: Thursday, January 25, 2007 10:06 AM To: support@drupal.org Subject: [support] multi-site question

Hi Folks,

Just tried to install a 2nd site on a Drupal 5 installation, using a common codebase, but a separate database:

• running on a separate IP address
• created a separate mysql database
• setup the Apache information
• created a sites/secondhost directory
• copied sites/default/settings.php into the new directory
• edited settings.php to point to the new database
• restarted apache

When I try to access the site, I get a screen full of errors, starting with: *Warning*: Table 'gd.access' doesn't exist query: SELECT CASE WHEN status=1 THEN 0 ELSE 1 END FROM access WHERE type = 'host' AND LOWER('24.60.167.199') LIKE LOWER(mask) ORDER BY status DESC LIMIT 0, 1 in */var/drupal/includes/database.mysql.inc* on line *167*

It looks like Apache is going to the common codebase, and Drupal is finding the proper settings file, but.... Drupal doesn't seem to realize

this is a new installation, and doesn't try to run the initialization routines to create and populate tables.

If I delete settings.php, it tries to log into my default site.

So... how do I get Drupal to initialize the new site?

Thanks much,

Miles Fidelman