Hi,
Today we had a very strange issue. Our forums were loading correcting on IE and FF, but not on Chrome, after we upgraded MySQL from 5.5.30 to 5.6.10.
Users on Chrome could either see an "Error 330 (net::ERR_CONTENT_DECODING_FAILED): Unknown error," if zlib.output_compression was set of "Off" on php.ini or a generic "Database Error" if zlib.output_compression was set to "On."
After further investigation, the culprit came to be the useragent field of the sessions table, which was limited to 100 characters, and Chrome generates a user-agent string with 108 characters. To solve this, I had to simply run the following queries inside MySQL:
ALTER TABLE session MODIFY useragent char(255) NOT NULL default '';
ALTER TABLE postlog MODIFY useragent char(255) NOT NULL default '';
I hope this tip helps other users with the same problem.
Thanks!
Today we had a very strange issue. Our forums were loading correcting on IE and FF, but not on Chrome, after we upgraded MySQL from 5.5.30 to 5.6.10.
Users on Chrome could either see an "Error 330 (net::ERR_CONTENT_DECODING_FAILED): Unknown error," if zlib.output_compression was set of "Off" on php.ini or a generic "Database Error" if zlib.output_compression was set to "On."
After further investigation, the culprit came to be the useragent field of the sessions table, which was limited to 100 characters, and Chrome generates a user-agent string with 108 characters. To solve this, I had to simply run the following queries inside MySQL:
ALTER TABLE session MODIFY useragent char(255) NOT NULL default '';
ALTER TABLE postlog MODIFY useragent char(255) NOT NULL default '';
I hope this tip helps other users with the same problem.
Thanks!
Comment