I have had the same problem, that when I try to populate an excel file it is giving me 500 error, in the debug file the error it gives me is the following:
[18-Feb-2019 15:59:46 America/Los_Angeles] PHP Notice: Undefined index: in /opt/bitnami/apache2/htdocs/store/Admin/includes/excel/oleread.inc on line 138
[18-Feb-2019 15:59:46 America/Los_Angeles] PHP Notice: Undefined index: in /opt/bitnami/apache2/htdocs/store/Admin/includes/excel/oleread.inc on line 138
[18-Feb-2019 15:59:46 America/Los_Angeles] PHP Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 32 bytes) in /opt/bitnami/apache2/htdocs/store/Admin/includes/excel/oleread.inc on line 27
[18-Feb-2019 15:59:46 America/Los_Angeles] Request URI: /store/Admin/excel.php?action=populate&filename=products_20190218152224.xls, IP address: 176.79.128.18
--> PHP Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 32 bytes) in /opt/bitnami/apache2/htdocs/store/Admin/includes/excel/oleread.inc on line 27.
line 27 of my file is where the return is:
Code:
function GetInt4d($data, $pos) {
return ord($data[$pos]) | (ord($data[$pos+1]) << 8) | (ord($data[$pos+2]) << 16) | (ord($data[$pos+3]) << 24);
}
line 138 of my file is:
Code:
while ($sbdBlock != -2) {
$pos = ($sbdBlock + 1) * BIG_BLOCK_SIZE;
for ($j = 0; $j < BIG_BLOCK_SIZE / 4; $j++) {
$this->smallBlockChain[$index] = GetInt4d($this->data, $pos);
$pos += 4;
$index++;
}
$sbdBlock = $this->bigBlockChain[$sbdBlock]; // line 138
}
I would like to know how to fix the problem.
Thanks.
Bookmarks