Filemaker PHP Site Assistant - Memory Error

I'm trying to create a site using Filemaker PHP Assistant, and when I go to View Site > Record List or Find All, I get the following message:

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 4722681 bytes) in D:\Program Files (x86)\FileMaker\FileMaker Server\Web Publishing\publishing-engine\php\FileMaker\Implementation\FileMakerImpl.php on line 348

The FM database & layout that I'm using has hundreds of fields, but I excluded all but 35. I even whittled it down to the point where I was only including 1 field, and it resulted in the same error. There are 108 records in the DB.

Advice?
LVL 2
rvfowler2Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
NoiSConnect With a Mentor Commented:
Change your php.ini settings to give more memory to your PHP scripts

change

memory_limit = 512M

Open in new window


and maybe need to change


max_execution_time = 180 

Open in new window


The values are samples
0
 
rvfowler2Author Commented:
Ok, I changed php.ini settings, and had the same result.
0
 
NoiSCommented:
Same results with the same values?

>>> Allowed memory size of 8388608 bytes exhausted

If yes, so your script do not use the php.ini changed.

If the value is about 512MB so, there's some infinite loop in your code.
0
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

 
rvfowler2Author Commented:
Yes, same values.

The code for the site was generated automatically by the FM site assistant. Is it really that unreliable?
0
 
NoiSCommented:
Are you restarted the Webserver when you changed de php.ini??

0
 
rvfowler2Author Commented:
Actually, it seems to be working now, but it takes a very long time to load (about a minute). Is that normal?
0
 
NoiSCommented:
I don't have knowledge about this script.
Can be a lot of things like bad Database connection, many users on a shared machine, too many data on memory, many opened processes...

The main reason could be a poor optimized script, but I don't know nothing about FM PHP script.

1 minute to run is only acceptable by a report, or another stuff that don't have to be executed all the time.
I guess that is your case.
0
All Courses

From novice to tech pro — start learning today.