Previous Thread
Next Thread
Print Thread
Hop To
Joined: Jan 2009
Posts: 92
whk
Offline
Journeyman
Journeyman
Joined: Jan 2009
Posts: 92
This is a first - my forum seems to have crashed. An error is displayed if any post or forum is clicked on. I can log in as administrator and get the message below. How do I recover from this?
Forum Link


UBB Message
We encountered a problem. The reason reported was

Script: /home/j30/www/www/ubbthreads/scripts/showflat.inc.php
Line#: 227
SQL Error: Table './j30_ubbthreads/ubbt_POSTS' is marked as crashed and should be repaired
SQL Error #: 145
Query: SELECT t.TOPIC_REPLIES, t.TOPIC_VIEWS, t.TOPIC_LAST_REPLY_TIME, t.TOPIC_SUBJECT, t.TOPIC_TOTAL_RATES, t.TOPIC_RATING, t.TOPIC_STATUS, t.TOPIC_IS_STICKY, t.USER_ID, t.POST_ID, t.FORUM_ID, t.TOPIC_ID FROM ubbt_TOPICS as t, ubbt_POSTS as p WHERE p.POST_ID = 10321 AND p.TOPIC_ID = t.TOPIC_ID

Please click back to return to the previous page.

Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Well the table "posts" needs to be repaired.
What caused it is anyone's guess.
I will say repairing a tables can be a caveat situation without a recent backup to rely on.

But anyway one tool is phpmyadmin.
http://php.about.com/od/mysqladministration/qt/repair_mysql.htm



Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jan 2009
Posts: 92
whk
Offline
Journeyman
Journeyman
Joined: Jan 2009
Posts: 92
Ruben - I owe you a beer! That worked and the forum is back up. Thanks for the tip.

Bill

Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Don't forget to read the last line on the link.

MAKE A BACKUP!!!


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jan 2009
Posts: 92
whk
Offline
Journeyman
Journeyman
Joined: Jan 2009
Posts: 92
yup! in process.


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
1 members (Ruben), 476 guests, and 111 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)