MSQL problem PLEASE help

[donBLACK]

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT wordid,title FROM word WHERE title IN ('test')
mysql error: Can't open file: 'word.MYD'. (errno: 145)

mysql error number: 1016

Date: Monday 02nd of February 2004 07:16:01 AM
Script: http://lyricalwarfare.plebia.net/forum/newreply.php
Referer: http://lyricalwarfare.plebia.net/for...p?threadid=191


that is what it says aafter i post on my board....and then i refresh then the post is there but on the forum front page it doesnt say it was posted.....

[Steve Machol]

Originally Posted by donBLACK

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT wordid,title FROM word WHERE title IN ('test')
mysql error: Can't open file: 'word.MYD'. (errno: 145)

mysql error number: 1016

Date: Monday 02nd of February 2004 07:16:01 AM
Script: http://lyricalwarfare.plebia.net/forum/newreply.php
Referer: http://lyricalwarfare.plebia.net/for...p?threadid=191


that is what it says aafter i post on my board....and then i refresh then the post is there but on the forum front page it doesnt say it was posted.....

Your word table is corrupted. Run this query to fix it:

REPAIR TABLE word;

Or-

Upload repair.php (it's in the 'extras' folder of the zip file) to your admin directory. Close your forums, then run it from your browser with this syntax:

http://www.yourdomain.com/forum/admin/repair.php?html=1&check=1

[Of course change the exact URL as appropriate for your forums.]

If everything reports 'Ok' then reopen your forums. If not, then run it again. The second time everything should report Ok (except the session table which you can ignore.)

[donBLACK]

i dont have the zip file anymore i have gotten a new comp since then......and im not sure how to run queries...do u think you could give me the php file on here

[g-force2k2]

Originally Posted by donBLACK

i dont have the zip file anymore i have gotten a new comp since then......and im not sure how to run queries...do u think you could give me the php file on here

You can redownload the file from the members area at vbulletin.com

Regards,
g-force2k2

[donBLACK]

how and where do i run a query...cause i dont want to go hunt for my vb.com number and stuff

[g-force2k2]

Originally Posted by donBLACK

how and where do i run a query...cause i dont want to go hunt for my vb.com number and stuff

You don't have to run the query, there was an alternative, just follow Steve's instructions for the entering your own url and it should repair it for you.

Regards,
g-force2k2

[donBLACK]

i dont have the repair.php file....and vbulletin.com ask me for my number and i dont beleve i have that anymore never really used it....im new at this stuff sorry if im irritating

[g-force2k2]

Originally Posted by donBLACK

i dont have the repair.php file....and vbulletin.com ask me for my number and i dont beleve i have that anymore never really used it....im new at this stuff sorry if im irritating

No you're not irritating, but I don't think I can really give you the repair.php file, if you do know what email address you bought vbulletin with you can enter that and they will send you your license number and password. Or you can contact support@vbulletin.com directly and see if they can send you it, because you aren't showing up as unlicensed, or atleast I don't think so.

Cheers,
g-force2k2

[donBLACK]

i did that and i entered the number but it tells me its wrong???