admin error

[Iago]

Board has been working fine for a few months now, but about two days ago I started getting the following error:
2: Supplied argument is not a valid MySQL result resource
(/home/virtual/site195/fst/var/www/html/yabbse/Sources/Admin.php ln 81)
any ideas?
Thanks

[Jeff Lewis]

Check in your phpmyadmin if yu have it.  Check the log_clicks table to see if it says in use.  if it does, lets fix it

[Iago]

Thanks for the response. I'll look into this later and see what sort of tools are on the site....this is a clan site, and I haven't spent much time wandering around the admin section...just installed the board, etc. I'll be back this evening to let you know what I found.
Thanks again.

[Iago]

Hello again.
When I click that table, I get the following error:
Can't open file: 'yabbse_log_clicks.MYD'. (errno: 145).
Any ideas?
Thanks.

[Iago]

oopsy..was looking in the wrong spot.
Yes, it says it's in use.

[Jeff Lewis]

Well if you have phpmyadmin try typing this into the command box:

REPAIR table yabbse_log_clicks

[Iago]

The only place I could find to enter a command gave the following error:
You have an error in your SQL syntax near 'REPAIR table yabbse_log_clicks' at line 2
(this from the Run SQL query/queries  box in phpmyadmin)

[Jeff Lewis]

Try different ways, I haven't run it before:

REPAIR table 'yabbse_log_clicks';
REPAIR table `yabbse_log_clicks`;

Try those...

[Iago]

Yep, I played with the syntax a bunch the first time through (following the example of the other line in the query window). And just to be safe, went back in and entered those again...still get the same error about syntax. It has an empty option...should I just empty it?
If it is, as the name implies, just a log, would that hurt anything?

[Iago]

If you'd like to take a gander at it yourself, I'd be happy to send you the information to get into the php stuff...just to make sure my n00bness isn't contributing to the syntax error. just email me at [email protected]

[Jeff Lewis]

Sure, IM me or email me your phpmyadmin login info.  The table just needs to be repaired...

[Iago]

Emailed the info. Did you receive it?
No pressure...=) just wanted to make sure you got it.

[Jeff Lewis]

Actually I DID get it but wasn't sure what the issue was  I get lots of emails and forget what the issue is with some boards  So I'll check when i get home again or IM me the info, it's a very quick fix.

[Jeff Lewis]

Ok fixed, all that was needed was to run this command in phpmyadmin:

repair table yabbse_log_clicks;

And it's better