Announcement

Collapse
No announcement yet.

strikes table problem

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

  • strikes table problem

    when i am trying to login its always showing me error 127 storage and its assiging to strikes table, i tried to repair it through putty its show 0 record i tried to repair it through php my admin its showing me

    Number of rows changed from 2 to 0
    then it show its repair but same problem

    what is this table for ?
    help

  • #2
    Try running this query: TRUNCATE TABLE strikes;

    The strikes table is to keep track of failed logins.
    Best Regards
    Colin Frei

    Please don't contact me per PM.

    Comment


    • #3
      now i can login but when i am trying to login its talking about post.MYI cant open the file

      this is the message

      Database error in vBulletin 3.6.7:
      Invalid SQL:
      SELECT COUNT(*) AS count
      FROM attachment AS attachment
      INNER JOIN post AS post USING (postid)
      WHERE attachment.visible = 0;
      MySQL Error : Can't open file: 'post.MYI' (errno: 144)
      Error Number : 1016
      Date : Sunday, June 10th 2007 @ 06:31:40 AM
      Script : http://*****/controller/index.php?do=home
      Referrer : http://******/controller/
      IP Address : ******
      Username : *******
      Classname : vb_database
      what i can do now?

      Please keep in mind that i just repair the post table

      also when i am trying to login to the forum (any forum its showing me this message

      Database error in vBulletin 3.6.7:
      Invalid SQL:
      SELECT post.pagetext AS preview,
      thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
      thread.lastpost, thread.lastposter, thread.lastpostid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
      hiddencount, deletedcount
      , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
      , deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason

      , threadredirect.expires

      FROM thread AS thread
      LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
      LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1705 AND canview = 1)

      LEFT JOIN post AS post ON(post.postid = thread.firstpostid)

      LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)

      WHERE thread.threadid IN (0,178708,178709,178650,178614,178714,178704,178711,178710,178715,178697,178693,178713,178 699,178712,178700,178702,178703,162323)
      ORDER BY sticky DESC, lastpost DESC;
      MySQL Error : Can't open file: 'subscribethread.MYI' (errno: 144)
      Error Number : 1016
      Date : Sunday, June 10th 2007 @ 06:34:30 AM
      Script : http://*********8/forumdisplay.php?f=3
      Referrer : http://**********/index2.php
      IP Address : ********
      Username : ****
      Classname : vb_database
      Please be with me step by step untill i solve my problem

      my database size is 4 GB
      help

      Comment


      • #4
        It seems your database is corrupted. Ask your host to repair it using myisamchk
        Best Regards
        Colin Frei

        Please don't contact me per PM.

        Comment


        • #5
          i will run the command now through the putty as i have access to the server but please this will take around 7 hourse, can you tell me what should i do step by step before i login after the repairing

          thanks
          help

          Comment

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