Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
4 registered (ECNet, Gizmo, packlite, 1 invisible), 20 Guests and 21 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/05/06
Posts: 1097
Top Posters (30 Days)
Ruben Rocha 103
Rick 80
Mark S 71
Thelockman 58
Gizmo 54
driv 35
ntdoc 32
Sirdude 32
packlite 24
AllenAyres 22
Latest Photos
bear test
Beach Barbie-Q
Sunset
Accept the challenge!
Trees
Page 1 of 2 1 2 >
Topic Options
Rate This Topic
#216058 - 07/31/08 11:00 AM Emergency! Please help
theskyking Offline
newbie

Registered: 11/08/06
Posts: 36
For some reason, overnight (I didn't change anything), my forum seems "broken." When you visit the homepage you get a message that says:

----

Script: /forums/scripts/cfrm.inc.php
Line#: 180
SQL Error: Can't open file: 'ubbt_ONLINE.MYI' (errno: 145)
SQL Error #: 1016
Query: SELECT ONLINE_BROWSING_FORUM,COUNT(*),ONLINE_USER_TYPE FROM ubbt_ONLINE WHERE ONLINE_LAST_ACTIVITY > 1217499456 GROUP BY ONLINE_BROWSING_FORUM,ONLINE_USER_TYPE

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

-----

The address is http://www.lymecommunity.com

Can someone please help me fix this? I did not change a thing, so I wonder if it is a server-side issue? HELP!

Thanks

Bryan

Top
#216060 - 07/31/08 11:09 AM Re: Emergency! Please help [Re: theskyking]
Sirdude Offline

*****

Registered: 04/19/07
Posts: 2122
Loc: SoCal, USA
online table is a memory based table... but just go to phpmyadmin and 'repair' ubbt_ONLINE

should be really quick, since it's not a huge table.
_________________________


Top
#216061 - 07/31/08 11:24 AM Re: Emergency! Please help [Re: Sirdude]
theskyking Offline
newbie

Registered: 11/08/06
Posts: 36
I just ran "database repair" and it appears nothing happened? Still getting the error screen...??

My control panel on the forum still works but the forum itself is toast? Help?


Edited by theskyking (07/31/08 11:41 AM)

Top
#216062 - 07/31/08 11:44 AM Re: Emergency! Please help [Re: theskyking]
Sirdude Offline

*****

Registered: 04/19/07
Posts: 2122
Loc: SoCal, USA
so you went into phpmyadmin and did

Sql Query:
REPAIR TABLE ubbt_ONLINE;


and it was happy?

matter of fact, since you have your admin cpanel, you can do it from database tools, sql command

also, what version of ubbt are you running?
_________________________


Top
#216063 - 07/31/08 11:53 AM Re: Emergency! Please help [Re: Sirdude]
theskyking Offline
newbie

Registered: 11/08/06
Posts: 36
I just did that and it worked! Well, it sort of worked. Now some pages on the forum work and others do not. This is another error message I am getting elsewhere. Should I run another execute command in the control panel like I just did? Whatever you recommended DID work but not completely. Here is the new error:

---
Script: /forums/scripts/showflat.inc.php
Line#: 416
SQL Error: File './lymediseaseforums/ubbt_TOPIC_VIEWS.MYD' not found (Errcode: 13)
SQL Error #: 1105
Query: insert into ubbt_TOPIC_VIEWS (TOPIC_ID) values ( 2631 )

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

Top
#216064 - 07/31/08 11:57 AM Re: Emergency! Please help [Re: theskyking]
Sirdude Offline

*****

Registered: 04/19/07
Posts: 2122
Loc: SoCal, USA
ugh...

you need to run repair on ubbt_TOPIC_VIEWS now


same idea, but different table name.. dunno if you really did a successful overall DB repair..

this may be pointing to other problems though.. Tables shouldn't 'go away' wink
_________________________


Top
#216070 - 07/31/08 01:06 PM Re: Emergency! Please help [Re: Sirdude]
theskyking Offline
newbie

Registered: 11/08/06
Posts: 36
I did that and it could not be completed, maybe I entered the wrong command?

Result:

error File './lymediseaseforums/ubbt_TOPIC_VIEWS.MYD' not found (Errcode: 13)

Command:

REPAIR TABLE ubbt_TOPIC_VIEWS;



In my table information, ubbt_TOPIC_VIEWS is showing as only being 1 byte. Does that mean it got lost? Missing, dead?


Edited by theskyking (07/31/08 01:12 PM)

Top
#216071 - 07/31/08 01:11 PM Re: Emergency! Please help [Re: theskyking]
Sirdude Offline

*****

Registered: 04/19/07
Posts: 2122
Loc: SoCal, USA
ugh.. lookin like you have some serious problems with your mysql DB..

do you have a backup?
_________________________


Top
#216072 - 07/31/08 01:12 PM Re: Emergency! Please help [Re: Sirdude]
theskyking Offline
newbie

Registered: 11/08/06
Posts: 36
In my table information, ubbt_TOPIC_VIEWS is showing as only being 1 byte. Does that mean it got lost? Missing, dead?

Top
#216073 - 07/31/08 01:12 PM Re: Emergency! Please help [Re: theskyking]
theskyking Offline
newbie

Registered: 11/08/06
Posts: 36
Can I give you the user name and password for my forum and you can check it out?

Top
Page 1 of 2 1 2 >


Shout Box

Today's Birthdays
Anoneguy
Recent Topics
How to Change Link Color / Underline in styles?
by ECNet
18 minutes 6 seconds ago
Chaging the "max online" number and date
by wanted
Today at 02:22 PM
7.4.1. In Threaded Mode - "Mark All Read" Doesn't Work
by packlite
Today at 10:26 AM
Custom island with sql connection
by Robje01
Today at 09:13 AM
Arabic letters test
by Cowabanga
Today at 04:47 AM
Forum Stats
4296 Members
33 Forums
30686 Topics
155997 Posts

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