By dleeward on

I'm trying to install 5.0RC1 on a shared host. I have full access to the database but get a bunch of error messages. Here's the first four...

Warning: Table 'drupal.access' doesn't exist query: SELECT CASE WHEN status=1 THEN 0 ELSE 1 END FROM access WHERE type = 'host' AND LOWER('xx.xxx.xx.xxx') LIKE LOWER(mask) ORDER BY status DESC LIMIT 0, 1 in /usr/home/leeward/www/htdocs/drupal-5.0-rc1/includes/database.mysql.inc on line 167

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /usr/home/leeward/www/htdocs/drupal-5.0-rc1/includes/database.mysql.inc:167) in /usr/home/leeward/www/htdocs/drupal-5.0-rc1/includes/bootstrap.inc on line 812

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /usr/home/leeward/www/htdocs/drupal-5.0-rc1/includes/database.mysql.inc:167) in /usr/home/leeward/www/htdocs/drupal-5.0-rc1/includes/bootstrap.inc on line 812

Warning: Table 'drupal.cache' doesn't exist query: SELECT data, created, headers, expire FROM cache WHERE cid = 'variables' in /usr/home/leeward/www/htdocs/drupal-5.0-rc1/includes/database.mysql.inc on line 167

Many of the rest seem to refer to tables that don't exist. (I inserted x's in place of the IP address in the first message)

Can anyone help?

⋅ Categories: Drupal 5.x

Comments

vm’s picture

vm commented

did you maually check the database ?

are all settings correct ? looks like you are using a table prefix, are the tables in the db there and not prefixed ?

dleeward’s picture

dleeward commented

did you maually check the database ? Yes, it is created with full access.

are all settings correct ? looks like you are using a table prefix, are the tables in the db there and not prefixed ? Don't think I'm using a table prefix since when I add a prefix -- drupal -- to the settings file the first error changes to the following:

Warning: Table 'drupal.drupalaccess' doesn't exist query:

Can you explain prefixes?

cog.rusty’s picture

cog.rusty commented

About prefixes, you add one to your Drupal database tables when you want to use the same database for other applications, so that Drupal's tables won't get mixed with/overwritten by other application's tables.

cog.rusty’s picture

cog.rusty commented

Try with the default settings.php, *without* entering your settings before starting Drupal. You may need to make it writable (666) for a while.

robdinardo’s picture

robdinardo commented

I had a similar problem. Check this link out: http://drupal.org/node/98981

My Problem occurred while using MySQL 5. I switched to MySQL 4.1 and works fine now

See also: http://drupal.org/node/54702

dleeward’s picture

dleeward commented

I reverted back to the unmodified file and got the following error message:

The database type is unsupported. Please use either mysql for MySQL 3.x & 4.0.x databases, mysqli for MySQL 4.1.x+ databases, or pgsql for PostgreSQL databases. The database information is in your settings.php file.

Then allowed settings.php to be writable, entered the database info but then got a whole new set of warnings. When I went to check to see if the database was created, I found that I couldn't connect to MySQL anymore.

TIME TO QUIT!

dleeward’s picture

dleeward commented

- Disabled MySQL then re-enabled it from the control panel.

- Turned on caching.

All the error mesages have now gone away.

Thanks for the help.

eva’s picture

eva commented

even though I had the answer in the above post, it took me awhile to make it work...key is to set permission to 777 for settings.php BEFORE setting up db. the problem was that i had already screwed up and didn't want to have to completely start over.

for the drupally challenged (including myself):
1. I deleted the tables in the my db
2. deleted and uploaded a fresh copy of settings.php
3. changed permissions on settings.php to 777
4. deleted and uploaded fresh copy of install.php
5. went back to domain and it started me over on setting up db installation - (enter db name, username, and password) - went off without a hitch

hope this helps someone else

my sites: http://www.selfesteemcommunication.com
http://michaelwrayforcongress.com

Bleu’s picture

Bleu commented

Using MySQL - 5.0.19;

Warning: Table 'dealerCMS.access' doesn't exist query: SELECT CASE WHEN status=1 THEN 0 ELSE 1 END FROM access WHERE type = 'host' AND LOWER('172.16.20.213') LIKE LOWER(mask) ORDER BY status DESC LIMIT 0, 1 in /home/dealer/public_html/includes/database.mysql.inc on line 172

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/dealer/public_html/includes/database.mysql.inc:172) in /home/dealer/public_html/includes/bootstrap.inc on line 811

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/dealer/public_html/includes/database.mysql.inc:172) in /home/dealer/public_html/includes/bootstrap.inc on line 811

It would appear that Drupal cannot create the needed database tables. The database exists, and the database user has full privileges on that database. I have done everything that this thread suggests and still no luck.

Bleu’s picture

Bleu commented

The instructions say;

3. RUN THE INSTALL SCRIPT

The install script will set the base URL, connect Drupal to the database, and
create tables in the database.

To run the install script point your browser to the base url of your website
(i.e. http://www.example.com). You will be presented with the "Database
Configuration" page.

Since that did not work, I went literal and ran install.php. The tables were all created. Then I went back to the base URL and all was fine.

papapep’s picture

papapep commented

As the last comments says, just adding "install.php" at the end of your url works perfectly.
I was concerned about having to remove Mysql 5 as I have some other aplicattions using it, but just putting the install file in the url solves all the problem.

akita_yra’s picture

akita_yra commented

hei, thanks for your posted advise ! it also worked out fine for me ***

dynv’s picture

dynv commented

Thanks ! I guess behavior on a hosted site is not like the default one on localhost and you need to give it a little help.

Not even 3. RUN THE INSTALL SCRIPT part of INSTALL.txt mention this ...