I am kind of freaked right now because while I was doing other things today someone from my forums www.solo-ops.com emailed me and said there was an error appearing on my pages. I had just been on my site 30 min prior and there was nothing wrong then.

But sure enough there was the error :

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/solo-ops/public_html/includes/sql_layer.php on line 357

The very strange part is that usually when an error appears it happens when I am DOING something on the forums and I mess it up. Then I can usually kind of have an idea what files I messed up and HOW. I have not done anything. Which is why I am REALLY confsed about how to fix it... anyone recocnize this?

Thanks,

Hilary

I just got done talking with all the people who have access to my forums and they are all telling me that they did not do anything that caused the error... can't somebody help me?

First thing you need to do Hilary is turn on Nuke debugging.
Or if it is only showing in your Forums, turn on Forum debugging.
To learn how to turn on debugging, refer to this post at nukecops.
http://nukecops.com/postt1.html

mikem

Ok, I turned on the debugging and this is the message that I got...

SQL query: SELECT sitename, nukeurl, site_logo, slogan, startdate, adminmail, anonpost, Default_Theme, foot1, foot2, foot3, commentlimit, anonymous, minpass, pollcomm, articlecomm, broadcast_msg, my_headlines, top, storyhome, user_news, oldnum, ultramode, banners, backend_title, backend_language, language, locale, multilingual, useflags, notify, notify_email, notify_subject, notify_message, notify_from, footermsgtxt, email_send, attachmentdir, attachments, attachments_view, download_dir, defaultpopserver, singleaccount, singleaccountname, numaccounts, imgpath, filter_forward, moderate, admingraphic, httpref, httprefmax, CensorMode, CensorReplace, copyright, Version_Num from nuke_config
SQL query: select active, view from nuke_modules where title='Your_Account'
SQL query: select pass from nuke_users where uid='4'
SQL query: select pass from nuke_users where uid='4'
SQL query: select pass from nuke_users where uname='Hilary'
SQL query: DELETE FROM nuke_session WHERE time < 1049746760
SQL query: SELECT time FROM nuke_session WHERE username='Hilary'
SQL query: UPDATE nuke_session SET username='Hilary', time='1049748560', host_addr='204.32.193.228', guest='' WHERE username='Hilary'
SQL query: select pass from nuke_users where uid='4'
SQL query: select pass from nuke_users where uname='Hilary'
SQL query: DELETE FROM nuke_whoiswhere WHERE time < 1049747660
SQL query: SELECT time FROM nuke_whoiswhere WHERE username='Hilary'
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/solo-ops/public_html/includes/sql_layer.php on line 357
SQL query: INSERT INTO nuke_whoiswhere (username, time, host_addr, guest, module, url) VALUES ('Hilary', '1049748560', '204.32.193.228', '', 'Your_Account', '/modules.php?name=Your_Account')

That part
You are using a Who is where hack or mod or block? Try disabling it and see if the error dissapears.

mikem

I do have a block like that, but when I went to look at it, it is already disabled and I have never used it... When I select "show" I get more of this:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/solo-ops/public_html/includes/sql_layer.php on line 253

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/solo-ops/public_html/includes/sql_layer.php on line 357

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/solo-ops/public_html/includes/sql_layer.php on line 253

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/solo-ops/public_html/includes/sql_layer.php on line 357

Well, you may not have used that block, but I think it requires an install of a line to query the user info from the nuke_whoiswhere table.
More than likely you had to have added a line to a file in your Nuke for that Who is where hack. Mybe in your theme.php or header.php or footer.php.

I would open those files and do a search for whoiswhere

You can disable debugging now so your users don't have to see all that "other" crud.

mikem

Will it work the same if I just delete the hack? lol.

I don't understand how that happened, I have had the forums up for a couple months and it has never been a problem before.... how does it just appear?

Hilary

I'm not sure. The only reason I could give you is that if the nuke_whoiswhere table no longer exists in your Database.
I don't know why the message just all of a sudden started showing...
Yes delete the hack and more than likely that error will dissappear.

mikem

Thanks so much, Mike, your awesome!

Hilary