Announcement

Collapse
No announcement yet.

Large File Attachment Problems

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Chrissicom
    replied
    I had the same problem recently because I added a very large download database to my forum. Although I am not having problems uploading a ~670 MB file anymore after tweaking php.ini.

    You just need to make sure that you store your attachments in the file system and not in the vBulletin database. That is already bad when handling many attachments of small size (1 MB in my case).

    To upload such large files you need to make sure that your limits in php.ini are set high enough. The memory limit can still be as low as 16M it doesn't limit attached files to this size. Only post and upload limit is important. Also set a high enough execution time. I am uploading at 10 Mbps so even ~670 MB don't take too long.

    Btw... I am running Windows Server 2003 Standard with PHP 4.3.7 as ISAPI... a friend of mine didn't get this same process to work on Redhat with PHP 4.3.4 as ISAPI although he had the same values in the php.ini. So I don't know if it works this flawless on Linux as well but IIS 6 has no problems.

    Leave a comment:


  • JTotten
    replied
    I have no problems uploading 40MB files into the filesystem. I have found that having that large of files and / or large ammounts of files in the SQL database can cause severe slowdowns as well.

    Leave a comment:


  • Freddie Bingham
    replied
    If you enable attachments as files you will have a better chance at getting this to work.

    Leave a comment:


  • Steve Machol
    replied
    The main problem as I see it is the time it would take for someone to upload or download a 35MB file. Not everyone has broadband.

    Leave a comment:


  • shan
    replied
    Fair enough. Anyone else have anything they can add? Are large attachments just ineherntly unstable with VB? Would it matter if I used a directory structure rather than the DB?

    Any ideas are appreciated.

    Shan

    Leave a comment:


  • Steve Machol
    replied
    Sorry, I've given all the info I have on making large attachments work. Maybe someone else will have an idea.

    Leave a comment:


  • shan
    replied
    So I got it set up so that now the AdminCP reports this:

    PHP Maximum Upload Size 75M
    PHP Memory Limit None
    PHP Max Post Size 100M
    MySQL Maximum Packet Size 100M

    Then when I do my upload, I get this error:

    Invalid SQL

    INSERT INTO ATTACHMENT

    Then it hangs.

    Is this why you stated that you would be surprised to see if work consistently. Am I spinning my wheels here?

    Shan

    Leave a comment:


  • Steve Machol
    replied
    I've never used those settings myself. I assume you'd enter them in the same format as other php.ini settings.

    Honestly, I'd be surpirsed if you ever got 35MB uploads to the forum to work on a consistent basis. Let us know how it turns out.

    Leave a comment:


  • shan
    replied
    So, these two were not in my PHP.ini. Should I just add them?

    post_max_size
    memory_limit

    If so, do I use the same verbage? (ex. =50M)

    Shan

    Leave a comment:


  • shan
    replied
    Thanks Steve. Amazes me you guys don't charge more for vBulletin. The support alone would make me pay it.

    As always you guys rock!

    Leave a comment:


  • Steve Machol
    replied
    In addition to the vB settings, the allowed size of the attachments depends on the PHP and MySQL configuration. You may need to check and changechange the upload size for both PHP and for MySQL. Note, you'll need to have root access to the server to do this (or have your host do it.) Make these changes to php.ini:

    upload_max_filesize = xM

    ..and my.cnf

    set-variable=max_allowed_packet=xM

    Also take a look at this:

    http://www.vbulletin.com/forum/showp...0&postcount=12

    Leave a comment:


  • shan
    replied
    IIS 6.0...but I can handle any of the changes needed there. Just need to know what I have to change in PHP and MySQL.

    Thanks for the help!

    Leave a comment:


  • Zachery
    replied
    They are changes to ini's and config files. Ill take a few moments to look around and get back, Are you using apache or IIS? i know i can find the changes for apache, but im not sure about windows.

    Leave a comment:


  • shan
    replied
    I did search the forums but I could not find specific info on how to get it working with Windows. There are several posts like yours that say change this and change that but I can find none that tell me where to change it. If it is ASP and MsSQL, I am all good, but I am new to MySQL and PHP and need a bit more hand-holding.

    Any help would be appreciated.

    Shan

    Leave a comment:


  • Zachery
    replied
    Yes, php max upload would need to be changed as well as maximum packet size i think an apache varible must aslo be changed, max_execution time, if you search the forums you can find the anwsers.

    Leave a comment:

Loading...
Working...
X