Drupal for 2 Domans - 1 works, 1 doesn't

By votersmind on 1 Jun 2007 at 01:28 UTC

Hello,

I had a an older domain that used drupal. Yesterday I added two new alternate domains under the old site. I uploaded the new drupal 5.x and created two databases, one for each site to contain the drupal uploads. The first one was fine. Took a while to get set up but it works. The second however gave me a huge error on the initial setup page using a seperate database in settings.php. When I use the first database created, it mirrors the first new site, but when I try to create a new drupal system with the second new database (named "drupal3"), I get this:

Warning: Table 'votersmind_com_-_drupal3.access' doesn't exist query: SELECT CASE WHEN status=1 THEN 0 ELSE 1 END FROM access WHERE type = 'host' AND LOWER('76.182.70.20') LIKE LOWER(mask) ORDER BY status DESC LIMIT 0, 1 in /home/virtual/site307/fst/var/www/html/aurelianhouse.com/includes/database.mysql.inc on line 172

Warning: Table 'votersmind_com_-_drupal3.users' doesn't exist query: SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid = 'af6351ed26fc8aabdd5418bf9b7c6c3b' in /home/virtual/site307/fst/var/www/html/aurelianhouse.com/includes/database.mysql.inc on line 172

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/virtual/site307/fst/var/www/html/aurelianhouse.com/includes/database.mysql.inc:172) in /home/virtual/site307/fst/var/www/html/aurelianhouse.com/includes/bootstrap.inc on line 811

Warning: Table 'votersmind_com_-_drupal3.cache' doesn't exist query: SELECT data, created, headers, expire FROM cache WHERE cid = 'variables' in /home/virtual/site307/fst/var/www/html/aurelianhouse.com/includes/database.mysql.inc on line 172

Warning: Table 'votersmind_com_-_drupal3.variable' doesn't exist query: SELECT * FROM variable in /home/virtual/site307/fst/var/www/html/aurelianhouse.com/includes/database.mysql.inc on line 172

Warning: Table 'votersmind_com_-_drupal3.cache' doesn't exist query: LOCK TABLES cache WRITE in /home/virtual/site307/fst/var/www/html/aurelianhouse.com/includes/database.mysql.inc on line 172

Warning: Table 'votersmind_com_-_drupal3.cache' doesn't exist query: UPDATE cache SET data = 'N;', created = 1180661288, expire = 0, headers = '' WHERE cid = 'variables' in /home/virtual/site307/fst/var/www/html/aurelianhouse.com/includes/database.mysql.inc on line 172

Warning: Table 'votersmind_com_-_drupal3.cache_page' doesn't exist query: SELECT data, created, headers, expire FROM cache_page WHERE cid = 'http://www.aurelianhouse.com/' in /home/virtual/site307/fst/var/www/html/aurelianhouse.com/includes/database.mysql.inc on line 172

Warning: Cannot modify header information - headers already sent by (output started at /home/virtual/site307/fst/var/www/html/aurelianhouse.com/includes/database.mysql.inc:172) in /home/virtual/site307/fst/var/www/html/aurelianhouse.com/includes/bootstrap.inc on line 488

Warning: Table 'votersmind_com_-_drupal3.url_alias' doesn't exist query: SELECT COUNT(pid) FROM url_alias in /home/virtual/site307/fst/var/www/html/aurelianhouse.com/includes/database.mysql.inc on line 172

Warning: Table 'votersmind_com_-_drupal3.system' doesn't exist query: SELECT * FROM system WHERE type = 'theme' in /home/virtual/site307/fst/var/www/html/aurelianhouse.com/includes/database.mysql.inc on line 172

Warning: Table 'votersmind_com_-_drupal3.watchdog' doesn't exist query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Cannot modify header information - headers already sent by (output started at /home/virtual/site307/fst/var/www/html/aurelianhouse.com/includes/database.mysql.inc:172) in /home/virtual/site307/fst/var/www/html/aurelianhouse.com/includes/common.inc on line 141.', 2, '', 'http://www.aurelianhouse.com/', '', '76.182.70.20', 1180661288) in /home/virtual/site307/fst/var/www/html/aurelianhouse.com/includes/database.mysql.inc on line 172

