|
Joined: Dec 2007
Posts: 32
newbie
|
newbie
Joined: Dec 2007
Posts: 32 |
I have had an error with this exact table before last october. Below is the error..Last time i used the following command in the SQL tab in phpmyadmin REPAIR TABLE `ubbt_ONLINE` and it worked! this time its not working.. Can anyone give me any suggestions? Its very imperative that we get this fixed ASAP...
After running the reapir query.. this is what i get "board.ubbt_ONLINE repair status Table is already up to date"
Script: /home/public_html/board/libs/ubbthreads.inc.php Line#: 531 SQL Error: Table './board/ubbt_ONLINE' is marked as crashed and should be repaired SQL Error #: 145 Query: REPLACE INTO ubbt_ONLINE (USER_ID,ONLINE_DISPLAY_NAME,ONLINE_LAST_ACTIVITY,ONLINE_SCRIPT_NAME,ONLINE_BROWSING_FORUM,ONLINE_USER_TYPE,ONLINE_USER_IP) VALUES)
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837 |
repair table ubbt_ONLINE
should do the trick - can be run from the CP within threads.
|
|
|
|
Joined: Jun 2006
Posts: 956
Old Hand
|
Old Hand
Joined: Jun 2006
Posts: 956 |
Just do it. The command should fix it.
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837 |
Which version of threads are you using?
|
|
|
|
Joined: Dec 2007
Posts: 32
newbie
|
newbie
Joined: Dec 2007
Posts: 32 |
repair table ubbt_ONLINE
should do the trick - can be run from the CP within threads. I edited my post. didnt think i would get such a quick response.. thanks! but, i have tried the repair thing a few times.. no luck!
|
|
|
|
Joined: Dec 2007
Posts: 32
newbie
|
newbie
Joined: Dec 2007
Posts: 32 |
Which version of threads are you using? 7.0.2
|
|
|
|
Joined: Dec 2007
Posts: 32
newbie
|
newbie
Joined: Dec 2007
Posts: 32 |
repair table ubbt_ONLINE
should do the trick - can be run from the CP within threads. do i need the ' marks before and after the word ubbt_online? i was under the impression that i did.. thanks
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837 |
Which version of threads are you using? 7.0.2 You might like to consider upgrading - Rick said in one post... You might consider upgrading. In 7.1, I believe, this was converted to a HEAP table so it resides in memory to prevent crashes. Also he made the following post... https://www.ubbcentral.com/forums/u.../true/Memory_heap_tables.html#Post166834
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837 |
|
|
|
|
Joined: Dec 2007
Posts: 32
newbie
|
newbie
Joined: Dec 2007
Posts: 32 |
thanks! i would LOVE to upgrade. But i dont think there are enough funds in the clients budget to fund our time in doing this!... hmm, i read ricks post u linked me too.. Not sure what he means. Our Knowledge of SQL is very basic...I am just worried about jeopardizing the DB anymore than it already is.. How bad is this error i got?
|
|
|
|
Joined: Dec 2007
Posts: 32
newbie
|
newbie
Joined: Dec 2007
Posts: 32 |
Thanks! I tried this and get the same result as before.. here is a screen shot
|
|
|
|
Joined: Dec 2007
Posts: 32
newbie
|
newbie
Joined: Dec 2007
Posts: 32 |
Also, not sure if this means anything.. But i went back into phpmyadmin and i look at the ONLINE table.. and it says IN USE? why is that? I am not in that table at all or anything.. here is a screen shot
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837 |
It means what it says on the tin You may need to shut down your forums (to prevent people from being online and updating the table), or even turn off mysql and then run a repair on the table. If you have access to root on your server stop mysql, then repair the table, then restart mysql. You may need to get your host to do this for you if you are unsure on command line instructions. As far as I know you should be safe to convert the table to heap.
|
|
|
|
Joined: Dec 2007
Posts: 32
newbie
|
newbie
Joined: Dec 2007
Posts: 32 |
It means what it says on the tin You may need to shut down your forums (to prevent people from being online and updating the table), or even turn off mysql and then run a repair on the table. If you have access to root on your server stop mysql, then repair the table, then restart mysql. You may need to get your host to do this for you if you are unsure on command line instructions. As far as I know you should be safe to convert the table to heap. This error is preventing everyone (Even us admins) from logging into the forum at all.. We are totally locked out. Last time this repair thing worked... What do u mean "the tin"? sorry.. How do we turn off of MySql and repair table? I am willing to do whatever it takes. I just need to get this board back up by end of today somehow.. if its easier to guide me by phone, let me know! It would be greatly appreciated.. and as for converting table to heap.. How do i do this.. Remember, our knowledge with SQL is very limited. We cannot afford to make any more errors til this problem is fixed..
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837 |
If you are unsure or do not have access to the command line, I would suggest getting your host to repair the table.
|
|
|
|
Joined: Dec 2007
Posts: 32
newbie
|
newbie
Joined: Dec 2007
Posts: 32 |
If you are unsure or do not have access to the command line, I would suggest getting your host to repair the table. I have done database work with command lines PUTTY before .. But that was only importing a database..... Is there any tutorial i can follow that will explain how to shut mysql off and repair that table?? I really need to fix that asap... After that, i would like to try that one thing other thing that rick posted.. thanks Ian!
|
|
|
|
Joined: Feb 2007
Posts: 1,294 Likes: 2
Veteran
|
Veteran
Joined: Feb 2007
Posts: 1,294 Likes: 2 |
You can download the MySQL Documentation here: http://dev.mysql.com/doc/
|
|
|
|
Joined: Dec 2007
Posts: 32
newbie
|
newbie
Joined: Dec 2007
Posts: 32 |
i have the host on the phone right now..and they cant even get that reapired..
is there any other suggestions? anything i can edit into that table manually? from what i read it doesnt seem that that table is too important, yet its causing all these problems...
i am guessing my next step would be to call UBB support directly?
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
If you need to, just have the host DROP the table completely and then recreate it. It's just temp data, so you won't lose anything. You'd have to do this through phpmyadmin or from the MySQL command prompt. Then
create table ubbt_ONLINE(
ONLINE_DISPLAY_NAME varchar(64) not null,
USER_ID int(9) not null,
ONLINE_LAST_ACTIVITY int(9) default '0' not null,
ONLINE_SCRIPT_NAME varchar(64),
ONLINE_USER_TYPE varchar(1) not null,
ONLINE_BROWSING_FORUM varchar(100),
ONLINE_USER_IP varchar(15),
UNIQUE Oindx1 (ONLINE_DISPLAY_NAME),
INDEX Oindx2 (ONLINE_LAST_ACTIVITY),
INDEX type_index(ONLINE_USER_TYPE)
) TYPE=MyISAM
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837 |
Thanks Rick
|
|
|
|
Joined: Dec 2007
Posts: 32
newbie
|
newbie
Joined: Dec 2007
Posts: 32 |
Thanks Rick! Thats pretty much what i ended up doing.. all is good now..
But.. I would like to do that HEAP thing you had written about, sounds like that will prevent what happened to us?
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
|
|
|
1 members (Ruben),
1,248
guests, and
268
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|