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?
mysql_fetch_array() fails cause an empty query
- wbartels
- netjukebox developer
- Posts: 872
- Joined: Thu Nov 04, 2004 3:12 pm
- Location: Netherlands
- Contact:
Re: mysql_fetch_array() fails cause an empty query
Problem fixed in netjukebox 4.07b.
Re: mysql_fetch_array() fails cause an empty query
Hi,
Thank you for your prompt answer regarding the problem, but it still occurs.![Sad :-(](./images/smilies/icon_sad.gif)
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?
Thank you for your prompt answer regarding the problem, but it still occurs.
![Sad :-(](./images/smilies/icon_sad.gif)
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?
- wbartels
- netjukebox developer
- Posts: 872
- Joined: Thu Nov 04, 2004 3:12 pm
- Location: Netherlands
- Contact:
Re: mysql_fetch_array() fails cause an empty query
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](http://forum.netjukebox.nl/share/netjukebox407b.gif)
Are you certain you use netjukebox 4.07b?
![Image](http://forum.netjukebox.nl/share/netjukebox407b.gif)
Re: mysql_fetch_array() fails cause an empty query
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.
I confirme, with the version 4.07b, the issue is fixed.
Thank you again for your help.