help please.. urgent

[khaleejy]

hi

everything was going ok in my website.. sudenly im getting many difrent errors.. and i dont know the reason!! i mean i didnt modify any file or install any hack!!

the errors:
Database error in vBulletin 2.2.8:

Invalid SQL: SELECT COUNT(*) AS threads FROM thread

WHERE thread.visible=1 AND 1=1 AND thread.lastpost>=1035581111 AND thread.open<>10
mysql error: Got error 127 from table handler

mysql error number: 1030

Date: Friday 25th of October 2002 02:55:54 PM
Script: http://www.khaleejy.com/f/f/search.p...&searchid=1798
Referer:


if you notice the script url is khaleejy.com/f/f .. this is wronge!! my forum url should be khaleejy.com/f only not khaleejy.com/f/f
any one know why there is two /f???

im getting hunderds difrent email msgs such as this:
Database error in vBulletin 2.2.8:

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,customavatar.dateline AS avatardateline
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,4776,4892,6272,6381,6616,7009,15519,15585,15594 ,16057,16183,18331,20958,20975,22162)
ORDER BY dateline

mysql error: Got error 127 from table handler

mysql error number: 1030

Date: Friday 25th of October 2002 02:46:31 PM
Script: http://www.khaleejy.com/f/f/showthre...0958#post20958
Referer: http://207.68.164.250/cgi-bin/linkrd...goto%3dnewpost
.


please help

[N9ne]

For the URL, in your adminCP, make sure in the vBulletin Settings you have the right URL for the board...

[NTLDR]

Looks like your DB may be corupt. Upload repair.php to your admin directory and run it.

[khaleejy]

i have uploaded the reasult to: www.khaleejy.com/result.html
can you take a look and tell me what should i do?? please

[Logician]

try running these 2 queries in your PHPmyAdmin

repair table;

repair user;

If it does not cure, you should consider restoring your MYSQL db with a recent backup

[khaleejy]

thank you all.. everything is ok now BUT after i repair the database .. some user have been removed!! i dont know how
he became not registered member
but he was a registered member before i repait the database
i can see nothing on his posts except his nickname and there is no user id, pm, profile,..
anyone know how can i solve this??

[Erwin]

Unless you have a backup of your user table, the data is gone. The user will have to re-register.

[Chris M]

Do you by any chance remember his userid or any other info?

Satan

[khaleejy]

i dont remember his userid but i know his email address, profilefeilds

hellsatan can i return his posts to him????