Announcement

Collapse
No announcement yet.

No idea whats going on.....

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

  • No idea whats going on.....

    http://www.ffimpulse.com/forum

    Ok....been having problems all day. I can use pm system, view whos online, see the forum home page, go in the arcade.......but when I try to access any of my forums I get database errors. Here's what my host said....

    first
    You may have noticed some slight problems within the past few hours.
    Unfortunately, the datacentre where our servers are hosted experienced a widespread power outage following maintenance on the UPS systems (universal power supply) which affected 1200 servers.

    InnoHosting servers were brought back online pretty quick compared to other servers at the same facility so it's likely some members would not have noticed any problems.

    At the moment everything is working perfectly fine with no problems.
    We will be speaking to our provider and the datacentre on why this happened and why the back-up generators didn't kick in.

    We'll keep you updated.

    InnoHosting Tech Support
    second
    Hi,

    You shouldn't be getting any database errors right now.
    Server load is less than 1. 15 minute server load average is 0.98 which
    is a good level.

    Sites using MySQL and forum software are functioning fine. Everything
    went back to normal quite a while ago.


    Rameen
    Running 3.0.0
    ::::::: http://ffimpulse.com
    ::::::: http://ffimpulse.com/forum

  • #2
    It's possible the server problems cause database corruption. We need to see the entire error message. Either post the contents of the email you received, or right-click on the error page and go to View/Source. Then copy-n-paste the error message here.
    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
      here are a few then....

      Database error in vBulletin 3.0.0:

      Invalid SQL:
      SELECT COUNT(*) AS threads,
      SUM(IF(lastpost>=1083641681 AND open<>10,1,0)) AS newthread
      FROM thread AS thread

      WHERE forumid = 3
      AND sticky = 0
      AND visible = 1





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

      mysql error number: 1016

      Date: Tuesday 04th of May 2004 04:54:59 AM
      Script: http://www.ffimpulse.com/forum/forumdisplay.php?f=3
      Referer: http://www.ffimpulse.com/forum/online.php?
      Username: Avirona
      Database error in vBulletin 3.0.0:

      Invalid SQL: UPDATE thread
      SET views = views + 7
      WHERE threadid = 596
      mysql error: Can't open file: 'thread.MYI'. (errno: 145)

      mysql error number: 1016

      Date: Tuesday 04th of May 2004 04:56:01 AM
      Script: http://www.ffimpulse.com/forum/cron.php?&rand=731680
      Referer: http://www.ffimpulse.com/forum/private.php?do=showpm&pmid=21106
      Username: Stone Cold
      Database error in vBulletin 3.0.0:

      Invalid SQL:
      SELECT threadid
      FROM thread AS thread
      LEFT JOIN deletionlog AS delthread ON(delthread.primaryid = thread.threadid AND delthread.type = 'thread')
      WHERE forumid IN(40, 38, 39, 37, 42, 46, 1, 3, 4, 45, 41, 5, 6, 7, 12, 13, 14, 15, 18, 21, 19, 47, 22, 28, 24, 25, 26, 43, 27, 29, 30, 32, 33, 34, 35)
      AND thread.lastpost >= 1083641681
      AND visible = 1
      AND delthread.primaryid IS NULL
      ORDER BY lastpost DESC
      LIMIT 500

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

      mysql error number: 1016

      Date: Tuesday 04th of May 2004 04:57:22 AM
      Script: http://www.ffimpulse.com/forum/search.php?do=getnew
      Referer: http://www.ffimpulse.com/forum/profile.php?do=editoptions
      Username: Avirona
      Database error in vBulletin 3.0.0:

      Invalid SQL:
      SELECT NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid,
      deletionlog.username AS del_username, deletionlog.reason AS del_reason,
      NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed, emailupdate, folderid,
      thread.*
      FROM thread AS thread
      LEFT JOIN deletionlog AS deletionlog ON (deletionlog.primaryid = thread.threadid AND deletionlog.type = 'thread')
      LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = 0)

      WHERE thread.threadid = 2804

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

      mysql error number: 1016

      Date: Tuesday 04th of May 2004 04:57:34 AM
      Script: http://www.ffimpulse.com/forum/newreply.php?do=newreply&p=45822
      Referer:
      Username: Unregistered
      Database error in vBulletin 3.0.0:

      Invalid SQL:
      SELECT thread.title, thread.threadid, thread.forumid, thread.postuserid, thread.visible,
      NOT ISNULL(deletionlog.primaryid) AS isdeleted
      ,post.pagetext AS preview
      , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
      FROM thread AS thread
      LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
      LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
      LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1)
      WHERE thread.threadid IN (0,2804)

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

      mysql error number: 1016

      Date: Tuesday 04th of May 2004 04:57:43 AM
      Script: http://www.ffimpulse.com/forum/online.php?
      Referer: http://www.ffimpulse.com/forum/index.php?
      Username: complex
      Database error in vBulletin 3.0.0:

      Invalid SQL:
      SELECT thread.title, thread.threadid, thread.forumid, thread.postuserid, thread.visible,
      NOT ISNULL(deletionlog.primaryid) AS isdeleted
      ,post.pagetext AS preview
      , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
      FROM thread AS thread
      LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
      LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
      LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 198)
      WHERE thread.threadid IN (0,2804)

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

      mysql error number: 1016

      Date: Tuesday 04th of May 2004 04:57:47 AM
      Script: http://www.ffimpulse.com/forum/online.php?
      Referer: http://www.ffimpulse.com/forum/index.php?
      Username: Avirona
      Database error in vBulletin 3.0.0:

      Invalid SQL:
      SELECT
      user.username, reputation.whoadded,
      reputation.postid as postid,
      reputation.reputation, reputation.reason,
      post.threadid as threadid,
      reputation.dateline as dateline,
      thread.title as title
      FROM reputation AS reputation
      LEFT JOIN post AS post ON(reputation.postid = post.postid)
      LEFT JOIN thread AS thread ON(post.threadid = thread.threadid)
      LEFT JOIN user AS user ON(user.userid = reputation.whoadded)
      WHERE reputation.userid = 198

      ORDER BY reputation.dateline DESC
      LIMIT 0, 5

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

      mysql error number: 1016

      Date: Tuesday 04th of May 2004 04:52:34 AM
      Script: http://www.ffimpulse.com/forum/usercp.php?
      Referer: http://www.ffimpulse.com/forum/online.php?
      Username: Avirona
      ::::::: http://ffimpulse.com
      ::::::: http://ffimpulse.com/forum

      Comment


      • #4
        Also you should disable / uninstall the arcade for the time being

        Comment


        • #5
          Originally posted by Zachery
          Also you should disable / uninstall the arcade for the time being
          Ok, thanks I did that.
          ::::::: http://ffimpulse.com
          ::::::: http://ffimpulse.com/forum

          Comment


          • #6
            Either,

            AdminCP > Import & Maitence > Repair / Optmize Tables > Select all > Continue

            or

            Go to phpmyadmin, and run this

            REPAIR TABLE thread;

            Comment


            • #7
              that seemed to work! Thank you very much.
              ::::::: http://ffimpulse.com
              ::::::: http://ffimpulse.com/forum

              Comment

              Loading...
              Working...
              X