Reoccuring Problem

[Iryder]

I have been having this problem over and over. Anytime users want to get to my forum they get the standard error that something is wrong with the database. I checked the source code and this is what I see

<!-- Database error in vBulletin: Invalid SQL: INSERT INTO session (sessionid,userid,ipaddress,lastactivity,location) VALUES (NULL,240,'66.35.5.114',991678016,'/forums/')
mysql error: Got error -1 from table handler
mysql error number: 1030
Date: Monday 04th of June 2001 02:06:56 PM
Script: /forums/
Referer:
-->

[Mike Sullivan]

That error usually means table corruption.

Try running REPAIR TABLE session; on it.

[Iryder]

How do I repair a table and what is the difference between repair and myisamchk

[Mike Sullivan]

Run this query on it to repair it (assuming the table is a MyISAM table):

REPAIR TABLE session;

Myisamchk has more options and allows you to repair more than one table at once.