[SOLVED] HELP! Fatal Error - Allocated memory error - setting solution??

[danabase]

I found the php.ini file and edited the memory_limit to 32MB, and that did the trick!

Hi all,

I am receiving this error when I query to a new list page I created:

Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to allocate 76 bytes) in /Library/FileMaker Server/Web Publishing/publishing-engine/php/lib/php/PEAR.php on line 868

Any help? I can view the found set on other list pages, but this one page with a set of about 8 fields, gives that error message after listing 77 of the records. The total set is 165 records. I can login as different Users who have smaller record sets (110 is the next largest), and they do not receive the error. I'm not sure what to do - but this is a LIVE system and I am hoping to be pointed in the right direction.

The server is FMS 9.0.3.326 on a dedicated Mac running Leopard. The machine has 3GB of RAM. I am hoping I can fix this with a change in a setting somewhere.

Any and all advice would be appreciated. Thanks!

-dana

Edited June 29, 2010 by Guest
Figured it out!

[CCBtx]

That message also indicates that you are querying the entire table and the return result is overloading the reply. You should find a way to limit your query to only the records you desire to return... presumably not the entire table.

[CCBtx]

That message also indicates that you are querying the entire table and the return result is overloading the reply. You should find a way to limit your query to only the records you desire to return... presumably not the entire table.