Announcement

Collapse
No announcement yet.

mysql error: The table 'session' is full

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • #16
    I am now experiencing this problem. My session table is 15.1Mb. I deleted a few of the last entries using phpmyadmin to allow myself to log into the admincp. Is it ok to empty the entire session table?

    Comment


    • #17
      Originally posted by Scott MacVicar
      yeah thats probably 60,000~ rows

      it would only get that big if you removed the $cronimage from the footer.
      2 - with this $cronimage

      1. 2 skin makers at times are forgetting to put them bak into the skins.

      2. at rapmisic.com the board, looking at the source the cron image marker looks like this
      HTML Code:
      <!-- Do not remove <img src="cron.php?&amp;rand=110224" alt="" width="1" height="1" border="0" /> or your scheduled tasks will cease to function -->
      <img src="cron.php?&amp;rand=110224" alt="" width="1" height="1" border="0" />
      <!-- Do not remove <img src="cron.php?&amp;rand=110224" alt="" width="1" height="1" border="0" /> or your scheduled tasks will cease to function -->
      and on my site looking at the source
      HTML Code:
      <!-- Do not remove  or your scheduled tasks will cease to function -->
      
      <!-- Do not remove  or your scheduled tasks will cease to function -->
      to me it looks like its not finding the file it needs to.

      when i installed vBindex they use this in the footer and make sure the referance to the file is correct. . .
      .. . / GFXstyles certain amount of common sense is necessary to survive in this world !
      insanity leaves you no restrictions

      Comment


      • #18
        kennethj vbmenu_register("postmenu_558999", true);
        Member
        We are going to try this and see if it corrects the problem.... I'll let you know within 48 hours


        thanks!

        Comment


        • #19
          the link to cron.php only appears if a cron task is due to be run.
          Scott MacVicar

          My Blog | Twitter

          Comment


          • #20
            I'm getting lads of these errors:
            Database error in vBulletin 3.0.0 Release Candidate 2:
            Invalid SQL:
            INSERT INTO session
            (sessionhash, userid, host, idhash, lastactivity, styleid, loggedin, bypass, useragent)
            VALUES
            ('5b363dec5a6e0e9acadfebeba75ea657', 7172, '62.30.106.185', 'd093fa915fd59a2b82d6e4f43f345541', 1074548288, 0, 1, 0, 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; CDSource=v9e.05)')

            mysql error: The table 'session' is full
            mysql error number: 1114
            and I'm slowly watching my users disappear.

            I've looked through these boards and it seems I need to empty my session table - but I haven't a clue how to do that (PHP isn;t exactly my strong suite!)

            Could anyone offer some really down ot earth instructions please?

            I've got PhpMyAdmin installed, but it's all gibberish to me!

            Comment


            • #21
              Can you login to your server root?

              Get putty
              http://www.chiark.greenend.org.uk/~s.../download.html

              Use this to gain access to the server.

              When you login - type: TOP

              try to copy paste that here if you can.

              then try typing at the prompt: /usr/local/apache/bin/apachectl restart

              then type: /etc/init.d/mysql start

              then type: /etc/init.d/mysql stop

              that should flush out your tables and restart httpd

              Comment


              • #22
                I managed to get it sorted - I used phpmyadmin to empty the session table (and that's some achievement for a non-PHP guy like me!) and I've worked out what the problem is - someone commente out the cron job on the /vbulletin > less global.php file.

                Thanks

                Comment


                • #23
                  great to hear!

                  goodluck-

                  Comment


                  • #24
                    I just started having the same problem a couple weeks ago. I am viewing the source of my forum index page and I don't see this cron image code. Should I be able to find that in the source?



                    Originally posted by kennethj
                    2 - with this $cronimage

                    1. 2 skin makers at times are forgetting to put them bak into the skins.

                    2. at rapmisic.com the board, looking at the source the cron image marker looks like this
                    HTML Code:
                    <!-- Do not remove <img src="cron.php?&amp;rand=110224" alt="" width="1" height="1" border="0" /> or your scheduled tasks will cease to function -->
                    <img src="cron.php?&amp;rand=110224" alt="" width="1" height="1" border="0" />
                    <!-- Do not remove <img src="cron.php?&amp;rand=110224" alt="" width="1" height="1" border="0" /> or your scheduled tasks will cease to function -->
                    and on my site looking at the source
                    HTML Code:
                    <!-- Do not remove or your scheduled tasks will cease to function -->
                     
                    <!-- Do not remove or your scheduled tasks will cease to function -->
                    to me it looks like its not finding the file it needs to.

                    when i installed vBindex they use this in the footer and make sure the referance to the file is correct. . .

                    Comment


                    • #25
                      The $cronimage is in the default footer template.
                      Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                      Change CKEditor Colors to Match Style (for 4.1.4 and above)

                      Steve Machol Photography


                      Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                      Comment


                      • #26
                        for some reason the cronimage is available in the global.php and cleanup.php and cleanup2.php are available in cron dir, and yet this custome ris having the same problem

                        any idea how to resolve it?

                        Comment


                        • #27
                          Bashar, please start a new thread with all the relevant details.

                          Comment

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