Isuue with uploading large video files
Permalink
Hi. Perhaps anyone can help me. I have trouble to upload large video files to a concrete5 website.
I upload the file with ftp to the incoming folder. Then import it to concrete5 as i normally do with large files. It takes a very long time to process - even if it's uploaded by ftp already.
This error occurs then:
The file is about 440 MB and in mp4 format.
I can upload smaller videos. And for sure I can compress it - but I would like to upload some large files too. This should be possible via ftp and incoming folder.
Thanks for help or tipps!
I upload the file with ftp to the incoming folder. Then import it to concrete5 as i normally do with large files. It takes a very long time to process - even if it's uploaded by ftp already.
This error occurs then:
An exception occurred while executing 'select treeTypeID from TreeTypes where treeTypeHandle = ?' with params ["file_manager"]: Error while sending QUERY packet. PID=32265
The file is about 440 MB and in mp4 format.
I can upload smaller videos. And for sure I can compress it - but I would like to upload some large files too. This should be possible via ftp and incoming folder.
Thanks for help or tipps!
Thanks for answering mnakalay.
The video is part of an online video course. And its probably the biggest chapter. So i need this on the site.
I have already increased php.ini settings.
max_execution_time: 300 (max on my hosting)
upload_max_filesize: 512M
post_max_size: 521M
memory_limit: 521M
And as workaround i have already made a less quality file. *But for downloading it should still work with the way concrete5 offers it as uploading via ftp and then importing to the filesystem via "incoming". It should then not process that much?* So I think that there might be a bug with this process somewhere.
For me it looks like its doing something withe the videofile that is already uploaded.
For testing I did the same with a large zip file that i would offer for downloading. And the same thing happened.
Sure I can upload it manually an link it manually. But there is a concrete5 way and this should work somehow.
The video is part of an online video course. And its probably the biggest chapter. So i need this on the site.
I have already increased php.ini settings.
max_execution_time: 300 (max on my hosting)
upload_max_filesize: 512M
post_max_size: 521M
memory_limit: 521M
And as workaround i have already made a less quality file. *But for downloading it should still work with the way concrete5 offers it as uploading via ftp and then importing to the filesystem via "incoming". It should then not process that much?* So I think that there might be a bug with this process somewhere.
For me it looks like its doing something withe the videofile that is already uploaded.
For testing I did the same with a large zip file that i would offer for downloading. And the same thing happened.
Sure I can upload it manually an link it manually. But there is a concrete5 way and this should work somehow.
I checked the code and there are several possible failure points.
First, it tries to copy the file from the incoming directory with a normal copy() and if there's an error, it catches the error but doesn't seem to send the error message back.
Then if that copy failed it tries again with a different way of copying involving streams
I am not sure it checks if that step was successful or not.
Then it tries to refresh attributes and generate thumbnails for the file. In theory, if the file is not an image, it doesn't run that part of the process but you never know, it might have gotten the wrong MIME type for the file.
If you know your way around PHP a bit you probably can put a few log calls in the core code to find where the problem happens.
The file is concrete\src\File\Importer.php and the function is importIncomingFile()
First, it tries to copy the file from the incoming directory with a normal copy() and if there's an error, it catches the error but doesn't seem to send the error message back.
Then if that copy failed it tries again with a different way of copying involving streams
I am not sure it checks if that step was successful or not.
Then it tries to refresh attributes and generate thumbnails for the file. In theory, if the file is not an image, it doesn't run that part of the process but you never know, it might have gotten the wrong MIME type for the file.
If you know your way around PHP a bit you probably can put a few log calls in the core code to find where the problem happens.
The file is concrete\src\File\Importer.php and the function is importIncomingFile()
Look at upload_max_filesize, post_max_size, memory_limit, max_input_time, max_execution_time
To be honest, unless you are offering it as a download you should probably not upload such a big video to your website