Forum not working all week

[andyfair]

http://s3.forumforfree.com/teamunicorn.html

The above forum has not been working all week which according to the error message says there is a problem with the database.

The error returned is
mySQL query error: SELECT DISTINCT(teamunicorn_posts.author_id), teamunicorn_topics.* FROM teamunicorn_topics
LEFT JOIN teamunicorn_posts ON
(teamunicorn_topics.tid=teamunicorn_posts.topic_id AND teamunicorn_posts.author_id=1)
WHERE teamunicorn_topics.forum_id=2
and teamunicorn_topics.approved=1
and (teamunicorn_topics.pinned=1 or teamunicorn_topics.last_post > 0) ORDER BY pinned DESC, last_post DESC LIMIT 0,15

mySQL error: Can't open file: 'teamunicorn_posts.MYI' (errno: 145)
mySQL error code:
Date: Friday 06th of October 2006 09:13:05 AM

[leomn]

So, you can't even get to the admin panel?

Did you try changing the skin, or was this after a change that this happened? this could be fixed by simply restoring an old backup of the forum, the support shouldn't have any problems doing it. I cheked your forum and cannot even read the topics as I keep getting similar errors. It's all out of whack.

[andyfair]

Still down as per the below.

Originally Posted by andyfair

http://s3.forumforfree.com/teamunicorn.html

The above forum has not been working all week which according to the error message says there is a problem with the database.

The error returned is
mySQL query error: SELECT DISTINCT(teamunicorn_posts.author_id), teamunicorn_topics.* FROM teamunicorn_topics
LEFT JOIN teamunicorn_posts ON
(teamunicorn_topics.tid=teamunicorn_posts.topic_id AND teamunicorn_posts.author_id=1)
WHERE teamunicorn_topics.forum_id=2
and teamunicorn_topics.approved=1
and (teamunicorn_topics.pinned=1 or teamunicorn_topics.last_post > 0) ORDER BY pinned DESC, last_post DESC LIMIT 0,15

mySQL error: Can't open file: 'teamunicorn_posts.MYI' (errno: 145)
mySQL error code:
Date: Friday 06th of October 2006 09:13:05 AM

[fedweiser]

My board is on the same server as andyfair's, and members are getting virtually the same SQL errors when they try to access threads. My URL is http://s3.forumforfree.com/fedster.html.

[andyfair]

I note the thread saying Limez has resolved most problems.

My forum is STILL down (more than 1 week). See above for error messages

http://s3.forumforfree.com/teamunicorn.html

[Nick]

Hi Andy,

This is now being looked into and will be sorted ASAP.

Sorry for the long delay.

Nick

[Limez]

this has been fixed

[fedweiser]

Thanks, mine's working now.

[Nick]

------------------------------------
Support Resolved!
If you have any further questions, feel free to create a new thread. This thread has now been closed!

Thanks for choosing Forumer!
------------------------------------