I ran into a similar problem as this: http://drupal.org/node/30920, but consistently. When I looked at the {cache} table, data for all the cached URLs had length(data) = 1.

It has to do with some combination of my database settings and the fact that the data field is a longtext (so the binary (gzipped) data from the cached pages gets incorrectly interpreted as text, and probably truncated at the first \0 character)

I don't know if just altering the type of the column will break things, since I guess other users of the cache might be relyiing on the fact that data is TEXT and not BLOB

Comments

codepoet’s picture

I've run into the exact same problem, and the solution was also exactly the same. I altered the table to LONGBLOB and everything is running fine now.

By the way, as far as I can tell, this is required for support with MySQL 5.0+. I ran in 4.1 with LONGTEXT and life was good, but once I moved to 5.0 I got the white page on every cached page load until I made this change.

Wesley Tanaka’s picture

Status: Active » Closed (duplicate)