[FX.php List] fx.php, Swiftmailer and Webviewer Cause Filemaker Server to Hang?

[Dennis Dalziel]

I've figured out the problem, the database that I was performing the find on
has a relationship to a remote database and the find seems to need to wait
to bring back data from the remote server. Even thought the layout I was
searching had no fields displayed from the remote database. Doing this type
of linkup with Filemaker is fairly speedy but using php it slows to a crawl.

 

Thanks,

 

Dennis Dalziel

Production Manager

G & R Publishing Co.

507 Industrial Street

Waverly, IA 50677

319-352-5391

 

From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Dennis Dalziel
Sent: Wednesday, April 30, 2008 12:30 PM
To: 'FX.php Discussion List'
Subject: [FX.php List] fx.php, Swiftmailer and Webviewer Cause Filemaker
Server to Hang?

 

I've created a fx.php page that attempts to send an email using Swift
mailer. I trigger the page by sending the recid in a GET variable via the
URL and Filemaker's  webviewer to get an account's email address via a
fx.php find and then send the email. Everything started out working fine,
the page loaded very quickly and the email went as it should. 

 

After continuing to work on the database, and leaving this routine alone, I
have all of a sudden had this php page hang whenever it is loaded. If you
view the database in the Filemaker Server Console you can see that a request
is being made of the server and at the same time all other fx.php requests
that are coming from other pages are being blocked and everyone of the other
pages that I have running that rely on the same Filemaker server to process
requests hangs as well. The only way that I've been able to get everything
working again is to close the database with the mailing routine.

 

Redoing the fx.php page to just do a simple find would also hang the request
of the server. I tried changing the layout that was referred to, by the
find, with the same result. If I changed the database, the fx.php page was
using,  then the request would go through without a hitch. So I thought the
database was corrupted somehow. I ran all the recovery and file maintenance
routines and still the find request would fail.

 

I finally had to get a backup copy of the database from a few days before
and then everything worked again, for a time. My problem is that this has
now happened again and I'm at a loss as to why. We have many pages using
fx.php and this one database is breaking them all when a simple find request
to the server is made.

 

Has anyone else experienced this and is there a reason why it would happen?

 

Dennis Dalziel

Production Manager

G & R Publishing Co.

507 Industrial Street

Waverly, IA 50677

319-352-5391

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20080430/d3957f6e/attachment-0001.html