mysql_fetch_row() error

Posted: Sun May 11, 2003 11:38 pm

I have downloaded a module called clanbase and installed it on my phpnuke 6.5 RC3.02 site. http://www1.enemyoffline.com/modules.php?name=Clanbase

The module seems to work, however I think its created for phpnuke 6.0 and therefore I need some help here to reconfigure something.
I do get an error message.

Error message:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/www/www.enemyoffline.com/html/includes/sql_layer.php on line 286

This is line 286:

Code:

$row = mysql_fetch_row($res);

Is it possible to alter the module so that it works with 6.5 Question

Joined: Jan 31, 2004 Posts: -88

yes, and if you read around the forums, you'll find out how.

AI

Posted: Mon May 12, 2003 3:36 am

believe me, I've tried...

Posted: Mon May 12, 2003 4:11 am

I only find the:

$row = mysql_fetch_row($res) and change it into
$row = mysql_fetchrow($res);

And if I do that my login block gets this error:

Code:

Fatal error: Call to undefined function: mysql_fetchrow() in /home/www/www.enemyoffline.com/html/includes/sql_layer.php on line 286

Posted: Mon May 12, 2003 4:22 am

Now I tried the Debug=1 thing mentioned in announcement:
One more line where added in my error message:

and the

Code:

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

was also entered into line 300

Code:

SQL query: select uid from nuke_users where uname='JallaBalla[EO]'

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/www/www.enemyoffline.com/html/includes/sql_layer.php on line 286
Unknown column 'uid' in 'field list'

Does this you something more, AI? Embarassed

(sry....

)

Joined: Jan 31, 2004 Posts: -88

the line in sql_layer.php should say mysql_fetch_row($res);

the line you need to change is in whatever file that's causing the error in sql_layer.php. Find the module / block that's causing the error, and change all references of uid to user_id for a start, and uname to username for seconds.

AI

Posted: Mon May 12, 2003 4:52 am

I changed the 'uname' and 'uid' in the index.php of the module and it worked.... Thanx A LOT, AI! Very Happy