Stop data retention! Click here & act! Are you a webmaster and want to participate? Here you can find all necessary material for your website - Willst du auch an der Aktion teilnehmen? Hier findest du alle relevanten Infos und Materialien:
Chris Karakas Online Forum Index Karakas Online
 FAQFAQ   Forum SearchForum Search   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
Warning: mysql_fetch_row(): supplied argument is not a valid


Goto page 1, 2, 3, 4, 5, 6, 7  Next
 
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
   Chris Karakas Online Forum Index -> PHP-Nuke Forum RSS Feed of this Forum
Share this page: These icons link to social bookmarking sites where readers can share and discover new web pages.Digg  del.icio.us  tc.eserver.org  Blinklist  Furl  Reddit  Blogmarks  Magnolia  Sphere  Yahoo!  Google  Windows Live  Technorati  Blue Dot  Simpy  Newsvine  Stumble Upon  co.mments.com  Blinkbits  BlogMemes  Connotea  View previous topic :: View next topic  
Author Message
chris
Dark Lord of the Sith


Joined: 10 May 2003
Posts: 6267
Location: Outer Space

PostPosted: Wed Jun 25, 2003 8:06 pm    Post subject: Warning: mysql_fetch_row(): supplied argument is not a valid
Reply with quote

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.

Arrow 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):
Code:
    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;;


Exclamation This will NOT fix your problem. But it will give a more descriptive message as to what the error cause is.
_________________
Regards

Chris Karakas
www.karakas-online.de
Back to top
View user's profile Send private message Send e-mail Visit poster's website
timbro
Private
Private


Joined: 11 Mar 2004
Posts: 1

PostPosted: Thu Mar 11, 2004 7:26 am    Post subject:
Reply with quote

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'
Back to top
View user's profile Send private message Send e-mail
chris
Dark Lord of the Sith


Joined: 10 May 2003
Posts: 6267
Location: Outer Space

PostPosted: Mon Mar 15, 2004 11:17 am    Post subject:
Reply with quote

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.

Arrow 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
Back to top
View user's profile Send private message Send e-mail Visit poster's website
stafo
Private
Private


Joined: 26 Mar 2004
Posts: 2

PostPosted: Fri Mar 26, 2004 7:48 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
JonStarbuck
Private
Private


Joined: 26 Mar 2004
Posts: 2

PostPosted: Fri Mar 26, 2004 8:26 pm    Post subject: Same problem
Reply with quote

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.
Back to top
View user's profile Send private message
chris
Dark Lord of the Sith


Joined: 10 May 2003
Posts: 6267
Location: Outer Space

PostPosted: Fri Mar 26, 2004 9:32 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message Send e-mail Visit poster's website
stafo
Private
Private


Joined: 26 Mar 2004
Posts: 2

PostPosted: Fri Mar 26, 2004 9:37 pm    Post subject:
Reply with quote

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!
Back to top
View user's profile Send private message
JonStarbuck
Private
Private


Joined: 26 Mar 2004
Posts: 2

PostPosted: Sun Mar 28, 2004 9:14 am    Post subject: Thanks
Reply with quote

Yep, I was using the incorrect database installer - mismatch between it and the version of phpnuke I was using.
Thanks for your help.
Jon.
Back to top
View user's profile Send private message
Superfrappe
Private
Private


Joined: 25 Jun 2004
Posts: 1

PostPosted: Fri Jun 25, 2004 6:17 pm    Post subject:
Reply with quote

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:

Code:
Unknown column 'mod_group' in 'field list'


I am using version 6.5 and I also used the 6.5installer.

If the column doesn't exist, can't we just create it? Am I really forced to do another complete install? I also use phpMyAdmin, so if there is an easier fix than a complete install, I'd be thrilled!

Thanks very much for your answers.

Cheers!
Back to top
View user's profile Send private message
RayCRP
Private
Private


Joined: 29 Jun 2004
Posts: 1

PostPosted: Tue Jun 29, 2004 4:13 am    Post subject:
Reply with quote

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


What if nothing came up? Laughing
Back to top
View user's profile Send private message
Share this page: These icons link to social bookmarking sites where readers can share and discover new web pages.Digg  del.icio.us  tc.eserver.org  Blinklist  Furl  Reddit  Blogmarks  Magnolia  Sphere  Yahoo!  Google  Windows Live  Technorati  Blue Dot  Simpy  Newsvine  Stumble Upon  co.mments.com  Blinkbits  BlogMemes  Connotea 
Display posts from previous:   
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
   Chris Karakas Online Forum Index -> PHP-Nuke Forum
Page 1 of 7
This page contains valid HTML 4.01 Transitional - click here to check it!
This page contains a valid CSS - click here to check it!

 

Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group