Submitted by sam on Fri, 09/08/2006 - 13:27.

We've been getting quite a few ugly errors on the site lately, and I've been puzzled as to what the problem is.

The problems have been manifesting themselves as errors at the top of each rendered page. The errors look something like the following:

Warning: Cannot modify header information - headers already sent by (output started at /path/to/drupal/includes/database.mysql.inc:120) in /path/to/drupal/includes/bootstrap.inc on line 554

repeating. Admins can check a recent sample from the error log here.

Well, I found this thread that talks about the problem and suggests it's actually a PHP one due to extra CRs at the end of the files in question. I looked, and indeed one of those files (database.mysql.inc) did have extra CRs at the end of the files.

The problem is, I've also noticed that taking down the database and forcing a check/repair on the tables makes the problem go away for a while. Thus, I think the problem isn't a PHP one alone.

I'll keep watching it and see what can be done.

On what is probably an unrelated note, I really do wish that long ago I would have gone with PostgreSQL over MySQL here at ClanAM. A lot of the stability problems I've been having with MySQL as we've grown probably wouldn't have been an issue with the more featureful PostgreSQL.