16 November 2006, 14:32 UTC#1
So boredom-induced.com went down, and I don't have a fucking clue as to why. Here's the msg received:
QUOTE
mySQL query error: SELECT COUNT(DISTINCT(t.tid)) as tcnt,
COUNT(DISTINCT(p.pid)) as pcnt FROM bi_posts p, bi_topics t WHERE
p.post_date < 1163687440 AND p.post_date >
1163643343 AND p.topic_id=t.tid
SQL error: Can't open file: 'bi_posts.MYI' (errno: 145)
SQL error code:
Date: Thursday 16th of November 2006 06:30:40 AM
please help!
16 November 2006, 17:35 UTC#2
I'll give you a dollar for help
16 November 2006, 19:04 UTC#3
looking for a missing file...maybe a dropped table.
Look to see if this table still exists: bi_posts
16 November 2006, 19:18 UTC#4
Unlikely to be a dropped table unless the database was recently imported and failed to fully import.
The error message is vague, that being "Can't open file: 'bi_posts.MYI'"
I'd try repairing the database from PHPMyAdmin it is most likely corrupt.
16 November 2006, 19:51 UTC#5
fuck that's all like chinese to me. I'm f'ed.
16 November 2006, 19:53 UTC#6
damn I take it our downtime is a serious problem then...bummer.
16 November 2006, 19:54 UTC#7
Shoot me your control panel logins in a PM within the next 15 mins and I'll take a look for you.
16 November 2006, 21:09 UTC#8
gary lemme use that 100mbit line u got for a few days
16 November 2006, 21:35 UTC#9
QUOTE(gman @ Nov 16 2006, 03:54 PM) [snapback]397461[/snapback]
Shoot me your control panel logins in a PM within the next 15 mins and I'll take a look for you.
could I create a temp admin login for you and have you do it, or would it have to be my own info?
16 November 2006, 22:11 UTC#10
gary already disappeared :S
shady fucker
16 November 2006, 23:10 UTC#11
well I can't do shit right now anyways, I'm stuck at work. If I can't get it fixed by some time tonight, im just gunna restore them to the last back up. Sucks, cuz that was about 11 days ago
17 November 2006, 04:48 UTC#12
we tried to replace everything with some backups that I had, and the error remained. We are at a complete loss. My only other thought is that maybe the sql thing on our hosting crapped out and it will fix itself eventually, but I have no idea what I am talking about so I could be way off.
QUOTE(Duran @ Nov 16 2006, 04:53 PM) [snapback]397460[/snapback]
damn I take it our downtime is a serious problem then...bummer.
yeah this is the first... this sucks!
17 November 2006, 13:40 UTC#13
anyone who can try to help before I gotta go to work again?
