Announcement

Collapse
No announcement yet.

No idea whats going on.....

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

  • Mystic Stylez
    replied
    that seemed to work! Thank you very much.

    Leave a comment:


  • Zachery
    replied
    Either,

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

    or

    Go to phpmyadmin, and run this

    REPAIR TABLE thread;

    Leave a comment:


  • Mystic Stylez
    replied
    Originally posted by Zachery
    Also you should disable / uninstall the arcade for the time being
    Ok, thanks I did that.

    Leave a comment:


  • Zachery
    replied
    Also you should disable / uninstall the arcade for the time being

    Leave a comment:


  • Mystic Stylez
    replied
    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

    Leave a comment:


  • Steve Machol
    replied
    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.

    Leave a comment:


  • Mystic Stylez
    started a topic No idea whats going on.....

    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
Loading...
Working...
X