By bobdavis on

If you can get my white screen of death fixed in the next hour, I will paypal you the $20.

I have already:

-deleted all records in accesslog, cache, and sessions tables
-increased memory limit in settings.php to 32M
-not made any configuration changes besides adding nodes recently
-had it working for months until i logged out to log in as a user complaining of white screen
-changed cache to s:0:"0"; in variable table

⋅ Categories: Drupal 4.7.x

Comments

khoogheem’s picture

khoogheem commented

have you tried to just empty the cache table in the database?

or have you made any code changes? Custom php in a node?

bobdavis’s picture

bobdavis commented

Yes, the cache table is totally empty.

I have not made any code changes. Not one iota. Lots of text changes but no code - not in nodes or modules or themes.

pwolanin’s picture

pwolanin commented

Per this comment: http://drupal.org/node/55050#comment-104873

others with this problem has to run a repair on their whole database. I've seen other posts recently, such as http://drupal.org/node/72292#comment-134693, where apparently just a single table crashed.

---
Work: BioRAFT

bobdavis’s picture

bobdavis commented

I have repaired all tables, no change.

spyderpie’s picture

spyderpie commented

I have caused a white screen on my site MANY times. My most common causes are:

1) extra carraige returns after the ?> tag at the end of the file.
2) Missing ; at the end of a line
3) Poorly formed if statement (can't ever seem to get these right the first time!)
4) Missing {}(), etc.

Any of the above can be caused by a new module (maybe with a mistake in it) or by any php snippet in any block or page on your site .... I've done this.

also, have you even backed your database up and restored it, a possible missing 'autoincrement' on a field in a particular table?

And on a whim, I'm sure you already cleared your browsers cache and maybe tried another browser?

