Forum not loading on Chrome, ok for IE and FF

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Gabrielt
    Member
    • Apr 2007
    • 96
    • 3.6.x

    Forum not loading on Chrome, ok for IE and FF

    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!
    Last edited by Gabrielt; Fri 15 Feb '13, 7:48am. Reason: Found another place that the query was required.
  • BirdOPrey5
    Senior Member
    • Jul 2008
    • 9613
    • 5.6.3

    #2
    Thanks for posting.

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...