Help! Cannot access my board. No one can...

[campingdad]

I posted this once elsewhere but I think I was in the wrong forum....

 Hi,
  I am perplexed. Easily done btw I cannot access my board this evening. Everytime I try I get the following warning:
Warning: Supplied argument is not a valid MySQL result resource in /usr/local/plesk/apache/vhosts/northeastonlinewheelers.org/httpdocs/yabbse/Sources/Subs.php on line 156

and the following error:
2: Supplied argument is not a valid MySQL result resource
(/usr/local/plesk/apache/vhosts/northeastonlinewheelers.org/httpdocs/yabbse/Sources/Admin.php ln 69)


Now both of these refer to :

$temp = mysql_fetch_row($request);

PLEASE, any help would be greatly appreciated. I am woefully MySQL ignorant...

My host has left me high and dry on this. If anyone can help me out here it would be greatly appreciated. My users are about to tar and feather me.

...and Happy Easter!

[campingdad]

Note: I am running 1.0.0 .   I have an instance of 1.1.0 that IS still working. That  may help in the dignosys I think.

Thanks

[Jeff Lewis]

Actually, that isn't the line causing the error, that is the line it dies on.  Post the line that may be a couple above but it contains the actual query (mysql_query).  That is where the error lies.

To get the actual error yourself, add this right after that mysql_query line:

echo "Error: ".mysql_error();

[campingdad]

Found the error.

Error: Can't open file: 'yabbse_messages.MYD'. (errno: 145)

Any ideas?

Thanks!

[campingdad]

I know next to nithing about phpMyAdmin but this is what I get when I click on the messages table...

Error

SQL-query :

SHOW KEYS FROM `yabbse_messages`

MySQL said:

Can't open file: 'yabbse_messages.MYD'. (errno: 145)

[campingdad]

This may help as well... When I look at the whole database and all the tables, the row with the messages table looks like this:

  yabbse_messages      Browse     Select     Insert     Properties     Drop     Empty    in use

It is the only row that has "in use" as the TYPE. ***Correction*** That table and instant_messages both say "In Use" the rest say MyISAM as TYPE.

Am I screwed here???

Thanks

[Jeff Lewis]

Oh oh not good...I still haven't been able to find out how to unlock these tables.  Even posted a message to both the PHP and mySQL mailing lists but got no response...

[campingdad]

Thanks!   Very reassuring.  

I have a ticket open with my hosting company to see if they can do something but that seems to be like throwing talcum powder into a fan when it comes to things like this.

Judging from a response you gave to a similar problem I saw in a search, I may end up deleting and rebuilding these tables. Is that a correct statement?

IF that is the only option, can you tell me how to do that?

I am gonna catch holy hell for this.    

[campingdad]

Any thoughts??? Ideas???

My hosting company has my ticket on hold waiting for a sysadmin to take a look at it. To be quite honest I don't hold out much hope for that avenue. In the mean time, the natives are getting restless......

[campingdad]

Well it looks like I really am screwed. According to my host, (as well as you folks, indirectly) it is becoming increasingly clear that the files in question...

ALL MY MESSAGES and ALL MY INSTANT MESSAGES have been corrupted! The files are junk. That is not a good thing at all. VERY big bummer. I hope you folks are looking into that little bug pretty heavily. It doesn't bode well. Maybe ver 1.3

In the meantime, can someone PLEASE tell me how to delete and rebuild the tables in question. I would really appreciate it.

Thanks.

[andrea]

With phpMyAdmin you can try to export the data to your local pc. If this works, you can initialize the db and re-import the data.

[campingdad]

I'm pretty phpMyAdmin illiterate but I don't think that will work for the tables in question. I cannot even access them at all. They are completely locked.

But I appreciate the help. Can you tell me how to go about doing that. I don't remember seeing an export function.

Shane

*Update- I think I figured out how to at least download the data/structure as you mentioned. However, as I suspecte, it didn't work.

Anything else?

Thanks

[campingdad]

This may help someone who is smarter than I.

http://www.phpbuilder.com/forum/read.php3?num=5&id=7937&loc=0&thread=7937

Shane

[Jeff Lewis]

Thanks for the link!  Gives me soemthing to go on!!

Interesting that nobody on either the PHP or the mySQL mailing lists offered any help with that error...

[campingdad]

Hey Jeff, you owe me man. The above worked like a charm!  

All you need to do when this locking occurs is go to MySQL and type in the following...

REPAIR TABLE yabbse_imessages; or whatever table nees to be fixed.

Phewwww.....that was close!

I appreciate you guys' help anyways.

Shane