I am running a server side script that attempts to update records in a MySQL table that is set up as an external data source. It runs without issue for hours to weeks at a time then gets hung on error 512 (Record was already modified by another user). The problem is that I can't figure out how to capture and handle this error. I've tried adding "If get(lasterror)=512 then <skip this record and continue to next> just after the 'Go to Record(next)' but it never gets to that step. Instead hangs on try to move the record pointer and writing error after error to the log.
I've searched the forums fairly thoroughly but there is not a lot of info forthcoming. Surely this has been a problem for someone else that has figured out how to handle it. Any suggestions appreciated.
Will be glad to provide more info on the environment if needed.
Thanks in advance,
By Colin Hunter
I'm running FMS 184.108.40.2060 on OS X 10.9.5. It's serving forty databases, one of which is served to the web via custom web publishing. Everything is running smoothly but the campus security auditor is picking up a vulnerability with the old version of OpenSSL running on OS X 10.9.5's Apache. I addressed this on a different, non-FMS Mac by disabling Apple's bundled Apache and using MacPorts to install Apache2.
How to do this on my FMS 11 Mac? Just getting MacPorts to install Apache2 is the first problem as port install apache2 fails with a conflicting ports message. I assume this is because the existing Apache is blocking installation of the new version but how to stop the existing one? I tried turning off web publishing in the FMS admin console but port install still fails with the familiar conflicting ports message. Even stopping the web server with Mark Banks' FMSControl didn't help.
I therefore have a couple of questions:
How do I stop the existing Apache so MacPorts will install Apache2? Once I have Apache2, how do I get FMS11 to use it instead of Apple's bundled Apache1? Thanks
Hi, I am using filemaker 11 to copy customer info from excel into the database and then it would generate special keys in pdf allowing us to send the file to the customer.
My access to the filemaker is non-admin, and the import function of customer info has been blocked.
We are keying in the record one at a time, so we are looking at ways to automate this process.
When I try to create a new record using applescript with just
it was not allowed. There are data that require validation like date and auto-indexed record number.
So, is there a way we could create new record and then using the set function to copy data into the report?
How can I get ESS access to PostgreSQL from FM11SA?
I have two filemaker servers. One is version 7 and the other is version 11 advanced. I transferred the files from FM7 server to FM11 with no problem. Long story short, everything was great until I realized that the users were still using the FM7 files. To fix the problem, I shut down the filemaker service on both servers, then made a backup of each server by copying the files to another folder. Then I removed the FM11 files that were never used and copy and pasted the .fp7 files from the FM7 server to the FM11 server. I started the filemaker service on FM11, opened the files using the FM11 console. Now when I try to open the files on a workstation, the files do not show up in the Remote list. The server console shows that they are open. How can I correct this?