No idea whats going on.....

[Mystic Stylez]

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

[Steve Machol]

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.

[Mystic Stylez]

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

[Zachery]

Also you should disable / uninstall the arcade for the time being

[Mystic Stylez]

Also you should disable / uninstall the arcade for the time being

Ok, thanks I did that.

[Zachery]

Either,

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

or

Go to phpmyadmin, and run this

REPAIR TABLE thread;

[Mystic Stylez]

that seemed to work! Thank you very much.