I've got Drupal 4.6.3 and Postgres 8.x running under Red Hat Linux. My site was going along fine until the other day it became the "white screen of death". That's literally all you would see -- a blank screen. After some digging around I finally found a suggestion linked to the 0 user, so I made sure there was such a user in my "users" table and that at least brought back the theme. But now every link gives a 404, despite the fact that the content is still there in the database.
So apparently something got corrupted in my database and now I need to figure out what. Can anyone suggest what to look for in my database, or any test SQL queries I can run to figure out what's wrong? I've pored over the various logs and so far nothing has given me the vital clue I need. Thanks in advance for any advice anyone can provide.
Comments
I have two site under drupal
I have two site under drupal 4.7, using postgres. Both of them have the zero user (uid=0). They work fine, and apparently this user has some purpose (both where created from scratch). However the I got some white screen because of too much memory usage in PHP. Increasing the limits they went away. You could drill down on the page rendering and see where the content goes missing, to me this is a PHP issue, not a DB issue. If possible use simple themes too.
Hope this helps. Also consider migrating to 4.7 or 5.1.