By gonefishing on

I just tried to do new install of 5.1, created database and:

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE
  TEMPORARY TABLES, LOCK TABLES
  ON db.*
  TO 'db'@'localhost' IDENTIFIED BY 'password';

Chmod settings to 777

Entered the db name and password on the setup page used "enter" on the keyboard and the screen went blank. I changed the password in the settings.php to something I knew was wrong, to see if Drupal was reading the settings file and then I got, "Unable to connect to database server". Changed password back to the correct one and now the screen is blanks again.

memory_limit 24M 24M

I edited the httpd.conf to setup a error log for this install, restart apache and hit refreshed the browser.

Error log:

[Mon Mar 26 00:57:19 2007] [error] PHP Warning:  Table 'robot.access' doesn't exist\nquery: SELECT CASE WHEN status=1 THEN 0 ELSE 1 END FROM access WHERE type = 'host' AND LOWER('65.95.146.27') LIKE LOWER(mask) ORDER BY status DESC LIMIT 0, 1 in /home/web/robots/includes/database.mysql.inc on line 172
[Mon Mar 26 00:57:19 2007] [error] PHP Warning:  Table 'robot.users' doesn't exist\nquery: SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid = '2cb756c7e0a279dd007bfba96f44a9e3' in /home/web/robots/includes/database.mysql.inc on line 172
[Mon Mar 26 00:57:19 2007] [error] PHP Warning:  Table 'robot.cache' doesn't exist\nquery: SELECT data, created, headers, expire FROM cache WHERE cid = 'variables' in /home/web/robots/includes/database.mysql.inc on line 172
[Mon Mar 26 00:57:19 2007] [error] PHP Warning:  Table 'robot.variable' doesn't exist\nquery: SELECT * FROM variable in /home/web/robots/includes/database.mysql.inc on line 172
[Mon Mar 26 00:57:19 2007] [error] PHP Warning:  Table 'robot.cache' doesn't exist\nquery: LOCK TABLES cache WRITE in /home/web/robots/includes/database.mysql.inc on line 172
[Mon Mar 26 00:57:19 2007] [error] PHP Warning:  Table 'robot.cache' doesn't exist\nquery: UPDATE cache SET data = 'N;', created = 1174870639, expire = 0, headers = '' WHERE cid = 'variables' in /home/web/robots/includes/database.mysql.inc on line 172
[Mon Mar 26 00:57:19 2007] [error] PHP Warning:  Table 'robot.cache_page' doesn't exist\nquery: SELECT data, created, headers, expire FROM cache_page WHERE cid = 'http://robots.mysite.com/' in /home/web/robots/includes/database.mysql.inc on line 172
[Mon Mar 26 00:57:19 2007] [error] PHP Warning:  Table 'robot.url_alias' doesn't exist\nquery: SELECT COUNT(pid) FROM url_alias in /home/web/robots/includes/database.mysql.inc on line 172
[Mon Mar 26 00:57:19 2007] [error] PHP Parse error:  parse error, unexpected $ in /home/web/robots/includes/form.inc on line 1
[Mon Mar 26 00:57:19 2007] [error] PHP Warning:  Table 'robot.sessions' doesn't exist\nquery: SELECT sid FROM sessions WHERE sid = '2cb756c7e0a279dd007bfba96f44a9e3' in /home/web/robots/includes/database.mysql.inc on line 172
[Mon Mar 26 00:57:19 2007] [error] PHP Warning:  Table 'robot.sessions' doesn't exist\nquery: INSERT INTO sessions (sid, uid, cache, hostname, session, timestamp) VALUES ('2cb756c7e0a279dd007bfba96f44a9e3', 0, 0, '65.95.146.27', '', 1174870639) in /home/web/robots/includes/database.mysql.inc on line 172
⋅ Categories: Drupal 5.x

Comments

gonefishing’s picture

gonefishing commented

I've cleaned all 3 browsers, IE, Firefox and Opera and tried a proxy server. The screen is still blank.

View Source of Blank Screen:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=utf-8"></HEAD>
<BODY></BODY></HTML>
gonefishing’s picture

gonefishing commented

This is a known issue, http://drupal.org/node/116431

I did the following:
- completely removed all 5.1 files and the directory
- uploaded the tarball, drupal-5.1.tar.gz (don't unzip the tarball and then upload it, I tried ..... didn't work)
- tar -zxvf drupal-5.1.tar.gz
- cd to drupal-5.1 and run "find . -type d -exec chmod 755 {} \;" (note, this worked on freebsd, thanks batigolix)
- rename "drupal-5.1" to whatever you need it to be

So far everything work fine. Hope this helps someone else ..........