MYSQL phpnuke 6.0 error.

ryan1918 · **MYSQL phpnuke 6.0 error. -** 07-01-2003, 04:38 PM

I keep getting these errors and i cannot figure out how too fix em,
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/ryan/public_html2/php/includes/sql_layer.php on line 253
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/ryan/public_html2/php/includes/sql_layer.php on line 301

If you would please help me thanks.

IACOJ · 07-01-2003, 08:40 PM

You might want to change your title so people know you have an sql error, you might get more help that way. Anyway....

Is this a new install, have you just added a new block or module etc? Did you just try to modify some existing code somewhere? Anything like that?

Where does the error show up? Header, footer, all over the page, only in certain pages etc.

Also can you turn debugging on? 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;;

ryan1918 · **ok -** 07-02-2003, 01:46 AM

It's not a new install, or modules or anything like that... i just posted something one day and got all these errors and its in my downloads, main and a few other sections.... heres what i get when i changed them, i had too change line 304 because the other one didnt do anything.

Warning: head(themes//theme.php) [function.head]: failed to create stream: No such file or directory in /home/ryan/public_html2/php/header.php on line 31

Warning: head() [function.head]: Failed opening 'themes//theme.php' for inclusion (include_path='') in /home/ryan/public_html2/php/header.php on line 31

Fatal error: Call to undefined function: themeheader() in /home/ryan/public_html2/php/header.php on line 47

IACOJ · 07-02-2003, 05:17 AM

What theme are you using? I doubt that it is a theme issue but it might be. You also might want to download a copy of your html file where you get the error, and check to see if there are any more errors that have been inserted in the html coding, sometimes that happens instead of the error being displayed.

Turning debugging on for the other lines didn't do anything? Hmmm... that is where it should be turned on for sql layers.

You are using 6.0 right? None of your blocks or anything else is for 6.5 or higher?

When you say that you posted something, you posted it where exactly?

Any chance you can either post a link or send it to me in PM so I can see the error and where it is displayed on the page please.