Still getting this error

christian · **Still getting this error -** 03-31-2003, 06:07 PM

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

I have gone through and disable and re-enables all modules and blocks, and nothing has gotten rid of this error, it is starting to piss me off, i may just delete the whole site and run a new fresh install 6.5

mikem · 03-31-2003, 07:56 PM

hey christian, can you turn on debugging? It will help you diagnose that error a little more.

Here's how

Open includes/sql_layer.php go to line 300(approximately) and change:
code:

Code:

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

to

Code:

case "MySQL": 
if ($row = mysql_fetch_row($res)) { 
return $row; 
} else { 
print (mysql_error()); 
} 
break;;

mikem

ads · 03-31-2003, 09:18 PM

have you made any changes to the database receantly? Does this happen when you do something specific in your site?

christian · **8( -** 04-02-2003, 11:02 AM

ok, i have replaced that line, and nothing has changed, how do i know what the troubleshooting has found out???

www.somewhatlucky.com

chatserv · 04-02-2003, 11:21 AM

If you are running nuke 6.5 something is not right with your sql_layer.php file as line 253 is
case "ODBC":

this should not have any effect on your site if you use MySQL

mikem · 04-02-2003, 11:36 AM

Quote:

Originally Posted by chatserv

If you are running nuke 6.5 something is not right with your sql_layer.php file as line 253 is
case "ODBC":

this should not have any effect on your site if you use MySQL

nah he's still running 6.0 with Toms' port.

mikem

chatserv · 04-02-2003, 11:51 AM

Ok, then, he should change lines 252-255 in sql_layer.php from:

Code:

    case "MySQL":
        $rows=mysql_num_rows($res);
        return $rows;
    break;;

to:

Code:

    case "MySQL":
        if ($rows=mysql_num_rows($res)) {
        return $rows;
        } else {
        print (mysql_error());
        }
        break;;

mikem · 04-02-2003, 11:53 AM

lol..ok..get out of the barn chatserv...he already did that too..look 3 or 4 posts up...You need some coffee.... 8O

mikem

chatserv · 04-02-2003, 12:03 PM

Quote:

Originally Posted by mikem

lol..ok..get out of the barn chatserv...he already did that too..look 3 or 4 posts up...You need some coffee.... 8O

mikem

I don't like coffee so i'll do pepsi instead and maybe share some with you, what i may need are new glasses as i thought the code in the other post was meant for lines 300-303 and not for the ones i mentioned 8O

Now regarding the barn, i am out, i am getting a laptop so i can share with my sheep in the open. :twisted:

mikem · 04-02-2003, 12:59 PM

Ahh I see..maybe I need to glasses. Yours was for numrows...

mikem