Trying to install 7.x-dev (as of 30/12/09) on a fresh empty mysql-5.1.41 database on FreeBSD 8-RELEASE with PHP 5.2.12 and Apache 2.2.14.

I encounter this error:

PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'sitename.cache_bootstrap' doesn't exist' in /usr/local/www/apache22/data/sitename/includes/database/database.inc:1956\nStack trace:\n#0 /usr/local/www/apache22/data/sitename.com/includes/database/database.inc(1956): PDOStatement->execute(Array)\n#1 /usr/local/www/apache22/data/sitename.com/includes/database/database.inc(575): DatabaseStatementBase->execute(Array, Array)\n#2 /usr/local/www/apache22/data/sitename.com/includes/database/database.inc(2042): DatabaseConnection->query('SELECT data, cr...', Array, Array)\n#3 /usr/local/www/apache22/data/sitename.com/includes/cache.inc(314): db_query('SELECT data, cr...', Array)\n#4 /usr/local/www/apache22/data/sitename.com/includes/cache.inc(50): DrupalDatabaseCache->get('variables')\n#5 /usr/local/www/apache22/data/sitename.com/includes/bootstrap.inc(718): cache_get('variables', 'cache_bootstrap')\n#6 /usr/local/www/apache22/data/sitename.com/includes/bootstrap.inc(1647): v in /usr/local/www/apache22/data/sitename.com/includes/database/database.inc on line 1956

Comments

David_Rothstein’s picture

Status: Active » Postponed (maintainer needs more info)

At what stage of the installation does this occur?

Adam Ma'anit’s picture

When I initially try to browse to the site to continue the installation.

David_Rothstein’s picture

I'm not sure what you mean by "continue the installation"? Meaning you've finished the installation completely and click on the link at the end for going to your site, or that you interrupt the installation to browse to the site in the middle?

I can reproduce similar kinds of database errors only when interrupting the installation (however, I am not running on the same setup as you are).

Adam Ma'anit’s picture

The steps of the install that require you to point your browser to the site.

ie. download drupal, setup permissions, create the database, etc. then you need to 'run the install script' by visiting the site with a web browser in order to 'continue the installation'.

HTH.

sanbeaman’s picture

I was getting the same error.

i was able to continue to install by doing the following.

giving web server write privileges (per install directions)

chmod o+w sites/default/settings.php

chmod o+w sites/default

then I had to put in the full URL including the install.php
for some reason, in all my past installations I could just go to the install folder and it would know to run install script.

hope this helps

drew

David_Rothstein’s picture

Status: Postponed (maintainer needs more info) » Active

Hm, it seems I can also get that kind of error when I try to start a fresh installation, but with my database connection info already in settings.php (for example, if I use a settings.php file from a previous installation, rather than a fresh one copied from default.settings.php).

In that case, I get the initially-reported cache_bootstrap error on visiting the site itself (e.g., www.example.com), and also need to visit the full install URL manually (e.g., www.example.com/install.php) in order to be able to proceed.

A similar bug exists in Drupal 6, I think, so not sure if this is a duplicate of an existing bug. Also not sure if anyone else can reproduce it with a different set of steps - but for me, that's the only way I can do it.

wiifm’s picture

Can confirm that on visiting the [document root] folder to start the installation, I encountered the following error:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'drupal-dev.cache_bootstrap' doesn't exist' in C:\xampp\htdocs-dev\includes\database\database.inc:1940
Stack trace:
#0 C:\xampp\htdocs-dev\includes\database\database.inc(1940): PDOStatement->execute(Array)
#1 C:\xampp\htdocs-dev\includes\database\database.inc(586): DatabaseStatementBase->execute(Array, Array)
#2 C:\xampp\htdocs-dev\includes\database\database.inc(2111): DatabaseConnection->query('SELECT data, cr...', Array, Array)
#3 C:\xampp\htdocs-dev\includes\cache.inc(314): db_query('SELECT data, cr...', Array)
#4 C:\xampp\htdocs-dev\includes\cache.inc(50): DrupalDatabaseCache->get('variables')
#5 C:\xampp\htdocs-dev\includes\bootstrap.inc(719): cache_get('variables', 'cache_bootstrap')
#6 C:\xampp\htdocs-dev\includes\bootstrap.inc(1650): variable_initialize()
#7 C:\xampp\htdocs-dev\includes\bootstrap.inc(1534): _drupal_bootstrap_variables()
#8 C:\xampp\htdocs-dev\includes\bootstrap.inc(1588): drupal_b in C:\xampp\htdocs-dev\includes\database\database.inc on line 1940

And when I visited [document root]/install.php (by manually typing this in), I then got the actual install screen.

This was not an issue in D6 (at least on my machine)

jacobbj’s picture

Version: 7.x-dev » 7.0-alpha1
Category: bug » support
Priority: Normal » Critical

