Error in mysql

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • not
    Member
    • Nov 2005
    • 90

    Error in mysql

    Updated to 3.6 a few weeks ago, everything worked fine until tonight I keep getting this error. Installed a second "style" a week ago, but nothing done since then. Error on both styles and judging from errors sent to my email it is affecting everyone.

    Code:
    Database error in vBulletin 3.6.0:
    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
       , threadread.readtime AS threadread
       , threadredirect.expires
       
      FROM vbull_thread AS thread
       LEFT JOIN vbull_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
        LEFT JOIN vbull_subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 2 AND canview = 1)
        LEFT JOIN vbull_threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 2)
       LEFT JOIN vbull_post AS post ON(post.postid = thread.firstpostid)
       
       LEFT JOIN vbull_threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
       
      WHERE thread.threadid IN (0,2302,1844,1804,1775,1816,1799,1756,1575,1401,1723,1740,1435,1691,1674,1671,1651,1572,1652,1287,1681,1700) 
      ORDER BY sticky DESC, lastpost DESC;
    MySQL Error  : Can't open file: 'vbull_post.MYI' (errno: 144)
    Error Number : 1016
    Date         : Saturday, September 23rd 2006 @ 06:00:19 AM
    ***
    Classname    : vb_database
  • Lats
    Senior Member
    • Mar 2002
    • 3671

    #2
    Error 144 means the table (post) has crashed.

    ACP -> Maintenance -> Repair / Optimize Tables -> select post -> Continue
    Lats...

    Comment

    • not
      Member
      • Nov 2005
      • 90

      #3
      Repair these tables?
      vbull_post
      vbull_posthash
      vbull_postindex
      vbull_postparsed

      I noticed when entering the cp that the cp home page is giving the same error, same with moderator logs.
      Last edited by not; Fri 22 Sep '06, 11:30pm.

      Comment

      • Lats
        Senior Member
        • Mar 2002
        • 3671

        #4
        Try repairing the table in phpmyadmin.
        Lats...

        Comment

        • not
          Member
          • Nov 2005
          • 90

          #5
          Thanks for your help Lats.

          I was able to enter my cp and run a repair on post table, but it seems to have timed out with my host. Now all I am getting is a "page cannot be displayed" error.

          I have access to myisamchk from my host, time to use it?

          Comment

          • Lats
            Senior Member
            • Mar 2002
            • 3671

            #6
            You may need to keep refreshing several times for it to be able to complete. Try that before getting too serious
            Lats...

            Comment

            • not
              Member
              • Nov 2005
              • 90

              #7
              lol

              Your right, slow host, it seems back up now.

              Thanks again.
              Last edited by not; Sat 23 Sep '06, 12:22am.

              Comment

              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
              Working...
              😀
              😂
              🥰
              😘
              🤢
              😎
              😞
              😡
              👍
              👎