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, 201015 yr by Guest
Figured it out!

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.

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.