Please help!!!!

[Jason Black]

Click this link
www.rapfeinds.com

It says
Database error
The www.Rapfeinds.com database has encountered a problem.

--------------------------------------------------------------------------------

Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the rapfeinds.com home page, then try to open another page.
Click the Back button to try another link.

The rapfeinds.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

i have no idea what that is

[Paul M]

MySQL Error : Table './rapfeind_sitemagixprod/user' is marked as crashed and should be repaired

You need to repair your user table - you will need to do that via phpmyadmin.

[Jason Black]

it doesn't say that though

[SCRIPT3R]

it doesn't say that though
try unplugging the server then... actually, it DOES say that. you asked for help and you got it, why not just try doing what he suggested?


<!--
Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT * FROM user FORCE INDEX (lastactivity)
WHERE lastactivity &gt; 1192600800 ORDER BY username;

MySQL Error : Table './rapfeind_sitemagixprod/user' is marked as crashed and should be repaired
Error Number : 145
Date : Wednesday, October 17th 2007 @ 02:18:33 PM
Script : http://www.rapfeinds.com/
Referrer : https://vborg.vbsupport.ru/showthread.php?p=1362537
IP Address : ...
Username : Unregistered
Classname : vB_Database
-->

[Jason Black]

nah the only reason why i said that is because i don't know how to do it lol....i was hoping he could tell me how to get there. i mean, i know how to get the phpmyadmin, but where do i go afterwards

[SCRIPT3R]

oh... from myadmin, just bring up your database in question, select that table or tables in question, and you should see a drop-down menu to fix and repair tables. do that.

[Jason Black]

thank you guys...i appreciate the help, now it works

[wally]

Does anyone know the command line for this ?? (i dont have a phpadmin)

[Lynne]

You can repair/optimize in your Admin CP also.

A couple of useful links:
http://www.vbulletin.com/docs/html/main/maintenance_repair_tables
http://dev.mysql.com/doc/refman/5.0/en/table-maintenance-sql.html

[snakes1100]

Does anyone know the command line for this ?? (i dont have a phpadmin)

What type of shell access do you have and is this a dedicated/vps/vhost server?

If you have a dedicated/vps server, you can do the following:

1. cd to database folder or type the entire path into the command

typical install of mysql: cd /var/lib/mysql/dbnamehere
myisamchk -r *
myisamchk -o *
myisamchk -r /path/to/db/folder/ *
myisamchk -o /path/to/db/folder/ *

myisamchk --help (will list the switches and their meanings)

2. on a vhost server with improper permissions, you wont be able to run those commands, so i will not get into that.

[wally]

ok thx i managed to fix it to go into mysqladmin and repaired my post table there thx this is handy for future reference