Warning: Table 'votersmind_com_-_drupal3.watchdog' doesn't exist query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'votersmind_com_-_drupal3.system' doesn't exist\nquery: SELECT name, filename, throttle, bootstrap FROM system WHERE type = 'module' AND status = 1 ORDER BY weight ASC, filename ASC in /home/virtual/site307/fst/var/www/html/aurelianhouse.com/includes/database.mysql.inc on line 172.', 2, '', 'http://www.aurelianhouse.com/', '', '76.182.70.20', 1180661288) in /home/virtual/site307/fst/var/www/html/aurelianhouse.com/includes/database.mysql.inc on line 172

Warning: Table 'votersmind_com_-_drupal3.watchdog' doesn't exist query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'votersmind_com_-_drupal3.cache_menu' doesn't exist\nquery: SELECT data, created, headers, expire FROM cache_menu WHERE cid = '0:en' in /home/virtual/site307/fst/var/www/html/aurelianhouse.com/includes/database.mysql.inc on line 172.', 2, '', 'http://www.aurelianhouse.com/', '', '76.182.70.20', 1180661288) in /home/virtual/site307/fst/var/www/html/aurelianhouse.com/includes/database.mysql.inc on line 172

Warning: Table 'votersmind_com_-_drupal3.watchdog' doesn't exist query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'votersmind_com_-_drupal3.cache_menu' doesn't exist\nquery: UPDATE cache_menu SET data = 'a:4:{s:10:\\"path index\\";a:0:{}s:5:\\"items\\";a:2:{i:0;a:5:{s:4:\\"path\\";s:0:\\"\\";s:5:\\"title\\";s:0:\\"\\";s:4:\\"type\\";i:1;s:3:\\"pid\\";i:1;s:8:\\"children\\";a:1:{i:0;i:1;}}i:1;a:6:{s:3:\\"pid\\";i:0;s:4:\\"path\\";s:0:\\"\\";s:5:\\"title\\";s:10:\\"Navigation\\";s:6:\\&amp in /home/virtual/site307/fst/var/www/html/aurelianhouse.com/includes/database.mysql.inc on line 172

Warning: Table 'votersmind_com_-_drupal3.watchdog' doesn't exist query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'votersmind_com_-_drupal3.watchdog' doesn't exist\nquery: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'page not found', 'node', 1, '', 'http://www.aurelianhouse.com/', '', '76.182.70.20', 1180661288) in /home/virtual/site307/fst/var/www/html/aurelianhouse.com/includes/database.mysql.inc on line 172.', 2, '', 'http://www.aurelianhouse.com/', '', '76.182.70.20', 1180661288) in /home/virtual/site307/fst/var/www/html/aurelianhouse.com/includes/database.mysql.inc on line 172

Fatal error: Call to undefined function: block_list() in /home/virtual/site307/fst/var/www/html/aurelianhouse.com/includes/theme.inc on line 1013

