0

I am getting this error when exporting the file.

Fatal error: Out of memory (allocated 377487360) (tried to allocate 71 bytes) in /home/*/public_html/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/CacheBase.php on line 173**

And on line 173 the code is

public function getCellList() {
   return array_keys($this->_cellCache);
}

Please help, thanks in advance.

This are value is my php.ini

magic_quotes_gpc = Off;
register_globals = Off;
default_charset = UTF-8;
memory_limit = 1024M;
max_execution_time = 36000;
upload_max_filesize = 1999M;
safe_mode = Off;
mysql.connect_timeout = 200;
session.use_cookies = On;
session.use_trans_sid = Off;
session.gc_maxlifetime = 172800;
allow_url_fopen = on;
;display_errors = 1;
;error_reporting = E_ALL;

But still I am getting the error.

Rikesh
  • 26,156
  • 14
  • 79
  • 87
user3324883
  • 1
  • 1
  • So what cell caching mechanism are you using? or are you just assuming that PHPExcel can store unlimited data in memory? – Mark Baker Feb 18 '14 at 19:04
  • I am new to opencart, so don't know much. Well i am having only 300 products in 50 categories, still i am getting this error. Please lemme know the step by step procedure. – user3324883 Feb 18 '14 at 19:09
  • I wrote the underlying PHPExcel library, but I've no idea who wrote the import/export tool you're using, or how they implemented it – Mark Baker Feb 18 '14 at 19:18
  • this is the tool i am using (http://www.opencart.com/index.php?route=extension/extension/info&extension_id=17) I guess now you would be able to help me, waiting for your reply. – user3324883 Feb 18 '14 at 19:26
  • No, but I'd recommend that you either increase your PHP memory limits, or contact the author of the tool.... he does warn about the high memory usage; perhaps the tool gives you the option to enable PHPExcel cell caching to reduce the memory footprint – Mark Baker Feb 18 '14 at 19:31
  • @MarkBaker Please look at the values of php.ini The memory limit is enough, still no solution. – user3324883 Feb 19 '14 at 03:55
  • `377487360` bytes of memory mentioned in the error message doesn't match the `1024M` in your php.ini - have you changed the correct php.ini file? – Mark Baker Feb 19 '14 at 07:56
  • possible duplicate of [Allowed memory size of 134217728 bytes exhausted in PhpExcel](http://stackoverflow.com/questions/19476176/allowed-memory-size-of-134217728-bytes-exhausted-in-phpexcel) – Rikesh Feb 28 '14 at 06:10

1 Answers1

0

You may needs to increase Memory Limit

memory_limit = 2048M;

It may work ! (Not mandatory 2048)

abSiddique
  • 11,647
  • 3
  • 23
  • 30