FAQ mysql_fetch_row(): error

Nuke Cadet Joined: Feb 18, 2004 Posts: 3

I am having a very similar problem that I havent been able to find an answer to. When I log into my admin.php - where the menu buttons should be I get a list of the same error:

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

I tried using the version of sql_layer.php shown above but that just changes the error to line 288 - no help.

Any other suggestions? Could it be somewhere in another file a problem exists? Thanks.

Guest

From memory there was a problem was with capitalisation in the database, find the 2 FAQ tables in the nuke database (nuke_faqanswer and nuke_faqcategories) and make sure the "C" in categories and the "A" in answers are capitalised.

ALTER TABLE `nuke_faqanswer` RENAME `nuke_faqAnswer`
ALTER TABLE `nuke_faqcategories` RENAME `nuke_faqCategories`

HTH
Cheers

Nuke Cadet Joined: Feb 18, 2004 Posts: 3

For me though, it is more then that.
I put up two screen shots on another domain from my admin.php page.
First is where the grahpical buttons should be (you can see two at the bottom)
Second is the info below the buttons (notice the _NAME for everything, maybe this gives a clue to whats wrong?)
http://www.romscripts.com/scr.jpg
http://www.romscripts.com/scr2.jpg

Im completley lost, please assist Smile

-B

Guest

Hi

It might be an idea to turn debug on in your sql_layer.php and check out what the query is asking for then you can track down which file its affecting.

Sometimes the query is missing a

Quote:

$

or the variabe name is different depending what version of nuke you are running.

About line 181 on nuke 7

Quote:

$sql_debug = 1;

Nuke Cadet Joined: Feb 18, 2004 Posts: 3

Ok, I turned debug on and this is the message I got back:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/residen1/public_html/nuke/includes/sql_layer.php on line 288
Access DeniedSQL query: select radmincontent, radminsuper from nuke_authors where aid='***'

*** was where my admin user name was.

Now don't flame me, because I am completly new to PHPnuke, but I'm not sure what it means. I'm going to poke around in the authors file after I post this, but any extra help would be great!

Thanks,

Guest

Hya..

I've read almost every question about this topic, but i can't seem to find the answer for my problem.. So here it is.:

When i try to edit or create/add a new block i get the following message:
*i am using the new sql_layer.php posted previously in this topic..*

Edit Block

Unknown column 'subscription' in 'field list'

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in *\includes\sql_layer.php on line 288
Unknown column 'subscription' in 'field list'

This error message is about a missing column.. but i can't find 'field list'.. so how can i look for this? other then searching and not finding it Wink

I am hosting on a Windows 2003 Server, with apache, MySQL, phpnuke 7.1 and phpadmin..

Thx in advance!
KiSa
http://drkisa.ww-ei.nl

Guest

Darkmere wrote:

Ok, I turned debug on and this is the message I got back:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/residen1/public_html/nuke/includes/sql_layer.php on line 288
Access DeniedSQL query: select radmincontent, radminsuper from nuke_authors where aid='***'

*** was where my admin user name was.

Now don't flame me, because I am completly new to PHPnuke, but I'm not sure what it means. I'm going to poke around in the authors file after I post this, but any extra help would be great!

Thanks,

Hi
There is a reference to that query in your html/admin/modules/content.php about Line 17, mine looks like this

$result = sql_query("select radmincontent, radminsuper from ".$prefix."_authors where aid='$aid'", $dbi);

It might pay to check that out

Cheers

Posted: Mon Jun 14, 2004 5:09 am

yeee haaaa EXCELLENT thread the second post fixed it up smoooooooth thanks guys! Very Happy

Posted: Mon Jul 12, 2004 7:49 pm

once again, NC to the rescue. Thanks folks you make nuking a piece of cake.

Posted: Tue Mar 22, 2005 1:09 am

Hi guys I installed wb block manager also and I don't get any errors. When I go to add blocks to the modules, nothing changes. Everything is the same. Anyone getting this problem? I'm not sure I installed .sql right. I uploaded it and I see the code display and it says successfull upload or something and then I just log out. Any help would be nice.

Posted: Mon Apr 18, 2005 2:14 am

ResidentIdler wrote:

I am having a very similar problem that I havent been able to find an answer to. When I log into my admin.php - where the menu buttons should be I get a list of the same error:

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

I tried using the version of sql_layer.php shown above but that just changes the error to line 288 - no help.

Any other suggestions? Could it be somewhere in another file a problem exists? Thanks.

Guest

DELETED