Just saw on a Filemaker Support page that FMS11 requires at least version 5.3 of PHP. Could that be the problem? Why would it work most of the time but not always? What could be triggering the sporadic outages?
- a permissions issue
- another issue with your code which you haven't shown us.... eg. $formdata
Whenever I get this undefined method, I can always find the problem in the code on my pages.
That said, PHP 5.3 is a lot less forgiving than previous versions and finds quite a few errors (mostly insignificant) on filemaker.php or support code... particularly with dates.
Perhaps your $formdata has an extraneous comma? Try eliminating all but one field from $formdata and see if it adds the record. Make sure it is a text field.
I also edited one servers php configs for error reporting... as many can be ignored and skipped over.
Here's an update, in case anyone else has this problem......
I continued to see sporadic failures on the server running PHP 5.1. I'm reasonably sure the problem was not related to any anomalies in input data.
I implemented a temporary fix. I used PHP's "method_exists" function prior to the execute call. If the function returned false, I used a PHP redirect to transfer to a new server running PHP 5.3 and created the new record from there. (Had to transfer all the data too.) That worked every time.
I've since moved the entire site to the new server. I have not seen a failure since the move.