hello, my vBulletin bbs mysql database got a problem, I really have no idea how to fix it, any expert who can fix it, I will pay you for doing that. The problem is:

When I open the bbs main page, which is http://bbs.lachinaren.com/main.php it said:

SELECT template,title
FROM template
WHERE (title IN ('forumhome_birthdaybit','error_nopermission','forumhome_pmloggedin','forumhome_welcometext','forumhome_logoutcode','forumhome_newposts','forumhome_to dayposts','forumhome_logincode','forumhome_loggedinuser','forumhome_loggedinusers','forumhome_lastpostby','forumhome_moderator','forumhome_forumbit_le vel1_nopost','forumhome_forumbit_level1_post','forumhome_forumbit_level2_nopost','forumhome_forumbit_level2_post','forumhome','forumhome_unregmessage' ,'gobutton','timezone','username_loggedout','username_loggedin','phpinclude','headinclude','header','footer','forumjumpbit','forumjump','nav_linkoff', 'nav_linkon','navbar','nav_joiner','pagenav','pagenav_curpage','pagenav_firstlink','pagenav_lastlink','pagenav_nextlink','pagenav_pagelink','pagenav_p revlink')
AND (templatesetid=-1 OR templatesetid=1))
OR (title = 'maxloggedin')
OR (title = 'birthdays')
ORDER BY templatesetid
mysql database error: Got error 127 from table handler

Please help me.

Do you have shell access, phpmysql etc?

yes, but still dont know how to fix, can you help? thank you.

Have you tried to repair your tables:

http://dev.mysql.com/doc/mysql/en/Repair.html

Your db should be in /var/lib/mysql/DATABASE_NAME

Look for the directory that matches your db name and replace DATABASE_NAME with the actual path.

Login to shell, cd to the above directory.

/etc/init.d/mysql stop
myisamchk -f *.MYI

Try and see if the problem is fixed.

trying...:)

Oh ya. Remember to start your Mysql after that.

One other thing, have you tried asking over at vbulletin support forum? That would have been the ideal place to ask.