Announcement

Collapse
No announcement yet.

Database Error

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

  • Database Error

    http://www.thebookjoint.com/forums/forum.php

    Database error in vBulletin 4.2.5:

    Invalid SQL:

    INSERT IGNORE INTO session
    (sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate, apiclientid, apiaccesstoken)
    VALUES
    ('d1b92550774f93bfc546452b31d91ede', 0, '81.156.168.237', '0a54e7abf3161a13af19c145b977c407', 1582449524, '/forums/forum.php', 0, 0, 0, 0, 0, 0, 0, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 0, 0, 0, '');

    MySQL Error : The table 'session' is full
    Error Number : 1114
    Request Date : Sunday, February 23rd 2020 @ 09:18:44 AM
    Error Date : Sunday, February 23rd 2020 @ 09:18:44 AM
    Script : http://www.thebookjoint.com/forums/forum.php
    Referrer : http://thebookjoint.com/
    IP Address : 81.156.168.237
    Username : Unregistered
    Classname : vB_Database_MySQLi
    MySQL Version :
    Server : 37.122.209.139
    User Agent :


    Stack Trace:

    #0 vB_Database->halt() called in [path]/includes/class_core.php on line 1395
    #1 vB_Database_MySQLi->execute_query() called in [path]/includes/class_core.php on line 446
    #2 vB_Database->query_write() called in [path]/includes/class_core.php on line 3800
    #3 vB_Session->save() called in [path]/includes/functions.php on line 7571
    #4 exec_shut_down() called in [path]/includes/functions.php on line 7307
    #5 print_output() called in [path]/forum.php on line 821


    Thanks
    Alan..
    http://scottishminis.com/forums/forum.php - for all things relating to the Scottish Mini scene
    http://theifonly.com/forums/forum.php - for all things relating to golf
    http://thebookjoint.com/forums/forum.php - for all things relating to books especially Jack Reacher

  • #2
    Run this query:
    Code:
    TRUNCATE TABLE session
    WARNING: Do not run "TRUNCATE" queries on ANY other table unless instructed to by vBulletin Support.
    You will permanently break your break your site.
    MARK.B | vBULLETIN SUPPORT

    TalkNewsUK - My vBulletin 5.6.0 Demo
    AdminAmmo - My Cloud Demo

    Comment


    • #3
      Originally posted by Mark.B View Post
      Run this query:
      Code:
      TRUNCATE TABLE session
      WARNING: Do not run "TRUNCATE" queries on ANY other table unless instructed to by vBulletin Support.
      You will permanently break your break your site.
      Thanks for the help, sadly, i cannot access the admin panel, i get the following error:-

      The page you are trying to view cannot be shown because it uses an invalid or unsupported form of compression
      http://scottishminis.com/forums/forum.php - for all things relating to the Scottish Mini scene
      http://theifonly.com/forums/forum.php - for all things relating to golf
      http://thebookjoint.com/forums/forum.php - for all things relating to books especially Jack Reacher

      Comment


      • #4
        Originally posted by Mark.B View Post
        Run this query:
        Code:
        TRUNCATE TABLE session
        WARNING: Do not run "TRUNCATE" queries on ANY other table unless instructed to by vBulletin Support.
        You will permanently break your break your site.
        Doh, i ran the query from my phpmyadmin, all working, great help, many thanks
        http://scottishminis.com/forums/forum.php - for all things relating to the Scottish Mini scene
        http://theifonly.com/forums/forum.php - for all things relating to golf
        http://thebookjoint.com/forums/forum.php - for all things relating to books especially Jack Reacher

        Comment


        • #5
          Originally posted by The_Gismo_Man View Post

          Doh, i ran the query from my phpmyadmin, all working, great help, many thanks
          What you may need to look into is why is filled up, as it could fill up again. A scheduled task is supposed to empty it but this depends on people visiting the site as that is how it is triggered.
          MARK.B | vBULLETIN SUPPORT

          TalkNewsUK - My vBulletin 5.6.0 Demo
          AdminAmmo - My Cloud Demo

          Comment

          Related Topics

          Collapse

          Working...
          X