:?: >>> mysql_num_rows(): supplied argument is not

Nuke Cadet Joined: Jul 20, 2003 Posts: 8

Hi,
I've upgraded to Nuke 6.8 from 6.7 and ever since I have the following warning in "Download" module >>>>
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in c:\program files\apache group\apache\htdocs\includes\sql_layer.php on line 238

Address is: http://mirciu.rr.nu/index.php

Any help would be greatly appreciated.

Thank you.

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

Read the welcome announcement for how to set SQL DEBUG on. That will tell you what sql statement is causing this. Did you run the 6.7-6.8 upgrade script?

Nuke Cadet Joined: Jul 20, 2003 Posts: 8

Thanks.

Yes, I did run the upgrade67-68.php to begin with. Seeing that the warning was still there, I did a new install too.

- I've read the anouncement and I did a debug but I'm not sure what statement I'm looking for.
This is the query under each download >>> SQL query: SELECT adminid FROM nuke_downloads_editorials WHERE downloadid=7

Unfortunately it doesn't tell me anything.

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

Find the one right by the mysql warning message.

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

Quote:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\program files\apache group\apache\htdocs\modules\WhereBisDu\wbdtrack.php on line 79

This one is a definite problem!

Nuke Cadet Joined: Jul 20, 2003 Posts: 8

I fixed the one you've found.
The others are still there. And the query was the one I pointed out earlier.
I've given access to downloads now if you want to see ...

Thanks anyway.

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

I was only able to get into the Download link 1 time and I saw no errors. I tried again and I got a 404, it timed out.

Nuke Cadet Joined: Jul 20, 2003 Posts: 8

You have to go into one of the categories. The warnings are still there.
By the way the engine on my MySQL is "4.0.13-max-debug".
Do you think that may have something to do with it?

Mirciu'

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

I need to see it with SQL DEBUG on.

Nuke Cadet Joined: Jul 20, 2003 Posts: 8

SQL Debug is ON.

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

SELECT adminid FROM nuke_downloads_editorials WHERE downloadid=2

Either the column adminid does not exist in the table nuke_downloads_editorials
or the table does not exist
or there is no downloadid=2

Take that statement, use phpMyAdmin and select your nuke database. Then select the SQL tab and paste that statement in it. You should get the answer to the question then.

Nuke Cadet Joined: Jul 20, 2003 Posts: 8

Will do.

Thank you.

Nuke Cadet Joined: Jul 20, 2003 Posts: 8

That worked!

Thank you very much for your help.

Regards,

Mirciu'

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

For the benefit of others, what was the error?

Nuke Cadet Joined: Jul 20, 2003 Posts: 8

It seems that I lost a few tables when I upgraded to Nuke 6.8.
The same problem in in Forums.