Warning: Table 'votersmind_com_-_drupal3.watchdog' doesn't exist query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'votersmind_com_-_drupal3.sessions' doesn't exist\nquery: INSERT INTO sessions (sid, uid, cache, hostname, session, timestamp) VALUES ('af6351ed26fc8aabdd5418bf9b7c6c3b', 0, 0, '76.182.70.20', 'messages|a:1:{s:5:\\"error\\";a:7:{i:0;s:269:\\"warning: Cannot modify header information - headers already sent by (output started at /home/virtual/site307/fst/var/www/html/aurelianhouse.com/includes/database.mysql.inc:172) in /home/virtual/site307/fst/var/www/html/aurelianhouse.com/includes/common.inc on line 141.\\";i:1;s:326:\\"user warning: Table &#039;votersmind_com_-_drupal3.system&#039; doesn&amp in /home/virtual/site307/fst/var/www/html/aurelianhouse.com/includes/database.mysql.inc on line 172

Comments

Check your $db_url

styro commented 1 June 2007 at 01:37

in settings.php.

It looks like you've set your database name to "votersmind_com_-_drupal3"

--
Anton
New to Drupal? | Troubleshooting FAQ
Example knowledge base built with Drupal

drupal3 is the second

votersmind commented 1 June 2007 at 02:49

drupal3 is the second database for the second site.

drupal2 is the first database with the first site that works. When I put drupal2 it just mirrors the first site under the second name. It does not create a new drupal site under the second site domain name.

Also, I uploaded Drupal 5.x twice, once in each alternate directory.

Maybe I should have started

votersmind commented 1 June 2007 at 16:13

Maybe I should have started with a better explination of how the server is set up.

First off the primary domain is votersmind.com and the two new alternate domains which are contained in the html directory of the primary domain are aureliansenate.com and aurelianhouse.com.

votersmind.com was created several years ago with an older 4.something version of drupal. The origional database for this drupal was votersmind_com_-_drupal. This one works fine. Then I added the two new directories for the new domains under var/www/html/. the new directories aureliansenate.com and aurelianhouse.com both have the new drupal 5.x version loaded up in the directory. I started by following the directions in the INSTALL word pad with the new Drupal 5.x for the new site aureliansenate.com and I created a new database for aureliansenate.com which is now votersmind_com_-_drupal2. I went into the sites/default/settings.php file under the var/www/html/aureliansenate.com directory and changed the, password, primary login etc to that of the primary domain information for votersmind.com given that that was the primary domain. The Base url information corresponds with aureliansenate.com and the database was set for votersmind_com_-_drupal2. Turned it on and everything went fine right into setup.

Then I tried to duplicate this process with the new version of Drupal in the other alternate directory var/www/html/aurelianhouse.com/sites/default/settings.php except with this one I put the database as votersmind_com_-_drupal3 instead of 2. When I put drupal3 it gives me all the error messages when I try to set up the site with www.aurelianhouse.com, however when I put the database as drupal2 it just mirrors aureliansenate.com and basically re-routes me to the other alternate address.

How can I resolve this and create two completely independent sites with completely independent drupal systems on the same server without one messing the other up or just mirroring the other. I tried following the directions in the INSTALL.txt for creating drupal for several sites but it is confusing.

any thoughts? im anxious to

votersmind commented 1 June 2007 at 20:21

any thoughts? im anxious to get these sites going. :D

Some multisite tips

styro commented 1 June 2007 at 21:35

I couldn't quite follow exactly what you'd done, but here are some tips that should help take care of things:

1) don't use the default Drupal site directory for anything - its catchall behaviour masks all kinds of misconfiguration issues and wrong assumptions. Put each site in a dedicated site directory.

2) for domain based multisite setups, use separate Apache virtual hosts for each one. They will all have the same document root which is where your Drupal install is. It can also be useful to use a different directory than the default apache one - this way misconfigured virtual hosts won't be masked by falling through to the default apache site.

These two suggestions make any problems much more obvious and easier to pinpoint.

Note: if you are stuck doing this through a hosting control panel, I'm not sure what limitations you'll hit or whether or not you can do it at all.

Hope that helps a bit.

--
Anton
New to Drupal? | Troubleshooting FAQ
Example knowledge base built with Drupal

Having the same problems...

AvantSavant commented 13 June 2007 at 17:34

I created a new folder in /var/www (Fedora 6) and added an alias in httpd.conf to point to the new /var/www/drupal2 directory. I unzipped Drupal 5.1 in the new directory, created a new database in MySql 5, created a new user for that database with all of the necessary permissions, but I am getting all sorts of php errors telling me that I have undefined variables. The first installation of Drupal 5.1 worked just fine, but the second one is problematic. I have done both installations the same, but the second one wont' work.

Same problem

shas3n commented 15 June 2007 at 10:27

I also have the same problem. http://drupal.org/node/152017
Similar set up, same error.
Just subscribing here

-Shastri

Drupal for 2 Domans - 1 works, 1 doesn't

Comments

Check your $db_url

drupal3 is the second

Maybe I should have started

any thoughts? im anxious to

Some multisite tips

Having the same problems...

Same problem

New forum topics

News items

Our community

Documentation

Drupal code base

Governance of community