Web Hosting Talk







View Full Version : Emergency, somebody help


bolinok
09-13-2004, 02:55 AM
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.

sprintserve
09-13-2004, 03:19 AM
Do you have shell access, phpmysql etc?

bolinok
09-13-2004, 03:21 AM
yes, but still dont know how to fix, can you help? thank you.

HostingArt
09-13-2004, 03:23 AM
Have you tried to repair your tables:

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

sprintserve
09-13-2004, 03:26 AM
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.

bolinok
09-13-2004, 03:27 AM
trying...:)

sprintserve
09-13-2004, 03:41 AM
Oh ya. Remember to start your Mysql after that.

poolking
09-13-2004, 05:03 AM
One other thing, have you tried asking over at vbulletin support forum? That would have been the ideal place to ask.