Got error 127 from storage engine

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Caislander
    Member
    • Jul 2001
    • 46

    Got error 127 from storage engine

    Can anyone tell me where this bit of sql resides and what is wrong with it?

    Code:
    Database error in vBulletin 3.6.4:
    
    Invalid SQL:
    
            SELECT
                user.username, (user.options & 512) AS invisible, user.usergroupid,
                session.userid, session.inforum, session.lastactivity,
                IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
            FROM session AS session
            LEFT JOIN user AS user ON(user.userid = session.userid)
            WHERE session.lastactivity > 1293476859
            ORDER BY username ASC;
    MySQL Error : Got error 127 from storage engine
    Error Number : 1030

    it has work up until a couple of weeks ago, apparently not sure when it stopped was away on business, i have not changed anything on my server so I an not sure what is wrong.

    ps: i did a search on error code and didnt find anything so if I missed a useful thread please point me that way.

    ty in advance
    Caislander
    From The Land Of SunShine, Surf & Code :cool:
    Web Xpertz/City Forums
    The Admin Zone
  • Lats
    Senior Member
    • Mar 2002
    • 3671

    #2
    Check this thread...

    Lats...

    Comment

    • Caislander
      Member
      • Jul 2001
      • 46

      #3
      TY

      Originally posted by Lats
      Lats,

      Ty for the response I have already tried repairing all tables from mysql (sorry I should have posted in the ordinal post) all but one table showed as being ok. and the one that is broke has nothing to do with users or user names. Should I run repair from the control panel instead of command line?
      Caislander
      From The Land Of SunShine, Surf & Code :cool:
      Web Xpertz/City Forums
      The Admin Zone

      Comment

      • Steve Machol
        Former Customer Support Manager
        • Jul 2000
        • 154488

        #4
        If the session table reports ok, then you should not be getting that error now.
        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

        • Caislander
          Member
          • Jul 2001
          • 46

          #5
          Steve,

          This is what I get when i run repair

          Repairing Database
          ****_forums is now being repaired.


          ****_forums.cpsession
          note : The storage engine for the table doesn't support repair

          but it repaired some other tables the first time I ran it, thoughts?

          Thanks Again
          Caislander
          From The Land Of SunShine, Surf & Code :cool:
          Web Xpertz/City Forums
          The Admin Zone

          Comment

          • Steve Machol
            Former Customer Support Manager
            • Jul 2000
            • 154488

            #6
            Are you still getting the original error? If so, what is the complete error?
            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

            • Caislander
              Member
              • Jul 2001
              • 46

              #7
              Steve,

              I am good, I opened and manually reset the table and as soon as i did that i was able to run repair and all else was taken care of..

              Thanks for the assist all
              Caislander
              From The Land Of SunShine, Surf & Code :cool:
              Web Xpertz/City Forums
              The Admin Zone

              Comment

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