Page 1 of 1

mysql_fetch_array() fails cause an empty query

Posted: Wed Apr 02, 2008 1:03 am
by ma2xfr
I get several errors using the version 4.07.

For example when I click on this following link
http://192.168.0.5/netjukebox/index.php ... der=artist

I get the follwing error message:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /volume1/web/netjukebox/index.php on line 753

This link, is the link to display the list of the artists with the large pictures. (After performing a search by name in the media panel)

I tried to debug to understand from where the problem comes from, and I saw, that the var $query is empty before going into the while loop! (line 753 of the index.php)

I compared the version 5.04 with the version 4.07, and I can say, that the version 5 works like a charm.
The version 4 seems to be unstable. The reason why I use the version 4 instead of the version 5, it is beacause my host does not support the library mysqli. So, I will never be able to install the version 5.

My current running enviornoment is:
- Mysql 5.0.51
- Apache 2.2.3
- PHP 5.2.0
- The operating system is a Linux. (Commercial distribution)

Can you support me about the mysql error?

Re: mysql_fetch_array() fails cause an empty query

Posted: Wed Apr 02, 2008 11:41 am
by wbartels
Problem fixed in netjukebox 4.07b.

Re: mysql_fetch_array() fails cause an empty query

Posted: Wed Apr 02, 2008 4:51 pm
by ma2xfr
Hi,

Thank you for your prompt answer regarding the problem, but it still occurs. :-(

http://127.0.0.1:2500/streaming/netjuke ... der=artist

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\home\streaming\www\netjukebox4\index.php on line 751

The version 4.07b does not seem fix the issue.

Could you please have a look?

Re: mysql_fetch_array() fails cause an empty query

Posted: Wed Apr 02, 2008 5:18 pm
by wbartels
On my system this works: index.php?action=view2&mode=thumbnail&artist=&filter=smart&order=artist
Are you certain you use netjukebox 4.07b?

Image

Re: mysql_fetch_array() fails cause an empty query

Posted: Wed Apr 02, 2008 6:20 pm
by ma2xfr
Excellent, It works! Sorry for the confusion. I did not loead the right version.
I confirme, with the version 4.07b, the issue is fixed.

Thank you again for your help.