Code:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/elite/public_html/includes/sql_layer.php on line 238

can someone please help me out on how to fix this problem

i recive this error message above the news module on the home page

http://www.elite-fusion.com

Disable your buddy block and see if that fixes it.

Also if you haven't done so already apply secfix3 to your site. You have other errors showing up in other pages of your site, calling to some of the files that were changed fixed in secfix3.

where can i get the secfix3 error fix thing your talking about???

http://www.nukeresources.com
or
http://www.nukecops.com

http://nukecops.com/downloads-file-7...c_Patch_3.html

You might want to get analyzer etc from Nukecops too.

oh SH*T it worked
wat did it do to the site that it made it work?????

and also when i ran the updateforum.php it messed up my forum
can u please tell me how to get it back

That buddy block wont work with 6.5 by disabling it, it prevents calling for invalid sql so you don't get the errors displayed anymore.

Still install the secfix though.

what do you mean it messed up your forum?

Edit:
I just made a test post on your forum, and it seems to work fine. I don't show any errors.

my forum used to look like my nuke theme and now it looks like regular subsilver

oh ok, Are you using an actual nuke 6.5 theme? Or you were using a 6.0 theme?

The way they are called is different in 6.5.

Edit: I Just tried to register on your site and it gave me an error. Didn't say what kind of error, something is missing in your lang file.