Announcement

Collapse
No announcement yet.

Forums database error?

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

  • Forums database error?

    I'm getting the below error when viewing index.php

    <snip>
    There seems to have been a slight problem with the WhichBrowser.co.uk Forums database.
    Please try again by pressing the refresh button in your browser.

    An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

    We apologise for any inconvenience.
    </snip>


    Then the below in a iframe below the above text, on the same page visible to everyone (not peronsally happy about that might I add!)

    <snip>
    Database error in vBulletin 3.0.0 Beta 4:

    Invalid SQL:
    ### SHOW USERS BROWSING THE BOARD ###
    SELECT
    user.username, (user.options & 512) AS invisible, user.usergroupid,
    session.userid, session.inforum, session.lastactivity,
    IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
    FROM session AS session
    LEFT JOIN user AS user ON(user.userid = session.userid)
    WHERE session.lastactivity > 1058816075
    ORDER BY invisible ASC, username ASC

    mysql error: Can't open file: 'session.MYI'. (errno: 145)

    mysql error number: 1016

    Date: Monday 21st of July 2003 12:49:36 PM
    Script: http://www.whichbrowser.co.uk/forum/index.php
    Referer:
    Username: Caspar
    IP Address: xxx.xxx.xxx.xxx
    <snip>

    What am I doing wrong?

  • #2
    Your session table is corrupted. Try these queries:

    REPAIR TABLE session;
    ALTER TABLE session TYPE=HEAP;

    If that doesn't work try this:

    Code:
    DROP TABLE session;
    CREATE TABLE session (
    sessionhash varchar(32) NOT NULL default '',
    userid int(10) unsigned NOT NULL default '0',
    host varchar(15) NOT NULL default '',
    lastactivity int(10) unsigned NOT NULL default '0',
    styleid smallint(5) unsigned NOT NULL default '0',
    location varchar(255) NOT NULL default '',
    althash varchar(32) NOT NULL default '',
    badlocation tinyint(3) unsigned NOT NULL default '0',
    inforum smallint(5) unsigned NOT NULL default '0',
    inthread int(10) unsigned NOT NULL default '0',
    incalendar int(10) unsigned NOT NULL default '0',
    loggedin smallint(5) unsigned NOT NULL default '0',
    idhash varchar(32) NOT NULL default '',
    useragent varchar(100) NOT NULL default '',
    bypass smallint(6) NOT NULL default '0',
    PRIMARY KEY (sessionhash)
    ) TYPE=HEAP;
    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


    • #3
      I'm getting this error when going into the admin cp:

      <!--
      Database error in vBulletin 3.0.0 Beta 4:

      Invalid SQL:
      SELECT *
      FROM session
      WHERE sessionhash = '0fc390d6dbc31e7b698abfe32c7add26'
      AND lastactivity &gt; 1058825767
      AND host = '213.106.132.9'
      AND idhash = '06143d968597518ec0a9d15bbce3baf2'

      mysql error: Can't open file: 'session.MYI'. (errno: 145)

      mysql error number: 1016

      Date: Monday 21st of July 2003 03:31:07 PM
      Script: http://www.whichbrowser.co.uk/forum/admincp/index.php
      Referer:
      IP Address:
      -->

      Where do I do your other suggestions then?

      Comment


      • #4
        Use phpMyAdmin to run those queries.
        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


        • #5
          the error code 145 = Table was marked as crashed and should be repaired - if you dont have access to phpmyadmin run the repair.php script - it fixed it for me on the exact same code.

          Comment

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