invalid SQL - please help

[beej]

im getting this error on older posts. any idea why?


error:

Database error in vBulletin: Invalid SQL:
SELECT

post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title AS icontitle,icon.iconpath,
attachment.attachmentid,attachment.filename,attach ment.visible AS attachmentvisible,attachment.counter
,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar
FROM
post
LEFT JOIN icon ON icon.iconid=post.iconid
LEFT JOIN user ON user.userid=post.userid
LEFT JOIN userfield ON userfield.userid=user.userid
LEFT JOIN avatar ON avatar.avatarid=user.avatarid LEFT JOIN customavatar ON customavatar.userid=user.userid
LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid


WHERE
post.postid IN (0,777,779,788,793,838,871,922,933,941,978,1092)
ORDER BY dateline


mysql error: Got error -1 from table handler
mysql error number: 1030
Date: Friday 11th of May 2001 02:40:22 AM
Script: /board/showthread.php?threadid=126


if anyone can help that would be great. thanks

[Kier]

This sounds like table corruption... check in the mysql forum for a thread by Eva2000 about how to repair your tables.

[beej]

thanks, i read over that but i don't understand it.
im running myphpadmin and searching this board for help, but so far im at a total loss. im a very inexperience php/mysql user :/ and im not on a dedicated server. there are multiple users accessing mysql.

if anyone can help that would be great.


edit- seems this error is happening on random threads. i contacted my host, they might have answers

[Freddie Bingham]

Ask your host to check your database for corruption. If they don't know how than start looking for another host.

[beej]

well, contacted the host, and they say its a vbulletin problem, cuz they have several people running vb on thier servers and this is the first time they've heard of this problem.

maybe reinstalling it would help ?
any other ideas?

[Chris Schreiber]

Originally posted by beej
mysql error: Got error -1 from table handler
mysql error number: 1030


This error number indictates database corruption. You host needs to run isamchk or myisamchk to repair your database. (And like Freddie says, if they don't know how to do this, you should look for a new host).

[beej]

seems i might be looking for a new host. they're still insisting its a vb error, even after i posted all sorts of references to what the error is and how to fix it.

(big sigh)

i did however manage to get all my errors fixed. first i ran repair.php (a godlike program) and found almost every table was corrupt. Then using phpmyadmin (sp?) i dropped and created each table, and had to copy and paste a tonne of info in. that took forever, but it works now.

today i recieved another funky error, but ran repair.php and everything was hunky dorey after that.


just figured i'd share :)

stoopid host