How would I fix this?

[Tiigeress]

Minding my own business double checking links etc and all of a sudden I see this error at the bottom of my forums 🙁

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource

includes/sql_layer.php on line 286

layer.php (rows 279-326):

function sql_fetch_row(&$res, $nr=0)
{
global $dbtype;
switch ($dbtype) {

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

case "mSQL":
    $row = msql_fetch_row($res);
    return $row;
break;;

case "postgres":
case "postgres_local":
if ( $res->get_total_rows() > $res->get_fetched_rows() ) {
	$row = pg_fetch_row($res->get_result(), $res->get_fetched_rows() );
	$res->increment_fetched_rows();
	return $row;
} else {
	return false;
}
break;;

case "ODBC":
case "ODBC_Adabas":
    $row = array();
    $cols = odbc_fetch_into($res, $nr, $row);
    return $row;
break;;

case "Interbase":
    $row = ibase_fetch_row($res);
    return $row;
break;;

case "Sybase":
    $row = sybase_fetch_row($res);
    return $row;
break;;

default:
break;;
}
}

[TheIceman5]

$res is probably null causing mysql_fetch_row to spit the dummy.

[Tiigeress]

thanks for the quick reply 🙂

what would i do to fix it? or, where would I go to learn how to fix it? I have been searching different forums for awhile now and cannot find the answer or even a hint to this anywhere.

i've tried commenting it out, it works but removes the "frames", tried adding if and else, and some other things and they all return a blank screen. I'm way out of my league here :/

vars...

class ResultSet {
	var $result;
	var $total_rows;
	var $fetched_rows;

function set_result( $res ) {
	$this->result = $res;
}

function get_result() {
	return $this->result;
}

function set_total_rows( $rows ) {
	$this->total_rows = $rows;
}

function get_total_rows() {
	return $this->total_rows;
}

function set_fetched_rows( $rows ) {
	$this->fetched_rows = $rows;
}

function get_fetched_rows() {
	return $this->fetched_rows;
}

function increment_fetched_rows() {
	$this->fetched_rows = $this->fetched_rows + 1;
}
}

[tekky]

the problem wont be in the function you pasted

the problem will be in the last line of code that called that function....

find that and you'll be more inclined to finding the error 😉