warning error

Corporal Joined: Mar 28, 2003 Posts: 73

Quote:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home2/jonnyc/public_html/rc/includes/sql_layer.php on line 357

this is what i get on top of my site an all pages check out the error here:
http://www.lifewarez.net/rc2

i disabled all the block and modules just to make sure but im still getting the error....

i did the anaylize thing here is the link:

http://www.lifewarez.net/rc/analyze.php

do i need to do the debug thing?

thanks guys...

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

Yes, enable debug to see which table it craps out on.

Corporal Joined: Mar 28, 2003 Posts: 73

ok there you know the link http://www.lifewarez.net/rc2
Laughing

Corporal Joined: Mar 28, 2003 Posts: 73

ok this is what i get know:

Quote:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home2/jonnyc/public_html/rc/includes/sql_layer.php on line 357
SQL query: INSERT INTO nuke_whoiswhere (username, time, host_addr, guest, module, url) VALUES ('64.185.27.226', '1053719013', '64.185.27.226', '1', 'News', '/rc/')
SQL query: select pass from nuke_users where uname=''
SQL query: select * from nuke_banner WHERE type='0' AND active='1'
SQL query: select bid, imageurl, clickurl, alttext from nuke_banner WHERE type='0' AND active='1' limit 0, 1
SQL query: update nuke_banner set impmade=impmade+1 where bid=''
SQL query: select topicid, topictext from nuke_topics order by topictext

AFTER the warning only i dint copy anything before the error.

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

Make sure that this table and all columns are present and accounted for.
nuke_whoiswhere (username, time, host_addr, guest, module, url) VALUES ('64.185.27.226', '1053719013', '64.185.27.226', '1', 'News', '/rc/')

Corporal Joined: Mar 28, 2003 Posts: 73

what is i just deleted everything that has to do with whoiswhere including tables will that solve it ?
i dont really need whoiswhere anyways.

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

Delete the block/module to see if the error goes away.

Posted: Fri May 23, 2003 12:32 pm

When you intall the Whoiswhere mod, you have to edit the footer.php and add or change some code.
You need to reverse that part of the process when you installed it to make the error related to that mod go away.

mikem