[support] multi-site question

Miles Fidelman mfidelman at meetinghouse.net
Thu Jan 25 18:05:32 UTC 2007


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


More information about the support mailing list