Center Forum Block getting mysql_fetch_rows() warning

Nuke Cadet Joined: Aug 05, 2005 Posts: 2

I have Nuke 7.6 running (just installed). I haven't used 7.6 yet the last I had was 6.5.

Well I cannot find the updated Center Forum Block for 7.6 (i have a hard time finding anything for Nuke since everything is so spread all over for different versions of nuke, etc).

So after exhausting hours of searching for the updated Center forums Block (non scrolling). I went ahead an used the 6.5b6+ version. It works, except it is giving me the following warnings:

Code:

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

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/xfactorl/public_html/includes/sql_layer.php on line 286

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/xfactorl/public_html/includes/sql_layer.php on line 286

That appears above the block output that does render below.

The site it is on is the follwing:

http://www.xfactorleagues.com/index.php

The site used to be an all phpnuke site, but then I tried Xoops for a bit and now am ready to switch back and start anew. All I need to finish off this site (before the design anyway) is to get the Recent Forum Posts Center Block working...

Thanks for your help,

Brad

Nuke Cadet Joined: Aug 05, 2005 Posts: 2

Well after doing another full day of research I finally found the piece of code that helped me break this wide open....

Code:

case "MySQL":
if ( $row = mysql_fetch_row($res)) {
return $row;

That was the area in the sql_layer.php file where there was an issue. It was giving me a generic warning.

so I added the following:

Code:

} else {
print (mysql_error());
}
break;;

This basically gave me a specific error message. That is when I found that it was the user table prefix that was messed up. It was reading the regular prefix and not my user prefix (different for multiple nuke installs).

So after changing the $prefix_ to the user prefix variable, I was good and the problem is solved.