|
#40511
05/11/2004 4:18 PM
|
Joined: Feb 2004
Posts: 8
stranger
|
stranger
Joined: Feb 2004
Posts: 8 |
Today I encountered an issue where a user tried to upload a 1.18MB powerpoint file to a post. When the user clicks the "Ok, Submit" button, the browser goes to an error "The page cannot be displayed" screen.
I've increased the attach file size to 100000000 bytes so the system should allow the file to be added. I can upload smaller PPT files so the format is accepted. Note: from some testing I did, it seems like 500K is the magic size barrier for any uploads.
I'm not sure what's going on, but if anyone has any thoughts, I'd appreciate it.
Btw, I also increased by php.ini max upload size from 2M to 100M just incase.
|
|
|
#40512
05/11/2004 4:52 PM
|
Joined: Jul 2006
Posts: 2,143
Pooh-Bah
|
Pooh-Bah
Joined: Jul 2006
Posts: 2,143 |
Did you restart the web server after changing php.ini? Normally the ini is read at server startup, not on the fly.
|
|
|
#40513
05/11/2004 5:07 PM
|
Joined: Feb 2004
Posts: 8
stranger
|
stranger
Joined: Feb 2004
Posts: 8 |
For kicks, I also increased the following items in php.ini
max_execution_time now at 3000 seconds post_max_size now at 100M upload_max_filesize at 100M
I've also rebooted the server incase there was some service that needed restarting.
The "cannot access" error comes up within a second of pressing the "Ok, submit" button so I don't think there's a timeout happening.
I'm running 6.4.1 if that matters.
|
|
|
#40514
05/11/2004 7:02 PM
|
Joined: Feb 2004
Posts: 8
stranger
|
stranger
Joined: Feb 2004
Posts: 8 |
[]Did you restart the web server after changing php.ini? Normally the ini is read at server startup, not on the fly. [/]
yes, the problem still continues.
|
|
|
#40515
05/12/2004 11:11 AM
|
Joined: Jan 2004
Posts: 31
newbie
|
newbie
Joined: Jan 2004
Posts: 31 |
Did you make the change to your my.cnf (Unix) or my.ini (?Windows?). That config file has a max upload size parameter as well.
|
|
|
#40516
05/12/2004 12:39 PM
|
Joined: Feb 2004
Posts: 8
stranger
|
stranger
Joined: Feb 2004
Posts: 8 |
Where do I set the max download parameter, all I have in my.cnf is the following:
[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock
[mysql.server] user=mysql basedir=/var/lib
[safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid
|
|
|
#40517
05/13/2004 9:04 AM
|
Joined: Jan 2004
Posts: 31
newbie
|
newbie
Joined: Jan 2004
Posts: 31 |
In my.cnf, you should have a parameter as follows: # The MySQL server [mysqld] max_allowed_packet = 10M After changing my.cnf, you have to stop and restart MySQL for the change to take effect. (The 10M allows a 10MB file attachment into MySQL.) Here is a great thread on ThreadsDev for tuning MySQL, which could help your overall forum performance as well.
|
|
|
#40518
05/14/2004 1:43 PM
|
Joined: Feb 2004
Posts: 8
stranger
|
stranger
Joined: Feb 2004
Posts: 8 |
I changed the my.cnf file to include the max_allowed_packet setting as shown below, and even after rebooting the entire system nothing changed. Note: I had to do the "set-variable = " thing becasue otherwise ubbthreads could not connect with the database. Any other thoughts on things to try?
[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock set-variable = max_allowed_packet=100M
[mysql.server] user=mysql basedir=/var/lib
[safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid
Last edited by medic; 05/14/2004 1:47 PM.
|
|
|
#40519
05/17/2004 2:35 PM
|
Joined: Jul 2006
Posts: 2,143
Pooh-Bah
|
Pooh-Bah
Joined: Jul 2006
Posts: 2,143 |
With attachments not stored in the database I do not know why you would need to change max packets in the my.cnf. I guess it can't hurt though. <img src="https://www.ubbcentral.com/boards/images/graemlins/smile.gif" alt="" />
Make sure that there is a tmp directory defined in php.ini and that apache, if that is what you are running, has write permissions to it. I can't think of anything else.
|
|
|
#40520
12/01/2004 4:41 PM
|
Joined: Apr 2004
Posts: 4
stranger
|
stranger
Joined: Apr 2004
Posts: 4 |
Working with Support, it was fixed by editing my: php.conf file: LimitRequestBody 524288 (default value) Set it to something higher (the value is in bytes) Then restart apache....all set. That is why it is limited by default to ~500k
Thanks, -Brad
|
|
|
1 members (Ruben),
1,277
guests, and
207
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|
|