SQL Error

Nuke Soldier Joined: Apr 23, 2003 Posts: 13

I didn't see a Help catagory here so I will post this here. When viewing my site there is an error at the bottom of the page:

Quote:

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

What causes this and how can I fix it?

My Site Is Here: http://www.painsworld.com

General Joined: Mar 22, 2003 Posts: 5233 Location: USA

Did you read this as advised Wink

http://nukecops.com/postt1.html

Also, search the forums for this. There are many possible solutions.

Nuke Cadet Joined: Apr 30, 2003 Posts: 7

getting warning by each page on top. function fetch_row is fixed according the tips on http://nukecops.com/postt1.html, existing code is:

Quote:

function sql_fetch_array(&$res, $nr=0)
{
global $dbtype;
switch ($dbtype)
{
case "MySQL":
$row = array();
$row = mysql_fetch_array($res);
return $row;
break;;

i'm using phpnuke 6 : http://www.turkijeplein.net
any idea Sad

General Joined: Mar 22, 2003 Posts: 5233 Location: USA

Analyzer link please.

Nuke Cadet Joined: Apr 30, 2003 Posts: 7

http://www.turkijeplein.net/analiz.php
thanx

Nuke Cadet Joined: Apr 30, 2003 Posts: 7

i fixed it:
a table which i made for the block who is where gave error:

Quote:

Can't open file: 'nuke_whoiswhere.MYI'. (errno: 145)

i made the tabel again, so it was solved. I don't know why the table was crashed, but thanx Embarassed