Announcement

Collapse
No announcement yet.

Forums database error?

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

  • Pady
    replied
    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.

    Leave a comment:


  • Steve Machol
    replied
    Use phpMyAdmin to run those queries.

    Leave a comment:


  • CasparUK
    replied
    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?

    Leave a comment:


  • Steve Machol
    replied
    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;

    Leave a comment:


  • CasparUK
    started a topic Forums database error?

    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?
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X