#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?
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.
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.
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?
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
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.
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
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.
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
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 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.
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:
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.