Warning: mysql_fetch_row(): supplied argument is not a valid

chris

A tip of the hat to Humpa for this one:

Question

Problem: You get this

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

Idea

Idea: to find a solution: Try first to get a more descriptive error message. For this purpose, you must edit the "case" lines in the sql_layer.php.

Example:This is the "case" that starts at line 286 in the nuke 6.5 sql_layer.php (for the line 286 error), at line 300 in the nuke 6.0 sql_layer.php (for the line 301 error message)
- or line 285 in nuke 5.6 (for the line 286 error message):

timbro · Private Joined: 11 Mar 2004 Posts: 1

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/virtual/site68/fst/var/www/html/testnuke/html/includes/sql_layer.php on line 301
Unknown column 'position' in 'where clause'

chris · Posted: Mon Mar 15, 2004 11:17 am Post subject:

Yes, timbro, yours is an example of such a problem. Now you know that at some place you are asking for a column with the name "position", but that column does not exist in the table.

Conclusion: you are using an incompatible module or block. Make sure that the modules and blocks you are using are compatible with the version of your PHP-Nuke. If you upgraded PHP-Nuke, make sure that you upgraded correctly and did not miss anything.
_________________
Regards

Chris Karakas
www.karakas-online.de

stafo · Private Joined: 26 Mar 2004 Posts: 2

My error says:

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

I did a clean install using nukesql both latest versions.

JonStarbuck · Private Joined: 26 Mar 2004 Posts: 2

I get the same error msg too.

Warning: Supplied argument is not a valid MySQL result resource in
/home/jonstarbuck/public_html/mscnuke/includes/sql_layer.php on line 286 Unknown column 'mod_group' in 'field list'

The field mod_list does indeed not exist (so far as I can tell) and I am sure I used the corect installer; PHPNuke 7.1. I am less sure about the way the DB was installed, is there a correct installer for the DB to go with v7.1??

Thanks,

Jon.

chris · Posted: Fri Mar 26, 2004 9:32 pm Post subject:

See the answer of koun in PHP-Nuke 7.1 No Blocks appearing. Indeed, judging from these posts, there seems to be a mismatch between version 7.1 and its web installers.
_________________
Regards

Chris Karakas
www.karakas-online.de

stafo · Private Joined: 26 Mar 2004 Posts: 2

Yep. I was mistaken. I was using another version of nukesql.php that didn't coincide with the version of PHPnuke I was running. Smile

Thanks for the reply though!

JonStarbuck · Private Joined: 26 Mar 2004 Posts: 2

Yep, I was using the incorrect database installer - mismatch between it and the version of phpnuke I was using.
Thanks for your help.
Jon.

Superfrappe · Private Joined: 25 Jun 2004 Posts: 1

Hello all. New to the forum. Also new to PHP. I know this is an older post, but I also have the same issue, and was hoping I could get a more detailed answer and help. Here's my error.. same as above:

RayCRP · Private Joined: 29 Jun 2004 Posts: 1