My forum
http://www.britbike.com/forums/ubbthreads.php

shows below error message, I have no idea how to fix this.
i run 7.3.1
Thanks for your input.
/Morgan in Sweden

UBB Message
We encountered a problem. The reason reported was
Script: /home/cluster1/data/i/p/a1172648/html/forums/libs/user.inc.php
Line#: 445
SQL Error: Table './14462_britbikecom/ubbt_bbfUSERS' is marked as crashed and should be repaired
SQL Error #: 145
Query: SELECT t2.USER_TIME_OFFSET,t2.USER_TOPIC_VIEW_TYPE,t2.USER_TIME_FORMAT, t1.USER_ID, t1.USER_DISPLAY_NAME, t1.USER_PASSWORD, t1.USER_SESSION_ID, t1.USER_MEMBERSHIP_LEVEL, t1.USER_IS_BANNED,t1.USER_RULES_ACCEPTED, t1.USER_IS_UNDERAGE, t2.USER_TOTAL_PM, t2.USER_STYLE, t2.USER_HIDE_LEFT_COLUMN,t2.USER_HIDE_RIGHT_COLUMN, t2.USER_LANGUAGE, t2.USER_MOOD, t2.USER_RELATIVE_TIME, t2.USER_TIME_OFFSET,t2.USER_SHOW_ALL_GRAEMLINS, t2.USER_AVATAR, t2.USER_TITLE, t2.USER_CUSTOM_TITLE, t2.USER_NAME_COLOR, t2.USER_SHOW_LEFT_MYSTUFF FROM ubbt_bbfUSERS as t1, ubbt_bbfUSER_PROFILE as t2 WHERE t1.USER_ID = '' AND t1.USER_ID = t2.USER_ID

Please click back to return to the previous page.

No, it's not bad. Do you have SSH access?

If so, stop MySQL server and run:

myisamchk --silent --force --fast --update-state -O key_buffer=64M -O sort_buffer=64M -O read_buffer=1M -O write_buffer=1M /var/lib/mysql/databasename/ubbt_USERS.MYI

Rob

No no ssh access only forum admin.
you gave me some hope here.. :o)

how can I get this ssh access?

Probably you cannot get any access using SSH if it's no dedicated server.

Maybe this will work:
1) Login to your cPanel
2) Go to the MySQL section, and click the "REPAIR" icon next to your database's name

Rob

You can try the REPAIR option in SQL

The syntax is, as would be expected, REPAIR TABLE tablename[,tablename1...] [options]. This method only works with MyISAM tables.

So login with phpmyadmin and try this option if the first one doesn't work.

Rob

ROB,

Tried to do this
1) Login to your cPanel
2) Go to the MySQL section, and click the "REPAIR" icon next to your database's name


Well I did and go below message


I did contact support, sadly I have not that good experience with that "support" due to prior experience. But they might surprize me hope for that.
Any other clues from you guys???

Thanks
Morgan

BLOODY H*LL it works.............
Maybe the repair button did it after all...
Big thanks and be sur I will monitor it for a while

You're welcome. I hope it keeps working now. I had the same for a while but i run my server dedicated and i'm running a crontab which checks the quality of my databases once in a while and repairs it on the background. But that's only possible if you run your own server or have SSH acces with root rights...

Goodluck with you fully repaired database. Oh, don't forget to back it up once in a while...

Rob

It's just that I have no back up and don't know how to...
Maybe I should be a user instead...;)

hehehe... You have MySQL access, there's a way to backup you complete SQL database with just 5 mouseclicks (Export option)

If you can't find it please let us know, i'll give you some more explaination..

Rob