[eluser]regal2157[/eluser]
Mod, please delete
Hi guys,
I am running a file, which queries databases at different points. Currently, I am stuck on the third query. I run two, and after I am done processing the info, I do a $var->free_result(); call.
When I run the third though, I keep getting this error
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 42 bytes) in /usr/apps/webdata/framework/system/database/drivers/oci8/oci8_result.php on line 155
I've run larger queries than this, so I am quite lost as to why now it is happening.
Code:
<?php
$more_sql = $this->db2->query("QUERY HERE");
foreach($more_sql->result() as $row)
{
#Do Stuff
}
?>
The query works, as I test all in SQLDeveloper first. I only set a variable currently in the foreach loop, but I keep getting the memory exhausted error.
Mod, please delete