Community Documentation

Error on installation step 3: Warning: Table '[database].access' doesn't exist [...]

Last updated December 18, 2007. Created by LeeHunter on February 18, 2007.
Edited by Heine, venkat-rk. Log in to edit this page.

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.

On Step 3 of INSTALL.txt - RUN THE INSTALL SCRIPT you do not arrive at the Database Configuration page, but are greeted with the following warning(s) instead:

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

Followed by one or more warnings concerning headers that have already been sent:

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

This happens if you have already edited the $db_url variable in settings.php. The installer will no longer be automatically invoked, because Drupal assumes installation has already been completed.

To remedy, run the installer manually by visiting http://example.com/install.php.

Comments

Thank you!

Thank you for this! Just stumbled across it and saved me a headache or three.

Sza

Is this the same issue ?

user warning: Table 'malebod1_earthsmate.cache_uc_price' doesn't exist query: SELECT data, created, headers, expire, serialized FROM cache_uc_price WHERE cid = 'bff1b3ab85ee5f902cf4a811ebedd2a4' in /home/malebod1/public_html/earthsmate.com/includes/cache.inc on line 26.

How do I run the installer ???

Thank you

http://www.peacebids.com

Pacify the world through Peace wearable art and drupal :d

oh jeeze!! thx

oh jeeze!! thx

Thank-you!

Saved me a lot of headache. Valid for Drupal 6 too.

Many Thanks!!!

Many Thanks!!!

Fixed multisite problem on Dreamhost

Thanks! I deleted the modified version of settings.php and just used the default settings.php instead, and that worked like a charm!

About this page

Drupal version
Drupal 5.x

Reference

Drupal’s online documentation is © 2000-2012 by the individual contributors and can be used in accordance with the Creative Commons License, Attribution-ShareAlike 2.0. PHP code is distributed under the GNU General Public License.