Closed (duplicate)
Project:
Drupal core
Version:
x.y.z
Component:
database system
Priority:
Critical
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
25 Nov 2005 at 07:41 UTC
Updated:
9 Dec 2005 at 13:58 UTC
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
Comment #1
codepoet commentedI'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.
Comment #2
Wesley Tanaka commented