I am getting the similar error while trying to install drupal 7
It says:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'drupal7.variable' doesn't exist' in C:\wamp\www\drupal7\includes\database\database.inc:1940 Stack trace: #0 C:\wamp\www\drupal7\includes\database\database.inc(1940): PDOStatement->execute(Array) #1 C:\wamp\www\drupal7\includes\database\database.inc(586): DatabaseStatementBase->execute(Array, Array) #2 C:\wamp\www\drupal7\includes\database\database.inc(2111): DatabaseConnection->query('SELECT value FR...', Array, Array) #3 C:\wamp\www\drupal7\install.php(771): db_query('SELECT value FR...', Array) #4 C:\wamp\www\drupal7\install.php(288): install_verify_completed_task() #5 C:\wamp\www\drupal7\install.php(84): install_begin_request(Array) #6 C:\wamp\www\drupal7\install.php(1758): install_drupal() #7 {main} thrown in C:\wamp\www\drupal7\includes\database\database.inc on line 1940

I am running a WAMP server with PHP 5.2.3 and Apache 2.2.11

jacobbj’s picture

sorry guys, i found out lately that drupal 7 is supported only in PHP 5.3.x
Drupal Rocks!!!

wiifm’s picture

Not according to the requirements page. It states PHP 5.2 or higher for Drupal 7

basvredeling’s picture

What's the status of this issue. Is php 5.2 supported or not? I'm receiving the error too. I'm trying to install on XAMPP / Mac OSX / php 5.2.9. Proper file permissions make no difference at all. I've tried a full clean reinstall on alpha1 and dev (checked out from CVS 6 feb 2010). All to no avail.

amcc’s picture

After entering database details on the "Database configuration" page, then clicking "Save and Continue", i'm getting a white screen and the database isn't getting installed.

details below:
php: PHP Version 5.2.3
mysql: 5.0.41

This is the page its getting a whitescreen on:
http://localhost/d7/install.php?q=install.php&profile=standard&locale=en

Heres whats in the error log:
[09-Feb-2010 18:19:07] PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'd7.variable' doesn't exist' in /Users/alistairmcclymont/Sites/d7/includes/database/database.inc:1940
Stack trace:
#0 /Users/alistairmcclymont/Sites/d7/includes/database/database.inc(1940): PDOStatement->execute(Array)
#1 /Users/alistairmcclymont/Sites/d7/includes/database/database.inc(586): DatabaseStatementBase->execute(Array, Array)
#2 /Users/alistairmcclymont/Sites/d7/includes/database/database.inc(2111): DatabaseConnection->query('SELECT value FR...', Array, Array)
#3 /Users/alistairmcclymont/Sites/d7/install.php(772): db_query('SELECT value FR...', Array)
#4 /Users/alistairmcclymont/Sites/d7/install.php(289): install_verify_completed_task()
#5 /Users/alistairmcclymont/Sites/d7/install.php(84): install_begin_request(Array)
#6 /Users/alistairmcclymont/Sites/d7/install.php(1759): install_drupal()
#7 {main}
thrown in /Users/alistairmcclymont/Sites/d7/includes/database/database.inc on line 1940

laken’s picture

Same error here:

[10-Feb-2010 15:47:52] PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'd7_test.cache_bootstrap' doesn't exist' in /Users/Andy/workspace/drupal/d7/includes/database/database.inc:1940
Stack trace:
#0 /Users/Andy/workspace/drupal/d7/includes/database/database.inc(1940): PDOStatement->execute(Array)
#1 /Users/Andy/workspace/drupal/d7/includes/database/database.inc(586): DatabaseStatementBase->execute(Array, Array)
#2 /Users/Andy/workspace/drupal/d7/includes/database/database.inc(2111): DatabaseConnection->query('SELECT data, cr...', Array, Array)
#3 /Users/Andy/workspace/drupal/d7/includes/cache.inc(314): db_query('SELECT data, cr...', Array)
#4 /Users/Andy/workspace/drupal/d7/includes/cache.inc(50): DrupalDatabaseCache->get('variables')
#5 /Users/Andy/workspace/drupal/d7/includes/bootstrap.inc(719): cache_get('variables', 'cache_bootstrap')
#6 /Users/Andy/workspace/drupal/d7/includes/bootstrap.inc(1650): variable_initialize(Array)
#7 /Users/Andy/workspace/drupal/d7/includes/bo in /Users/Andy/workspace/drupal/d7/includes/database/database.inc on line 1940

BTW, Drupal 7 requires PHP 5.2 or higher: http://drupal.org/requirements

laken’s picture

For me, this turned out to be an incompatibility with Drupal 7 and the eAccelerator opcode cache that comes with MAMP, my local LAMP stack. I changed the opcode cache from eAccelerator to APC and Drupal installed fine. More info here: http://drupal.org/node/615836

amcc’s picture

This solve the problem for me, I changed the cache on MAMP to XCache and it works fine now - i suspect turning it off would work too.

basvredeling’s picture

Switching from xampp for mac to mamp fixed the problem for me.

marcvangend’s picture

Status: Active » Fixed

Sounds like this one is fixed.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

David_Rothstein’s picture

Note: Continuing discussion of eAccellerator issues at #914742: Add hook_requirements() for buggy versions of eAccelerator.

It is likely this is not something Drupal can work around, but we should take the time to determine that definitively as it seems to be a popular configuration, and a nasty bug.