Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
1 registered (id242), 24 Guests and 13 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 05/23/08
Posts: 10
Top Posters (30 Days)
Ruben 51
Gizmo 24
DennyP 24
Dunny 15
SteveS 14
AllenAyres 12
SD 10
dbremer 10
drkknght00 9
doug 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Topic Options
#1859 - 07/24/06 08:21 PM ok how do you repair a db table ?
Mors Offline
addict
Registered: 06/26/06
Posts: 471
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 08:22 PM)
_________________________
Happy Customer !!!
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#1862 - 07/24/06 08:43 PM Re: ok how do you repair a db table ? [Re: Mors]
Mtier Offline
journeyman
Registered: 07/09/06
Posts: 59
Loc: Germany, Mainz
If you have shell access:
myisamchk -r ubbt_POSTS.MYI

Top
#1867 - 07/24/06 09:21 PM Re: ok how do you repair a db table ? [Re: Mtier]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
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
Top
#1896 - 07/25/06 05:31 AM Re: ok how do you repair a db table ? [Re: Rick]
Mors Offline
addict
Registered: 06/26/06
Posts: 471
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



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Due Date Calculator-Calculate When Your Baby is Due
by StewartMyduedate
Today at 12:54 AM
Temporary Password email not being received
by
05/24/12 10:02 PM
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
Forum Stats
10491 Members
36 Forums
33842 Topics
181709 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image