mysql_fetch_array() fails cause an empty query

Fixed and closed topics
Locked
ma2xfr
User
Posts: 8
Joined: Wed Apr 02, 2008 12:45 am

mysql_fetch_array() fails cause an empty query

Post 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?
User avatar
wbartels
netjukebox developer
Posts: 881
Joined: Thu Nov 04, 2004 3:12 pm
Location: Netherlands
Contact:

Re: mysql_fetch_array() fails cause an empty query

Post by wbartels »

Problem fixed in netjukebox 4.07b.
ma2xfr
User
Posts: 8
Joined: Wed Apr 02, 2008 12:45 am

Re: mysql_fetch_array() fails cause an empty query

Post 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?
User avatar
wbartels
netjukebox developer
Posts: 881
Joined: Thu Nov 04, 2004 3:12 pm
Location: Netherlands
Contact:

Re: mysql_fetch_array() fails cause an empty query

Post 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
ma2xfr
User
Posts: 8
Joined: Wed Apr 02, 2008 12:45 am

Re: mysql_fetch_array() fails cause an empty query

Post 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.
Locked