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