PDA

View Full Version : invalid SQL - please help


beej
Fri 11th May '01, 2:56am
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
Fri 11th May '01, 2:59am
This sounds like table corruption... check in the mysql forum for a thread by Eva2000 about how to repair your tables.

beej
Fri 11th May '01, 5:06am
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
Fri 11th May '01, 10:55am
Ask your host to check your database for corruption. If they don't know how than start looking for another host.

beej
Fri 11th May '01, 8:00pm
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
Sat 12th May '01, 12:15am
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
Mon 14th May '01, 2:25pm
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