Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
5 registered (Dunny, Outdoorking, Pilgrim, SteveS, JPFolks), 31 Guests and 6 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 05/22/12
Posts: 2
Top Posters (30 Days)
Ruben 49
DennyP 24
Gizmo 23
Dunny 18
SteveS 14
AllenAyres 12
dbremer 10
drkknght00 9
SD 9
driv 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Page 1 of 9 1 2 3 4 5 6 7 8 9 >
Topic Options
#173127 - 01/11/07 06:03 PM Forums Down
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
 Quote:
We encountered a problem. The reason reported was
Script: /var/path/forums/scripts/cfrm.inc.php
Line#: 333
SQL Error: Can't open file: 'ubbt_POSTS.MYI' (errno: 145)
SQL Error #: 1016
Query: select COUNT(*) as posts, sum(t1.POST_IS_TOPIC) as topics from ubbt_POSTS as t1, ubbt_TOPICS as t2 where t2.FORUM_ID = 45 and t1.TOPIC_ID = t2.TOPIC_ID and t1.POST_IS_APPROVED = '1' and t1.POST_POSTED_TIME > 1167693637

Please use your back button to return to the previous page.


Any thoughts?
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."
#173129 - 01/11/07 06:25 PM Re: Forums Down [Re: Ian]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
errno: 145 is a corrupt table. You'll want to run the following SQL command:

REPAIR TABLE ubbt_POSTS


Edited by Rick (01/11/07 06:46 PM)
Edit Reason: because I can't spell
Top
#173130 - 01/11/07 06:38 PM Re: Forums Down [Re: Rick]
RichieRich Offline
stranger
Registered: 01/02/07
Posts: 6
yes except remember to put an I in the repair...
Top
#173131 - 01/11/07 06:46 PM Re: Forums Down [Re: RichieRich]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Oopsie \:o Edited my post ;\)
Top
#173132 - 01/11/07 06:59 PM Re: Forums Down [Re: Rick]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
trying that - no luck so far \:\(
Top
#173133 - 01/11/07 07:10 PM Re: Forums Down [Re: Ian]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Do you get any info back when you run the command?
Top
#173153 - 01/11/07 11:06 PM Re: Forums Down [Re: Rick]
Mtier Offline
journeyman
Registered: 07/09/06
Posts: 59
Loc: Germany, Mainz
If you have shell access:
myisamchk -r ubbt_POSTS.MYI
Top
#173158 - 01/11/07 11:15 PM Re: Forums Down [Re: Rick]
ntdoc Offline
Registered: 11/09/06
Posts: 3384
@Rick

Didn't you make a change to one of the cache tables or something like that in 7.1b?? for similar issue?
Top
#173173 - 01/12/07 01:22 AM Re: Forums Down [Re: Rick]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
 Originally Posted By: Rick
Do you get any info back when you run the command?


no just times out in phphmyadmin \:\(
Top
#173175 - 01/12/07 02:12 AM Re: Forums Down [Re: Ian]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
You should run commands through the command line; the php script (phpmyadmin) likely times out because your tables are so large.
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
Page 1 of 9 1 2 3 4 5 6 7 8 9 >



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

Today's Birthdays
No Birthdays
Recent Topics
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
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Custom forum permissions
by ntdoc
05/18/12 02:07 PM
Forum Stats
10489 Members
36 Forums
33841 Topics
181698 Posts

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