Scott Schley

I will test for power issues. The "new" hardware had no impact except to make it very slow. The RAID really makes a big difference. When I say it had no impact, I mean the server crashed repeatedly on the "new" hardware. I am also trying to test if a corruption in one of the tables could cause the server to crash. When I do a mass delete (10,000 records) the server will sometime crash. But if I delete the same records one by one with a script they delete fine. I have more to test on this theory to make sure it is a repeatable event. Is there a sure fire way to find a corrupted record?

Thank you for the input. I will check into these and let you know. The only errors I have found so far are "PHP undefined offset" errors. These seem to be minor. Today, I am moving all the databases to a new box and turning off the web hosting during the fateful hour.

Thank you for the input. My server is on a dedicated circuit in our server room with a UPS. I have started the server monitor software which should detect any issues with power as well. There are no jobs that I know of running on the server except the backups. The crashes range from about 5:15 to 6:05. I would expect a chron job to hit at the same time everyday. I have checked my logs daily to see if there is a pattern. If there is one then the server crashes before anything is record to the FM logs. The server crashed again tonight at 6:05.

Every night during the week my server crashes regularly between 5 pm and 6 pm (ie. quitting time). On the weekend, no one is logged in and the server does not crash. On occasion, the server has quit in the middle of the day, typically a Friday. Once it has quit for the day, it will be fine until the next evening. I am not recovering files. I always pull from the latest backup. When the server crashes, I have been watching the Activity Monitor. The “fmserverd” process will go away but the other two FM process will remain. To “restart” the server, I have been replacing the crashed files with my backups and started the Admin app. The “fmserverd” will startup and works fine for another 24 hours typically. Does anyone have any ideas on what could be causing this? I have tried all of the standard debugging techniques to find the source of this problem but have not been successful. Specs: -Mac OS X Server 10.4.4 with XRAID 3 gigs of RAM, gigabit Ethernet, data on raid backup to system drive every 20 minutes, crashes have no relationship to backups -Clients: cross platform all running FM8v2 and also running FM6 to access another FM Server. -Latest version of FM Server and web engine, hosting 24 files some over 2 gigs, 60 max users, only custom web publishing using FX/PHP -FM files: half of the files are mutli-table built from scratch in FM8, data imported from FM6 and merge files. One file has over 900,000 records. Other half of files, all small, converted from FM6.

After looking through the FMP Applescript dictionary, if I understand correctly, there is no way for me to import the data from an image file into a FMP field using AppleScript. Is this correct? My understaning is that Import is a FileMaker command that is not scriptable. Thank you for your help.

How can I insert an image into a FM Pro database using applescript so that the image loads not the reference to the file? The following command will insert a reference to an image. set cell "Image" to file Test_Image Thank you. ss