MySQL Error!

[cortese21]

Keep getting this error.Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource
in /www/?/????/htdocs/PhPnuke/html/includes/sql_layer.php on line 301

Can someone explain exactly what this means and what to look for....

Thanks in advance
Joe!~:(

[newcomer]

As i see you are trying to set up PHPNUKE on your powweb account and its just a one of the error you get when you install that web portal so what I will suggest that go ahead and read powweb's tutorial on " how to install phpnuke on powweb's server" and see if that works for you. Just follow the link below and read the tutorial.

http://help.powweb.com/tutorials/mysql/phpnuke.php

[cortese21]

I will check it out. But I did not have this error BEFORE the outage today on PULSAR!!

Thanks

[newcomer]

well I won't say that as my site is running on pulsar.powweb.com and its not giving me any problem at all till now. I have phpnuke portal also so I don't think its server problem.

[cortese21]

Sill having this problem.... I deactivated BLOCKS trying to get rid of this but without success. Please look at my site and see if you can tell me anyhing from that..

Again... I did not have this problem this morning.. I will say however that when I was trying to add the GROUPS Block I had this problem, so off course I deactivated it until I can figure this out..

Thanks
Joe

My site ====>>>> eSportsZone.net (http://www.esportszone.net/phpnuke/html/index.php):( :(

[newcomer]

Please provide some information that what version of phpnuke you are using so I can look at it. But you can also post your problem on their forum as all members are using PHPNUKE over there so it will be faster response.

Here is the link..

http://www.nukeforums.com/

[cortese21]

using ver6.0

[cortese21]

got it!! Thanks for all the help!!

[newcomer]

Good to hear that my friend.

Could you post what was the resolution so we can refer this thread to new members with the same problem?

I will appreciate...

[cortese21]

I changed a line in the SQL_LAYER.sql file under INCLUDES as follows:

This means there is a problem executing a particular sql_query.

To get a more descriptive error message, you can edit the "case" lines in the sql_layer.php.

Code:FROM
--------------------------------------------------------------------------------

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


--------------------------------------------------------------------------------


Edit it like this:
Code:
--------------------------------------------------------------------------------

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

This than abled me to determine that the script I was trying to install DID NOT creat Tables in mysql. So I went in manually and created them and WHOA!!!

It works. So I would say the above fix will point you in the right direction...

Take it from me I am new to this and I was able to understand it so I would think most people could also..

Thanks
again!