help please.. urgent
 

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

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

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

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

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

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??

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

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

Satan

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

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