Can you provide more info? (I don't want your $20 :) )

~spyderpie

bobdavis’s picture

bobdavis commented

I am sure there was no coding. It's a simple text site.

I have tried another browser and clearing it's cache.

I'm curious about the autoincrement comment. I had a problem with autoincrements in users and nodes table. Last night I added new users. But not before having to error through to get it to increment up to 40 again. Please elaborate on this point.

bobdavis’s picture

bobdavis commented

I checked both the nodes and users table and they are appropriately both primpary keys and autoincrement. But could there be something in the variable table?

Heine’s picture

Heine commented

The increments for sessions, users, nodes, comment etc are kept in the table sequences.

1 - Where on the site does this happen? Everywhere?
2 - Take a look at Apache's error.log (filename may be different depending on configuration)

WSODs are usually fatal php errors or Apache segfaulting.
--
The Manual | Troubleshooting FAQ | Tips for posting | Make Backups! | Consider creating a Test site.

bobdavis’s picture

bobdavis commented

The sequences table has the corret values for the next user and the next node.

Yes. This happens everywhere.

I'm trying to figure out where the error log is kept on the server.

bobdavis’s picture

bobdavis commented

Since I couldn't find the log files right away I went and did "php index.php"

It printed the HTML for the page. At the top were these error messages:

PHP Notice: Undefined index: HTTP_HOST in []/resume/includes/bootstrap.inc on line 53
PHP Notice: Undefined index: REMOTE_ADDR in []/resume/includes/session.inc on line 28
PHP Notice: Undefined property: uid in []/resume/includes/session.inc on line 36

I ran the same thing on sites that are working and they get different error messages and do *not* print the HTML for the first page.

reggie75’s picture

reggie75 commented

in settings.php we added a function , and had added the "close php tags" too (?>) at the end of it.
that caused the white screen.

we removed those tags and were fine.

bobdavis’s picture

bobdavis commented

That's not it. There were no code changes. After it happened I added a memory limit increase to settings.php (it was already at 32M in php.ini). Based on what you said I just commented the new line out of settings.php and still no change.

kbahey’s picture

kbahey commented

Hi

Memory could be the cause for this, but 32M is plenty (I use 16M and it is enough).

Try to disable all contrib modules, then enable them one by one until you see which one causes that.

Check the apache log. It could be that PHP crashed for some reason.
--
Drupal development and customization: 2bits.com
Personal: Baheyeldin.com

--
Drupal performance tuning and optimization, hosting, development, and consulting: 2bits.com, Inc. and Twitter at: @2bits
Personal blog: Ba

bobdavis’s picture

bobdavis commented

If php had crashed would other sites on the same server still be responding?

kbahey’s picture

kbahey commented

Depends on how many copies of Apache you are running, but it is possible that one process would crash, and the rest are unaffected.
--
Drupal development and customization: 2bits.com
Personal: Baheyeldin.com

--
Drupal performance tuning and optimization, hosting, development, and consulting: 2bits.com, Inc. and Twitter at: @2bits
Personal blog: Ba

PRZ’s picture

PRZ commented

Bob,

I am having similar problems... have tried all that has been suggested here.

My biggest error comes when trying to load my admin/modules page in my browser. I have a muli-site installation and my problems seemed to start when I tried to install the ecommerce modules, which I never got to activate. No ecommerce tables were built. Before this I was running 6 sites off a single Drupal installation (for months) without this error ever happening.

Interestingly, I am getting the same error on another site with a fresh database installation. There is no content on this site and I still get the white screen error (on Firefox) or the message ' “lost network connection” (NSURLErrorDomain:-1005)' when I try to access the modules page in Safari.

I do get this error on other pages, but it is most consistent with the modules page. On other pages that generate the error, I can just reload the page in my browser a couple of times and it eventually loads.

This error is affecting all of the sites I have under this single Drupal 4.7.2 installation. I even reloaded Drupal with no help.

I have also deleted all modules other than the core 4.7.2 ones, so there are currently NO non-drupal core modules loaded and I still get the error.

(BTW, my PHP memory is set to 32MB)

Have you solved your problem yet?

Paul.

bobdavis’s picture

bobdavis commented

I don't think we are having the same problem. I can not get any page.

The only modules I added were quotes and feedback. And while I have had memory issues before this, my other sites on the same server work.

paddy_deburca’s picture

paddy_deburca commented

Add into your settings.php file

ini_set('memory_limit', '20M');

And see if that does the trick..

Paddy.

http://deburca.org, and http://amadain.net

Paddy.

http://deburca.org

bobdavis’s picture

bobdavis commented

The php.ini limit is 32M. I additionally set it in settings.php to no effect.

PRZ’s picture

PRZ commented

I am at 32M now... I'm pretty sure that is more than enough.

PRZ’s picture

PRZ commented

OK, my problems were fixed, but not until I increased memory to 128MB!

Perhaps my multi-site installation requires more than the normal resources. Also, I found in testing the ecommerce modules, I needed a great deal of memory (along with CCK and views).

kbahey’s picture

kbahey commented

If this is only for the modules page, then try deleting some modules that you are not using (no, disabling them is not enough, since ALL modules are loaded when you access the page, not just the enabled ones).

Multisite has nothing to do with it, since you are only loading one site per page, not all of them.

I have 4.7 ecommerce on multisite, as well as several other modules, and 16MB is enough.

My guess is that there are one or two modules that are memory hungry.
--
Drupal development and customization: 2bits.com
Personal: Baheyeldin.com

--
Drupal performance tuning and optimization, hosting, development, and consulting: 2bits.com, Inc. and Twitter at: @2bits
Personal blog: Ba

dman’s picture

dman commented

You really need to find your logs - that'll tell you immediately.

Running php from command-line doesn't have the same environment variables - thats why you get unhelpful errors.

As the whitescreen isn't memory, it may be bad .htaccess . Rename it away for a bit and see. Server may have changed the policy and caused the rules to change ("directive not allowed here")

Try a phpinfo page

Never have a theme the same name as a module. Apache just dies.

.dan.

How to troubleshoot Drupal
http://www.coders.co.nz/

.dan. is the New Zealand Drupal Developer working on Government Web Standards

bobdavis’s picture

bobdavis commented

I deleted .htaccess to no effect.

I have an email into my sysadmin for system log information, but I don't know when he'll get back to me.

I tried doing a phpinfo page and it is also a white screen. The odd thing is that my other Drupal sites on the same server still work.

bobdavis’s picture

bobdavis commented

The error logs show a duplicate entry error in the sessions table. I did go back and redump the sessions table - it will show the front page but when i hit submit on logging in it goes back to white screen Restarted the server to no effect.

kbahey’s picture

kbahey commented

The duplicate thing may be due to the fact that you have no user 0 in the users table.

Try checking the users table first.

SELECT * FROM users WHERE uid = 0;

If it is not there, then do this in phpMyAdmin:

INSERT INTO users (uid, name, mail) VALUES ('0', '', '');
INSERT INTO users_roles (uid, rid) VALUES (0, 1);

I don't think that this can cause blank pages though.
--
Drupal development and customization: 2bits.com
Personal: Baheyeldin.com

--
Drupal performance tuning and optimization, hosting, development, and consulting: 2bits.com, Inc. and Twitter at: @2bits
Personal blog: Ba

bobdavis’s picture

bobdavis commented

OMG you did it!

There was no uid=0 in the users table.

Those queries didn't work, it added uid=42, but I manually editted to 0 and it worked.

If you would like the money please let me know what address to paypal it too!

Thank you so much!

kbahey’s picture

kbahey commented

Go ahead and donate the $20 to Drupal via this page:

http://drupal.org/node/2227
--
Drupal development and customization: 2bits.com
Personal: Baheyeldin.com

--
Drupal performance tuning and optimization, hosting, development, and consulting: 2bits.com, Inc. and Twitter at: @2bits
Personal blog: Ba