My environment: Windows XP Pro, Apache 2.2.3, MySQL 5.0.27, PHP 5.2.0 (installed via Windows Installer).

PHP error_reporting setting "error_reporting = E_ALL"

Upon successful installation of Drupal 5.0-beta1, I get this error:

user warning: Table 'drupal.blocks' doesn't exist query: SELECT DISTINCT b.* FROM blocks b LEFT JOIN blocks_roles r ON b.module = r.module AND b.delta = r.delta WHERE b.theme = 'garland' AND b.status = 1 AND (r.rid IN (1) OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module in C:\_www\local-drupal\includes\database.mysql.inc on line 167.

I checked my database and there is no 'blocks' table. Why should this return a warning? Either the code should know that the block table has not yet been created, or the blocks table should be created so the query does not return an error.

Also (probably unrelated), but after trying to create the first account, I get Access Denied page, however a record in the USER table is added with my information. The password reset for does work and send me a time sensitive link to change password.

This bug makes logging into Drupal impossible (so it seems).

Comments

dopry’s picture

unable to reproduce on linux / apache2 / mysql 5.

chx’s picture

Status: Active » Closed (won't fix)

can't repro either.

robdinardo’s picture

Someone else having same problem, looks like a Windows only problem. See http://drupal.org/node/97510

robdinardo’s picture

This error must be related to MySQL 5 because I removed MySQL 5, dropped the DB, installed MySQL 4.1.22 then did a fresh install of Drupal 5 and no error messages. Everything seems to work fine with MySQL 4.1.22

heine’s picture

Status: Closed (won't fix) » Closed (duplicate)