Deleted user brought down the house?

[plowking]

I know it's cliched, but, HELP!

www.phantomcitizen.net/community using 1.4.1
I deleted a user for the first time tonight, and after that, the board will not let ANYONE login. The errors it's giving (above the home page after login are:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /www/p/pcitizen/htdocs/community/Sources/Subs.php on line 140

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /www/p/pcitizen/htdocs/community/Sources/Subs.php on line 143

I've tried a couple of accounts, Admin and not admin, and nothing is working. The page then shows our logo, then says "Hello User, you have messages are new"

and below that, the error text:
2: mysql_fetch_row(): supplied argument is not a valid MySQL result resource
(/www/p/pcitizen/htdocs/community/Sources/Subs.php ln 140)

I have nothing but the default install plus the security patch from a few weeks ago.

My brand new and very active forum needs you, obi wan kenobi!
---PK

[plowking]

Oh, I should add, Guest users can browse ok. but it's when people try to login that nothing works!

[Gobalopper]

What is on those lines in Subs.php? btw, now might be a good time to upgrade to 1.5.1!

[plowking]

I would if I could upgrade, but I was worried about losing my custom template, and right now I just need to get it back up!

Those lines in the subs.php file are all related to the instant message display function.

Code Select Expand


137    }
138    if($username != "Guest") {
139       $request = mysql_query("SELECT COUNT(*) FROM {$db_prefix}instant_messages WHERE (toName='$username' && deletedBy!=1)");
140       $temp = mysql_fetch_row($request);
141       $mnum = $temp[0];
142       $requestred = mysql_query("SELECT COUNT(*) FROM {$db_prefix}instant_messages WHERE (toName='$username' && readBy!=1 && deletedBy!=1)");
143       $temp2 = mysql_fetch_row($requestred);
144       $munred = $temp2[0];
145       if ($munred == "1") { $isare = $txt[newmessages0]; }
146       else { $isare = $txt[newmessages1]; }
147       if($mnum == "1") { $yyim = "$txt[152] <a href=\"$cgi;action=im\">$mnum $txt[471]</a>$txt[newmessages4] $munred $isare $txt[newmessages2]."; }
148       else { $yyim = "$txt[152] <a href=\"$cgi;action=im\">$mnum $txt[153]</a>$txt[newmessages4] $munred $isare $txt[newmessages2]."; }
149       if($maintenance) { $yyim .= "<BR><B>$txt[616]</B>"; }
150    }


[Gobalopper]

Do you have phpMyAdmin installed? You could try running:

REPAIR TABLE yabbse_instant_messages;

[plowking]

I do and I did.
and it worked!
Thanks so much!!!

Now...how hard is that upgrade? will I lose my custom template? (the one I adjusted in the admin section...nothing TOO custom.)

So happy I may buy a yabbSE teddy bear.
but who would I give it to?
---PK

[Gobalopper]

You shouldn't loose it but I would backup your Settings.php file and template.php just in case.

[plowking]

and my databases will be fine?
::apprehensive::

[[Unknown]]

and my databases will be fine?
::apprehensive::

If you are worried, make a backup.

By now, 1.5.1 is pretty stable.  I really anticipate releasing the final soon.

-[Unknown]