+ Reply to Thread
Results 1 to 13 of 13

Thread: The table 'session' is full !!!

  1. #1

    Angry The table 'session' is full !!!

    My site again have this error.

    My site seeing a white page and anybody cant join that time. When i use this command it is fixing DELETE FROM session;
    but i dont want again this problem because my site is closing any time
    i read somewhere i looked my Scheduled Tasks , and i saw my first error mail time . and i looked my Scheduled Tasks past.. i saw rss bot add thread that time and i closed my all rss. i be happy for fixed this problem but i see again this error. Today i have error 8:40 and i am looking Scheduled Tasks past but i cant see any action. Anyone can help me

    This is my mail :

    Database error in vBulletin 3.6.8:

    Invalid SQL:

    INSERT IGNORE INTO session
    (sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate)
    VALUES
    ('bd960987e539601e7713fd30251275c9', 0, '195.142.173.2', 'b6aa73a4b89a22a9148d4d355362b67b', 1199774481, '/erkekler-yalan-soylerse-t1711.html?amp;', 0, 0, 0, 37, 1711, 0, 0, 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)', 0, 0);

    MySQL Error : The table 'session' is full
    Error Number : 1114
    Date : Tuesday, January 8th 2008 @ 08:41:21 AM
    Script : http://www.sensizolmuyor.org/erkekle...1711.html?amp;
    Referrer : http://www.google.com.tr/search?hl=t...B6ylerse&meta=
    IP Address : 195.142.173.2
    Username : Kayıtsız Üye
    Classname : vb_database

  2. #2
    Customer Support Manager Steve Machol is a splendid one to behold Steve Machol is a splendid one to behold Steve Machol is a splendid one to behold Steve Machol is a splendid one to behold Steve Machol is a splendid one to behold Steve Machol is a splendid one to behold Steve Machol's Avatar
    Join Date
    Jul 2000
    Location
    Jelsoft InterGalactic HQ
    Posts
    143,007
    Run this query:

    DELETE FROM session;

    Then revert your footer template. You made a change somewhere that stopped the Scheduled Tasks from running and clearing out this table on a regular basis.
    Steve Machol, vBulletin Customer Support Manager
    "Have Copy, Will Paste" (when appropriate)

    Please do not email or PM me for vBulletin support. I will be more than glad to answer your questions on the vB Forums and in the support system.

    Just remember that what happens in localhost, stays in localhost.


  3. #3
    Thanks for the answer.However the error is still occuring. I made all changing as you told me. Can you please advise me What i can do ?

  4. #4
    Customer Support Manager Steve Machol is a splendid one to behold Steve Machol is a splendid one to behold Steve Machol is a splendid one to behold Steve Machol is a splendid one to behold Steve Machol is a splendid one to behold Steve Machol is a splendid one to behold Steve Machol's Avatar
    Join Date
    Jul 2000
    Location
    Jelsoft InterGalactic HQ
    Posts
    143,007
    As I said you made a change somewhere that stopped the Scheduled Tasks from running and clearing out this table on a regular basis. The first thing I recommend is reverting all your custom templates.
    Steve Machol, vBulletin Customer Support Manager
    "Have Copy, Will Paste" (when appropriate)

    Please do not email or PM me for vBulletin support. I will be more than glad to answer your questions on the vB Forums and in the support system.

    Just remember that what happens in localhost, stays in localhost.


  5. #5
    i reverted my all template and still my schedeled tasks not working .i have a SS.
    Please look future works..


  6. #6

  7. #7
    Quote Originally Posted by Kerry-Anne View Post
    have you had any activity on your site?
    Soryy i dont know good english , so i dont understand . can you look my site www.sensizolmuyor.org

  8. #8
    (formerly peterska2) peterska2 will become famous soon enough
    Join Date
    Oct 2003
    Location
    England
    Age
    30
    Posts
    8,869
    revert your footer template then check it again in about an hour and if your scheduled tasks are still not running then submit a support ticket with all your information and a link to this thread.

  9. #9
    My footor is orginal , bec i use now orginal template .
    http://img406.imageshack.us/img406/7558/footorrg9.jpg

    Now i send a ticket ? and send this threads link?

  10. #10
    (formerly peterska2) peterska2 will become famous soon enough
    Join Date
    Oct 2003
    Location
    England
    Age
    30
    Posts
    8,869
    You have some modifications installed which could be breaking the scheduled tasks function.

    Please reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server. Also be sure to upload the admincp files to whichever directory you have set in your config.php file. Then run 'Suspect File Versions' in Diagnostics to make sure you have all the original files for your version:

    Admin CP -> Maintenance -> Diagnostics -> Suspect File Versions

    [Note: In some cases you may also need to remove any of the listed .xml files in the includes/xml directory.]

    Next, disable all plugins.

    Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

    define('DISABLE_HOOKS', true);

    Then if you still have this problem, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you change to the new style and view your forums with it. Now check again.

    Do you still have the same problem?

  11. #11
    ok i will making thats and i have question i import smf to vb 6 monts before . This is make problem?

  12. #12
    (formerly peterska2) peterska2 will become famous soon enough
    Join Date
    Oct 2003
    Location
    England
    Age
    30
    Posts
    8,869
    imports will not cause this problem. If the instructions given above do not resolve the issue, please submit a support ticket if you have not already done so.

  13. #13
    vBulletin Team Lynne has a spectacular aura about Lynne has a spectacular aura about Lynne has a spectacular aura about Lynne's Avatar
    Join Date
    Oct 2004
    Location
    California
    Posts
    8,139
    I don't know if this will help, but I just went to the site and refreshed the page three times and every one of those times there was the cron image put into the footer with a different random number. So it is trying to work.
    Please don't PM me for support - I only help out in the threads.
    vBulletin Manual
    Want help modifying your vbulletin forum? Head on over to vbulletin.org


+ Reply to Thread

Similar Threads

  1. The table 'session' is full
    By hollyboy in forum vBulletin 3.5 'How Do I' Questions and Troubleshooting
    Replies: 1
    Last Post: Wed 26th Sep '07, 7:13pm
  2. table 'session' is full
    By Swakoo in forum vBulletin 3.0 How Do I and Troubleshooting Forum
    Replies: 1
    Last Post: Wed 22nd Nov '06, 6:10am
  3. the table session is full
    By Bashar in forum vBulletin 3.0 How Do I and Troubleshooting Forum
    Replies: 6
    Last Post: Sun 24th Apr '05, 4:54pm
  4. table session full
    By Cynthia in forum vBulletin 3.0 How Do I and Troubleshooting Forum
    Replies: 13
    Last Post: Thu 10th Mar '05, 8:01pm
  5. The table 'session' is full?
    By Buck Satan in forum vBulletin 2 'How Do I' and Troubleshooting
    Replies: 5
    Last Post: Sun 21st Sep '03, 6:55pm

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts