slight problem with the database...

[jeeperosstaff]

I woke up this morning and found that my forums give this error:

-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
There seems to have been a slight problem with the Jeeperos.com database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------

and from the source I get:


-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
<!-- Database error in vBulletin 2.2.8:

Invalid SQL: SELECT user.*,userfield.* FROM user LEFT JOIN userfield ON userfield.userid=user.userid WHERE user.userid='1'
mysql error: Can't open file: 'user.MYD'. (errno: 145)

mysql error number: 1016

Date: Friday 24th of January 2003 09:28:02 AM
Script: http://www.jeeperos.com/foros/foros/
Referer:
-->
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------

Any help will be appreciated, I have no clue whats going on. Also tried to get into the /admin and wouldnt let me, gives the same error.

thanks a lot!!

[George L]

you have a corrupted table, you need to repair it via one of the following methods
===================
1. via phpmyadmin

using query

REPAIR TABLE user;

2. or using mysqlcheck repair for 3.23.38 and above

i.e. in shell/telnet/ssh type while mysql is running and forum is CLOSED:

mysqlcheck -r -u mysqlusername -p databasename

3. or via myisamchk repair functions while mysql is shutdown/stopped in shell/telnet/ssh type :

myisamchk -r -u root -p databasename

option #3 most likely requires server and mysql root access to first stop mysql and then run myisamchk repair options.

[jeeperosstaff]

WOW thanks a lot for the fast answer Eva2000,

Do you know if there is a manual for Dumbs on "HOW TO" do any of those? I dont have a clue how to use mysql or any other tool you mentioned before. Or know anyone who would do it for me? (even if I have to pay for it)

again thanks a lot!

[jeeperosstaff]

BTW I have phpmyadmin and can log in, so if you could tell me a few steps on how to do it maybe I can tackle it?

thanks again!!

[jeeperosstaff]

In the Querry space on phpMyAdmin I found this:


---------------------------------------------------------
SQL-query :

PMA_mysql_list_fields(

vbulletin, user
)

MySQL said:


Can't open file: 'user.MYD'. (errno: 145)
---------------------------------------------------------

My database is : vbulletin

So I just go to the

Run SQL query/queries on database vbulletin [Documentation] :

Square and type: REPAIR TABLE vbulletin

is that right?

thanks a lot!!
"

[George L]

run query box type

REPAIR TABLE user;

[jeeperosstaff]

WOW! that did it!!


thanks a lot!! I really mean it, you made my weekend!

[George L]

no probs