Recipe module, mysql_fetch_array error

MurphDog · **Recipe module, mysql_fetch_array error -** 07-11-2003, 10:48 PM

Using nuke 6.8 and trying to use the recipe module found at http://www.heartstorm.org/ I get the following error

Quote:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/virtual/site156/fst/var/www/html/includes/sql_layer.php on line 342

This goes along with the code

Code:

case "MySQL":
        $row = array();
        $row = mysql_fetch_array($res);
        return $row;
    break;;

I did not have this problem with any earlier version of Nuke. Ideas?

IACOJ · 07-11-2003, 11:11 PM

Can you turn debugging on please, and post the error it gives.

MurphDog · 07-11-2003, 11:23 PM

Here you go

Quote:

SQL query: SELECT * FROM nuke_users WHERE uname='Murphy'

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/virtual/site156/fst/var/www/html/includes/sql_layer.php on line 342
SQL query: SELECT * FROM recipes_recipes LIMIT 1

MurphDog · 07-11-2003, 11:26 PM

and this is above the header

Quote:

SQL query: select * from nuke_users

MurphDog · **Debugger run after 2 blocks installed... -** 07-11-2003, 11:34 PM

Ok, I'm at this point where I just deleted everything, removed the db and started over. I've added only 2 blocks, the Site Visitor w/ avatar (same as nukemods) and the Admin Login (#2) from NSN. I've edited the language file just fine. Another change I made was to the weblink/download images to work with the theme.

I then decide to turn the debug on (mostly cuz I didn't think about it at the beginning. and I get the following on the left column under the modules block whether or not my user account is logged in.

Quote:

SQL query: DELETE FROM nuke_users WHERE time < '1057989247'
SQL query: SELECT time FROM nuke_session WHERE uname='Murphy'
SQL query: UPDATE nuke_session SET uname='Murphy', time='1057990147', host_addr='66.68.68.104', guest='' WHERE uname='Murphy'
SQL query: select username from nuke_users order by user_id DESC limit 0, 1
SQL query: select user_id from nuke_users where username != 'Anonymous'
SQL query: SELECT uname, guest FROM nuke_session where guest=0
SQL query: select user_from from nuke_users where username='Murphy'
SQL query: SELECT user_id FROM nuke_users where username='Murphy'
SQL query: SELECT COUNT(user_id) AS userCount from nuke_users WHERE user_regdate LIKE '%Jul%12%2003%'
SQL query: SELECT COUNT(user_id) AS userCount from nuke_users WHERE user_regdate LIKE '%Jul%11%2003%'
SQL query: SELECT uname FROM nuke_session where guest=1
SQL query: SELECT uname FROM nuke_session where guest=0
SQL query: select user_id from nuke_users where username='Murphy'
SQL query: select privmsgs_type from nuke_bbprivmsgs where privmsgs_to_userid='2' AND (privmsgs_type='1' or privmsgs_type='5')
SQL query: select privmsgs_type from nuke_bbprivmsgs where privmsgs_to_userid='2' AND (privmsgs_type='0')
SQL query: SELECT user_id FROM nuke_users where username='Murphy'

I get this in the Banners Admin screen

Quote:

Current Active Banners
SQL query: select bid, cid, imptotal, impmade, clicks, imageurl, date, type, active from nuke_banner order by bid

and

Quote:

Advertising Clients
SQL query: select cid, name, contact, email from nuke_bannerclient order by cid

A bunch of lines that look like this above the Blocks Admin table (still works though)

Quote:

SQL query: select bid, bkey, title, url, bposition, weight, active, blanguage, blockfile, view from nuke_blocks order by bposition, weight
SQL query: select bid from nuke_blocks where weight='0' AND bposition='l'
SQL query: select bid from nuke_blocks where weight='2' AND bposition='l'

The Content Manager has these lines in various places

Quote:

SQL query: select * from nuke_pages order by pid
SQL query: select cid, title from nuke_pages_categories order by title
SQL query: select cid, title from nuke_pages_categories order by title

Here's the Module's Admin screen

Quote:

SQL query: select mid from nuke_modules where title='Addon_Sample'
SQL query: select mid from nuke_modules where title='AvantGo'
SQL query: select mid from nuke_modules where title='Content'
SQL query: select mid from nuke_modules where title='Downloads'
SQL query: select mid from nuke_modules where title='Encyclopedia'
SQL query: select mid from nuke_modules where title='FAQ'
SQL query: select mid from nuke_modules where title='Feedback'
SQL query: select mid from nuke_modules where title='Forums'
SQL query: select mid from nuke_modules where title='Journal'
SQL query: select mid from nuke_modules where title='Members_List'
SQL query: select mid from nuke_modules where title='News'
SQL query: select mid from nuke_modules where title='Private_Messages'
SQL query: select mid from nuke_modules where title='Recommend_Us'
SQL query: select mid from nuke_modules where title='Reviews'
SQL query: select mid from nuke_modules where title='Search'
SQL query: select mid from nuke_modules where title='Sections'
SQL query: select mid from nuke_modules where title='Statistics'
SQL query: select mid from nuke_modules where title='Stories_Archive'
SQL query: select mid from nuke_modules where title='Submit_News'
SQL query: select mid from nuke_modules where title='Surveys'
SQL query: select mid from nuke_modules where title='Top'
SQL query: select mid from nuke_modules where title='Topics'
SQL query: select mid from nuke_modules where title='WebMail'
SQL query: select mid from nuke_modules where title='Web_Links'
SQL query: select mid from nuke_modules where title='Your_Account'
SQL query: select title from nuke_modules

I'm tired of copy/pasting but I think you get the idea.
Are these things I should be worried about? Or should I just turn off the debugger?

IACOJ · 07-12-2003, 09:57 AM

You can turn it off, it was just to see a more complete error for the warning you were getting in recipes.

btw.. you don't have to completely delete things to make the errors go away, Just disable them

Does 6.8 use uname or username? If it doesn't use uname that could the problem with recipes.

MurphDog · 07-12-2003, 01:48 PM

not sure, where's the best place to find out? Sorry if it should be obvious. Too much on my brain right now.

IACOJ · 07-12-2003, 01:57 PM

You could try the change log. I'm sorry I don't have 6.8 so I can't look myself. I do have the module you're using.

MurphDog · 07-12-2003, 02:00 PM

Nope, doesn't indicte a change to that other than version 6.5

IACOJ · 07-12-2003, 02:25 PM

What vs of recipes do you have? 1.4.1 or an older vs.

I had the older vs and just downloaded the newer one. It shouldn't make a difference anyway because it is supposed to be compatible with 6.0 and 6.5. Maybe send Shaun an email and find out if he has tested it on 6.8, he may already be aware of the problem, but wont be making another public release until the next final of nuke is released.