I am using a longblob to store the file data, however this seems to
be a php error rather than a mysql error.
On 05/03/2007, at 5:22 PM, Gustav Wiberg wrote:
Hi there!
What fieldtype do you try to store the file in?
Best regards
/Gustav Wiberg
-----Original Message-----
From: Hartleigh Burton [mailto:hburton@xxxxxxxxxxxxxxxxxxxx]
Sent: Monday, March 05, 2007 3:14 AM
To: php-windows@xxxxxxxxxxxxx
Subject: Fatal Error: Allocated memory size problem...
Hi All,
I am having some problems while uploading a file to a MySQL database
relating to file sizes. I have created a script which successfully
uploads most files to the database, however anything roughly over 1MB
in size seems to return a PHP error. I am not trying to upload
anything larger than 15MB. The error I am getting is as follows:
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried
to allocate 8439363 bytes) in C:\Program Files\Apache Software
Foundation\Apache2.2\htdocs\_dev\mraintranet\settings\common.php on
line 78 (memory_limit = 64M)
I have done a fair bit of reading on the google-net and found that
this is a very common problem. So I started changing the
configuration of the php.ini file to try and resolve it the same way
others have. Currently I have the memory_limit set to 64M, which is
significantly more than the 8M or 12M that is set by default in the
php.ini file. When I bump it up to say 128M or 256M I get the same
error with different exhausted/allocated sizes. I have tried putting
this up to 512M. Example:
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried
to allocate 7311167 bytes) in C:\Program Files\Apache Software
Foundation\Apache2.2\htdocs\_dev\mraintranet\settings\common.php on
line 77 (memory_limit = 128M)
That is uploading the exact same file (which is approximately 3.5MB).
I don't understand why the 'tried to allocate' size is different. I
also don't understand why the error is occurring on different lines.
I have changed post_max_size to 20M. I upgraded to PHP 5.2.1 after
first noticing the problem and reading that this version of PHP had a
lot of memory bug fixes in it. I am using the following software:
Windows 2000 (SP4)
PHP 5.2.1
Apache 2.2.4
MySQL 5.0.27
If anyone has any ideas on how to solve this then the help is greatly
appreciated.
Regards,
Hartleigh Burton.
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Regards,
Hartleigh Burton
Resident Geek
MRA Entertainment Pty Ltd
5 Dividend St | Mansfield | QLD 4122 | Australia
Phone: (07) 3457 5041
Fax: (07) 3349 8806
Mobile: 0421 646 978
www.mraentertainment.com
