[support] multi-site question

[Miles Fidelman]

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 at drupal.org [mailto:support-bounces at drupal.org] On
> Behalf Of Miles Fidelman
> Sent: Thursday, January 25, 2007 10:06 AM
> To: support at 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
>