mysql_fetch_row error in sql_layer.php file

Worker Joined: Aug 28, 2003 Posts: 227

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

Line 286 is the "$row = mysql_fetch_row($res);" command below in the case "MySQL'; area.

And I have done anything to the tables. At least on purpose. Wink

Any suggestions on what to check?

Quote:

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;;

Posted: Thu Dec 04, 2003 12:34 am

I think this link might help you!!
http://www.nukecops.com/postlite518-sqllayer+php+line+286.html

Posted: Thu Dec 04, 2003 8:11 pm

I can never find anything on nukecops. maybe I'm being too complicated on my query.

It does look like 'uid" got in the footer file. How is the big question.

And now I can't remember where I read that I should look in the footer file.

SHEESH!
Smile

Posted: Thu Dec 04, 2003 9:05 pm

the search function on nukecops and probably others doesn't work too well.
use google like this:

site:nukecops.com stuff your looking for
or
site:nukecops.com "stuff your looking for"

depending on what you're looking for.

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

BigDaddyEBK wrote:

I think this link might help you!!

While I appreciate your willingness to help. NC is a great resource, but there are reasons why other help sites exist. Instead of redirecting people, please just post the solution in your own words.

Posted: Fri Dec 05, 2003 12:22 am

paranor wrote:

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

Line 286 is the "$row = mysql_fetch_row($res);" command below in the case "MySQL'; area.

And I have done anything to the tables. At least on purpose. Wink

Any suggestions on what to check?

Quote:

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;;

Turn sql_debug to ON in sql_layer.php. Then you will find the source sql that is the problem. uid and uname are usually the issues and renaming them to user_id and username will clear up most problems.

Posted: Fri Dec 05, 2003 6:48 am

I understood what to do via the nukecops site.

I checked out the footer.php and it looked like it was running a check on if you have private messages or not. My guess it would display it at the bottom of your browser - like your site. I copied back the footer.php I was using and all is well.