Sudden Errors, Need help pls

[groan]

i get this on my main page at the bottom instead of the menue above the footer.

This was all working fine a few minutes ago, i have changed nothing!!!
www.battlegrounds.groan.ca


2: Supplied argument is not a valid MySQL result resource
(/home/sites/site62/web/BattleGrounds/Sources/BoardIndex.php ln 235)

and this when i click the admin button..
2: Supplied argument is not a valid MySQL result resource
(/home/sites/site62/web/BattleGrounds/Sources/Admin.php ln 73)

[Jeff Lewis]

Your log-clicks table has locked up.  Delete it and recreate it (you don't lose anything - it's a useless feature anyway).

[groan]

Thanks Jeff,
You are a neverending source of answers (and damn quick too!)

ill do that as soon as i get home...
you rock, as always.

[groan]

your suggestion did fix it so i could get back into the admin console, but the footer menue is still broken with this error

2: Supplied argument is not a valid MySQL result resource
(/home/sites/site62/web/BattleGrounds/Sources/BoardIndex.php ln 235)


it probably wont help, but here is line 235...

// load the number of users online right now
   $guests = 0;
   $tmpusers = array();
   $request3 = mysql_query("SELECT identity FROM {$db_prefix}log_online WHERE 1 ORDER BY logTime DESC");
   while ($tmp = mysql_fetch_array($request3))
   {
      $identity = $tmp[0];
      $request4 = mysql_query("SELECT realName FROM {$db_prefix}members WHERE (memberName='$identity') LIMIT 1");
      if (mysql_num_rows($request4) > 0){
         $tmp = mysql_fetch_row($request4);
         $tmpusers[] = "<a href=\"$scripturl?action=viewprofile;user=$identity\">$tmp[0]</a>";
      }
      else
         $guests ++;
   }
   $users = "<font size=1>".implode(", ",$tmpusers)."</font>";
   $numusersonline = sizeof($tmpusers);

   if( $username != 'Guest' ) {
      // deal with instant messages
      $request3 = mysql_query("SELECT COUNT(*) FROM {$db_prefix}instant_messages WHERE (ID_MEMBER_TO=$ID_MEMBER && deletedBy != 1)");
       $temp = mysql_fetch_row($request3);
       $messnum = $temp[0];

[Jeff Lewis]

Well, make sure your log_online table isn't locked up as well.

[groan]

Ugh,
thanks, what causes the table to lock up? any idea?

just got another one.......
this one with looking up a persons profile

2: Supplied argument is not a valid MySQL result resource
(/home/sites/site62/web/BattleGrounds/Sources/Profile.php ln 674)

looking to see if there is a fix now.

***edit
Didnt see a fix to the above error, maybe related? i just checked and yes it says that table is "in use".

will update

[groan]

Seems to have worked.

Ill watch for that in the future..
thanks again Sir Rockalot.