Content Encoding Error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ukmatt
    New Member
    • Oct 2009
    • 19

    [Forum] Content Encoding Error

    Day 1: my hosting, GoDaddy, moved me into a new server (maybe they activated Gzip, i don't know..)

    Day 2:
    forum unavaiable, browser says:
    Content Encoding Error
    The page you are trying to view cannot be shown because it uses an invalid or unsupported form of compression.


    i tried both:

    Sql queries via phpmyadmin:
    UPDATE setting SET value = '0' WHERE varname = 'gzipoutput';

    UPDATE datastore SET data=REPLACE(data,'s:10:"gzipoutput";i:1;','s:10:"gzipoutput";i:0;') WHERE title='options';

    Config update:
    DEFINE('NOZIP', 1);

    but nothing happens, my forum still unavaiable, saying:
    Unable to add cookies, header already sent.
    File: /home/content/f/o/r/forumbasket/html/index.php
    Line: 1
  • Trevor Hannant
    vBulletin Support
    • Aug 2002
    • 24325
    • 5.7.X

    #2
    Are you able to login to AdminCP? If not, does adding the DEFINE('NOZIP', 1); line to login.php let you in?
    Vote for:

    - Admin Settable Paid Subscription Reminder Timeframe (vB6)
    - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

    Comment

    • ukmatt
      New Member
      • Oct 2009
      • 19

      #3
      Originally posted by Trevor Hannant
      Are you able to login to AdminCP? If not, does adding the DEFINE('NOZIP', 1); line to login.php let you in?
      done, but now when i try to login in admincp as administrator browser says:
      Code:
      Database error in vBulletin 4.0.1:
      
      Invalid SQL:
      
                      INSERT IGNORE INTO session
                          (sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate)
                      VALUES
                          ('52302712702090645ed5be45b3fa580d', 1, '93.42.237.xxx', '7de0fddf7cd69ebf2bc3573a295abde1', 1265116736, '/login.php?do=login&do=login', 0, 0, 1, 0, 0, 0, 0, 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US; rv:1.9.2) Gecko/20100115 Firefox/3.6', 1, 0);
      
      MySQL Error   : The table 'session' is full
      Error Number  : 1114
      Request Date  : Tuesday, February 2nd 2010 @ 06:18:56 AM
      Error Date    : Tuesday, February 2nd 2010 @ 06:18:56 AM
      Script        : http://www.forum.com/login.php?do=login
      Referrer      : http://www.forum.com/admincp/index.php
      IP Address    : 93.42.237.xxx
      Username      : admin
      Classname     : vB_Database
      MySQL Version : 4.1.22-max-log
      can't understand why..

      Comment

      • Trevor Hannant
        vBulletin Support
        • Aug 2002
        • 24325
        • 5.7.X

        #4
        Cron jobs don't seem to be running and clearing out that table. You can empty this with:

        Code:
        truncate session;
        or via phpMyAdmin (or similar).

        Then make sure that $cronimage is in your footer so the scheduled tasks can run ad that the cleanup tasks are enabled in AdminCP
        Vote for:

        - Admin Settable Paid Subscription Reminder Timeframe (vB6)
        - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

        Comment

        • ukmatt
          New Member
          • Oct 2009
          • 19

          #5
          Originally posted by Trevor Hannant
          Cron jobs don't seem to be running and clearing out that table. You can empty this with:

          Code:
          truncate session;
          or via phpMyAdmin (or similar).

          Then make sure that $cronimage is in your footer so the scheduled tasks can run ad that the cleanup tasks are enabled in AdminCP
          i'm sorry but i'm a damned designer.. what i have to do exactly?

          an sql query for truncate session? my forum is completely untouched, i made a new clean installation to be sure, now i want to make my 4.0.1 database backup runs on my new 4.0.1 installation

          i think the it's a database error, because of that, but i don't know nothing about sql, i can only launch queries if i can copy them

          Comment

          • Trevor Hannant
            vBulletin Support
            • Aug 2002
            • 24325
            • 5.7.X

            #6
            AdminCP > Maintenance > Execute SQL Query >

            Make sure that your userid is able to run queries by editing the following section of the config.php file:

            Code:
             // ****** USERS WITH QUERY RUNNING PERMISSIONS ******
             // The users specified here will be allowed to run queries from the control panel.
             // See the above entries for more information on the format.
             // Please note that the ability to run queries is quite powerful. You may wish
             // to remove all user IDs from this list for security reasons.
            $config['SpecialUsers']['canrunqueries'] = 'x';
            where 'x' is your userid.

            In the 'Manual Query' box, type in 'truncate PREFIXsession' (where PREFIX is your table prefix - remove this if you don't have a prefix) then click Continue then Continue again on the next screen. This will empty that table and get rid of that error
            Vote for:

            - Admin Settable Paid Subscription Reminder Timeframe (vB6)
            - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

            Comment

            • Lynne
              Former vBulletin Support
              • Oct 2004
              • 26255

              #7
              Trevor, can't you also just go into Scheduled Tasks and find Hourly Cleanup and hit Run and it should clear the sessions?

              To the OP, are the times in your Scheduled Task Manager all future times? You need to figure out if these are running.

              Please don't PM or VM me for support - I only help out in the threads.
              vBulletin Manual & vBulletin 4.0 Code Documentation (API)
              Want help modifying your vbulletin forum? Head on over to vbulletin.org
              If I post CSS and you don't know where it goes, throw it into the additional.css template.

              W3Schools <- awesome site for html/css help

              Comment

              • ukmatt
                New Member
                • Oct 2009
                • 19

                #8
                I found HOW TO, but i need an sql query:

                i have to change the Cookie Domain - Suggested settings to (blank), now in my database i have (.myforum.com)

                someone can suggest me the sql command for phpmyadmin?

                collateral question:
                how can i import a 4.0.1 database backup INTO a clean new installed 4.0.1 database? impex?

                Comment

                • Lynne
                  Former vBulletin Support
                  • Oct 2004
                  • 26255

                  #9
                  Originally posted by ukmatt
                  someone can suggest me the sql command for phpmyadmin?
                  Trevor already posted the mysql query to truncate the session table, so I'm not sure what you are looking for here.

                  Please don't PM or VM me for support - I only help out in the threads.
                  vBulletin Manual & vBulletin 4.0 Code Documentation (API)
                  Want help modifying your vbulletin forum? Head on over to vbulletin.org
                  If I post CSS and you don't know where it goes, throw it into the additional.css template.

                  W3Schools <- awesome site for html/css help

                  Comment

                  • ukmatt
                    New Member
                    • Oct 2009
                    • 19

                    #10
                    It works! perfect, thank you very much to Steve Machol and Trevor Hannant, fantastic support, i'm happy to be migrated from phpbb3 to vbulletin4

                    the solution was:

                    1 step:
                    Sql query via phpmyadmin:

                    UPDATE PREFIXsetting SET value = '0' WHERE varname = 'gzipoutput';

                    UPDATE PREFIXdatastore SET data=REPLACE(data,'s:10:"gzipoutput";i:1;','s:10:"gzipoutput";i:0;') WHERE title='options';

                    2 step:
                    Sql query via phpmyadmin:

                    truncate PREFIXsession'

                    Comment

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