Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
6 registered (Djuma, driv, Gardener, Mike L, Ruben Rocha, 1 invisible), 19 Guests and 13 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 11/21/08
Posts: 1
Top Posters (30 Days)
Ruben Rocha 180
Gizmo 112
Rick 106
Thelockman 79
driv 43
AllenAyres 35
ntdoc 28
Ian 24
Sirdude 23
ScriptKeeper 20
Latest Photos
My Home System
test photo gallery
Bernese Mountain Dogs
My Daimler
Dorado and shark
Topic Options
Rate This Topic
#1859 - 07/24/06 05:21 PM ok how do you repair a db table ?
Mors Offline
addict

Registered: 06/26/06
Posts: 445
Loc: So. California
Script: D:\UBBMSB\validus7.0\ubbthreads-7-0-b1\scripts\showflat.inc.php
Line#: 224
SQL Error: Table '.\validus\ubbt_posts' is marked as crashed and should be repaired
SQL Error #: 145
Query: SELECT t1.TOPIC_ID,t1.FORUM_ID,t1.TOPIC_LAST_REPLY_TIME,t1.TOPIC_IS_STICKY,t1.POST_ID FROM ubbt_TOPICS as t1, ubbt_POSTS as t2 WHERE t2.POST_ID = 21537 AND t1.TOPIC_ID = t2.TOPIC_ID

apparently a large post crashed it.


Edited by Mors (07/24/06 05:22 PM)
_________________________
Happy Customer !!!

Top
#1862 - 07/24/06 05:43 PM Re: ok how do you repair a db table ? [Re: Mors]
Mtier Offline
journeyman

Registered: 07/08/06
Posts: 55
Loc: Germany, Mainz
If you have shell access:
myisamchk -r ubbt_POSTS.MYI


Top
#1867 - 07/24/06 06:21 PM Re: ok how do you repair a db table ? [Re: Mtier]
Rick Administrator Offline

*****

Registered: 06/04/06
Posts: 7903
Loc: Aberdeen, WA
If you don't have shell access then you'll need to do it through a SQL interface, either through the control panel or using something like phpmyadin

REPAIR TABLE ubbt_POSTS
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top
#1896 - 07/25/06 02:31 AM Re: ok how do you repair a db table ? [Re: Rick]
Mors Offline
addict

Registered: 06/26/06
Posts: 445
Loc: So. California
aye I did. Haveing a wierd issue that just popped up with large posts. It creates a topic with no post id's and bombs out. lists it as a post and then says sorry cant find your post.

Crazyy works ok one instance and not the other. might be a crashed table.
_________________________
Happy Customer !!!

Top


Shout Box

Today's Birthdays
No Birthdays
Recent Topics
I'm the Admin but.....
by David DelMonte
12/02/08 11:12 AM
Fatal error: Smarty::require_once
()

by ThreadsUser
12/02/08 08:17 AM
PayPal batch file for ID'ing expired and failed payment subscriptions?
by Mitch P.
12/02/08 06:02 AM
Shrinking graemlins
by Djuma
12/01/08 05:48 PM
2 problems I'm seeing now.
by DougMM
12/01/08 04:39 PM
Forum Stats
4261 Members
33 Forums
30535 Topics
154977 Posts

Max Online: 978 @ 06/24/07 08:19 PM