Announcement

Collapse
No announcement yet.

how do i fix this

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

  • how do i fix this

    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 > 1058115951
    ORDER BY invisible ASC, username ASC

    mysql error: Can't open file: 'session.MYI'. (errno: 145)
    mysql error number: 1016
    Date: Sunday 13th of July 2003 01:06:29 PM
    Script: http://forums.saiyancrusades.com/index.php
    Referer:
    Username: P11maf
    IP Address: 62.254.32.6



    it wont allow me into my cp

    cp error

    Database error in vBulletin 3.0.0 Beta 4:

    Invalid SQL:
    SELECT *
    FROM session
    WHERE sessionhash = '2c904801ee5adaa94191346a9092a862'
    AND lastactivity > 1058116204
    AND host = '62.254.32.6'
    AND idhash = '84d1684e0d91045ee2970f39a4b52531'

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

    mysql error number: 1016

    Date: Sunday 13th of July 2003 01:10:43 PM
    Script: http://forums.saiyancrusades.com/admincp/
    Referer:
    IP Address: 62.254.32.6

  • #2
    Try this query:

    DELETE FROM session;

    If that doesn't work, run this one:

    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
      done nothin mate, when i did delete from session; it said session does not exsit

      and i created the table, and now it doesnt show the error on the main page, it emails it to me now.

      Database error in vBulletin 3.0.0 Beta 4:

      Invalid SQL:
      SELECT *
      FROM session
      WHERE sessionhash = 'c7c3d7890b001f43514dac1983888992'
      AND lastactivity > 1058116988
      AND host = '62.254.32.6'
      AND idhash = '84d1684e0d91045ee2970f39a4b52531'

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

      mysql error number: 1016

      Date: Sunday 13th of July 2003 01:23:47 PM
      Script: http://forums.saiyancrusades.com/index.php
      Referer:
      IP Address: 62.254.32.6

      Comment


      • #4
        The session table is crashed again. Close your forums and repeat the second query I posted above.
        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
          how do i close the forum, if it wont allow me to log in to the admincp, or is there away im not sure of doing it from phpmyadmin

          Comment


          • #6
            Try it again without closing the forum.
            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


            • #7
              i have done so, many times, nothing happend

              edit: also the private message system on this bored is giving me errors

              Comment


              • #8
                What do you mean 'nothing happened'? What was the result after running this query?

                And what errors are you getting on these forums?
                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


                • #9
                  when i make the table it tells me its already there.

                  Error
                  SQL-query :
                  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
                  MySQL said:

                  Table 'SESSION' already existsBack

                  so i deleted it, and remade the it, and it said the same thing. it does not tell me the error on the forums here, so i took a screen shot http://www.saiyancrusades.com/error.JPG

                  Comment


                  • #10
                    My bad. Try this one:

                    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


                    • #11
                      now i get this:

                      Database error in vBulletin 3.0.0 Beta 4:

                      Invalid SQL:
                      SELECT *
                      FROM session
                      WHERE sessionhash = 'aeeb96bcc6448015fc6f156e7ff7c4fe'
                      AND lastactivity > 1058130189
                      AND host = '62.254.32.6'
                      AND idhash = '84d1684e0d91045ee2970f39a4b52531'

                      mysql error: Table 'piemaf_theforum.session' doesn't exist

                      mysql error number: 1146

                      and, maybe this is some thing, in phpmyadmin, under the forum db, were it lists the tables, it goes like this:


                      SESSION
                      access
                      adminhelp
                      administrator
                      adminlog
                      adminutil
                      etc. and yes, i refresh the db

                      oh, and when i redid what u said, it give me this Error
                      SQL-query :
                      DROP TABLE SESSION
                      MySQL said:

                      Unknown table 'session'Back

                      Comment


                      • #12
                        i have fixed the problems, thanks very much steve, it take the table with capkeys, so i done it by hand, i dont know why it made the sessions in caps, but thats why it never worked, maybe because of the last part ) TYPE=HEAP; but i dunno. dont want to fiddle with it
                        but thats alot

                        Comment


                        • #13
                          hey steve, i done that, and it work, but now i have a new problem, it wont allow me to login to the admincp or modcp, it says thank you for loging in, then it put me back to the login panel, what should i do to fix this

                          Comment


                          • #14
                            Try running the fix_login.php script here:

                            http://www.vbulletin.com/forum/showp...&postcount=140
                            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


                            • #15
                              oh i done that, and its still not allowing me in

                              Comment

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