Streaming Error

General discussion about netjukebox
Post Reply
dsmythe
User
Posts: 7
Joined: Sat Jun 23, 2007 1:00 am

Streaming Error

Post by dsmythe »

What causes this error?

Code: Select all

#EXTM3U
<br />
<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>C:\xampp\htdocs\media\stream.php</b> on line <b>103</b><br />
Some video's work fine... others have this error in the playlist file.. Anyone know why?

tia!
-d
User avatar
wbartels
netjukebox developer
Posts: 872
Joined: Thu Nov 04, 2004 3:12 pm
Location: Netherlands
Contact:

Post by wbartels »

The query on line 103 depends on the code between line 55 and 97.
Mabe I can find out what is going wrong when you post the url that creates the faulty playlist.
dsmythe
User
Posts: 7
Joined: Sat Jun 23, 2007 1:00 am

Post by dsmythe »

wbartels wrote:The query on line 103 depends on the code between line 55 and 97.
Mabe I can find out what is going wrong when you post the url that creates the faulty playlist.
How to I capture the URL?
User avatar
wbartels
netjukebox developer
Posts: 872
Joined: Thu Nov 04, 2004 3:12 pm
Location: Netherlands
Contact:

Post by wbartels »

Copy with internet explore "right mouse click" > "copy shortcut".
And past with ctrl + v.

Here is an example:
Image
dsmythe
User
Posts: 7
Joined: Sat Jun 23, 2007 1:00 am

Post by dsmythe »

wbartels wrote:Copy with internet explore "right mouse click" > "copy shortcut".
And past with ctrl + v.
Ah.. ok.. here it is..

The broken one.....

Then working one...
User avatar
wbartels
netjukebox developer
Posts: 872
Joined: Thu Nov 04, 2004 3:12 pm
Location: Netherlands
Contact:

Post by wbartels »

The broke one… is very clear, if the track_id is empty it will indeed produce the error you described above.
But on my system I couldn't find any url with an empty track_id.

With some more information I think I can find out what is going on.
Does the error also appear after a full update?
Is the file size of the problem file very big? (this could be a php limitation)
What php version are you using?
Are you using any php accelerator?
dsmythe
User
Posts: 7
Joined: Sat Jun 23, 2007 1:00 am

Post by dsmythe »

wbartels wrote:The broke one… is very clear, if the track_id is empty it will indeed produce the error you described above.
But on my system I couldn't find any url with an empty track_id.

With some more information I think I can find out what is going on.
Does the error also appear after a full update?
Is the file size of the problem file very big? (this could be a php limitation)
What php version are you using?
Are you using any php accelerator?
1. yes
2. 1.3GB (Div/x .AVI)
3. PHP 5.2.3
4. Not that I am aware of... whatever comes w/ XAMPP (latest)for windows

-d
User avatar
wbartels
netjukebox developer
Posts: 872
Joined: Thu Nov 04, 2004 3:12 pm
Location: Netherlands
Contact:

Post by wbartels »

I don't have such a large file to see what is happening.
Maybe you could export and mail me the track database with phpMyAdmin (include by XAMPP).
  • Type http://dls-media/phpMyAdmin in your web browser.
  • Select netjukebox database (left screen)
  • Select table track (left screen)
  • Select export (top screen)
  • Select safe as file (bottom screen)
  • Select Compression "zipped" (bottom screen)
  • Click Go
Email addresses see: http://www.netjukebox.nl/about.php
User avatar
wbartels
netjukebox developer
Posts: 872
Joined: Thu Nov 04, 2004 3:12 pm
Location: Netherlands
Contact:

Post by wbartels »

I have found a large .ts video file on my system for testing.
When staring updating it stops by that file.
As expected the track_id, playtime, etc… is not created in the database.

I also have tested it with the getID3() demo.browse.php script witch says that 2GB files are not supported.

Image

I have tricked the system by setting option_max_2gb_check to false in the update.php script:
$getID3->option_max_2gb_check = false; // Check whether file is larger than 2 Gb and thus not supported by PHP
But it didn't help.
User avatar
wbartels
netjukebox developer
Posts: 872
Joined: Thu Nov 04, 2004 3:12 pm
Location: Netherlands
Contact:

Post by wbartels »

Your avi example file form 1.3GB is smaller that the 2GB limit in PHP.
Can it be that you have other file in you media directory that are equal or larger that 2GB?
Than the files after the => 2GB file are not updated and your example file could be one of them.

PS
I'm still interested in you database file.
dsmythe
User
Posts: 7
Joined: Sat Jun 23, 2007 1:00 am

Post by dsmythe »

wbartels wrote:Your avi example file form 1.3GB is smaller that the 2GB limit in PHP.
Can it be that you have other file in you media directory that are equal or larger that 2GB?
Than the files after the => 2GB file are not updated and your example file could be one of them.

PS
I'm still interested in you database file.
Ok.. I sent the file off to you. Thank you for all your help!
-d
User avatar
wbartels
netjukebox developer
Posts: 872
Joined: Thu Nov 04, 2004 3:12 pm
Location: Netherlands
Contact:

Post by wbartels »

dsmythe wrote: Ok.. I sent the file off to you. Thank you for all your help!
-d
From the sql file I could see that 20 files where not properly updated.
I will send you a mail with a list of these files.
Could you check if one of these files is equal or larger that 2GB?
dsmythe
User
Posts: 7
Joined: Sat Jun 23, 2007 1:00 am

Post by dsmythe »

wbartels wrote:
dsmythe wrote: Ok.. I sent the file off to you. Thank you for all your help!
-d
From the sql file I could see that 20 files where not properly updated.
I will send you a mail with a list of these files.
Could you check if one of these files is equal or larger that 2GB?
Ok, I whitelisted your address so send the titles on over and I will check into it.

-d
dsmythe
User
Posts: 7
Joined: Sat Jun 23, 2007 1:00 am

Post by dsmythe »

dsmythe wrote:
wbartels wrote:
dsmythe wrote: Ok.. I sent the file off to you. Thank you for all your help!
-d
From the sql file I could see that 20 files where not properly updated.
I will send you a mail with a list of these files.
Could you check if one of these files is equal or larger that 2GB?
Ok, I whitelisted your address so send the titles on over and I will check into it.

-d
Ok, I upgraded to v4.04e - deleted the database contents... copied over the existing installation and re-ran the setup then I did a full update and still getting an error. the playlist does not start the media player now but I get a page w/ this message:

Code: Select all

Unsupported query string
action=playlist&track_id=
The test movie size is 1.03GB in size in a .AVI (divx format)
User avatar
wbartels
netjukebox developer
Posts: 872
Joined: Thu Nov 04, 2004 3:12 pm
Location: Netherlands
Contact:

Post by wbartels »

Have you already checked if there are files equal or greater than 2GB?

If this is the case than there is NO fix for your problem.
PHP simply doesn't support files larger than 2GB because of the signed integer from 32 bits.
(32^2 = 4294967296 / 2 = 2GB)
This limitation will be fixed in PHP 6 by adding 64 bit integer.
Post Reply