Re: Fatal Error: Allocated memory size problem...

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@mraentertainment.com] Sent: Monday, March 05, 2007 3:14 AM To: php-windows@lists.php.net Subject: [PHP-WIN] 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