“Convert this Database” Bug
FileMaker 19.5.2 introduced a bug that can prevent you from opening your FileMaker solution. The bug manifests itself with a conversion dialog that comes up when you try to open the file with FileMaker Pro, even though the file is already in the correct file format.
If the file is hosted on FileMaker Server, on the next restart, FileMaker Server will be unable to open the file; you will find an error entry like this one in your Event.log:
The bug happens when a user with 19.5.2 opens the file with a non-Full Access account and opens the File Options menu (or runs a script step such as Spelling Options that opens that menu) and then clicks OK to close the dialog.
On that action, FileMaker writes the file options back to the file but accidentally sets the minimum required version to 0, effectively blocking any version of FileMaker from opening the file.
When this bug hits, no version of FileMaker can open the file. Using older versions of FileMaker Pro does not get around this critter.
Because this bug can affect hosted files, and those files will remain operational until the next restart, this bug can all your available backups. This leaves you with no backups of your solution that can still be opened.
19.5.3 Bug Fix
The bug has been fixed in 19.5.3 (released on August 30, 2022), which will prevent this from happening going forward.
If you cannot update your users to this new patched version of FileMaker Pro, then add a custom menu to your solution that prevents your users from manually opening the File Options menu. Check your solution for the Spelling Option script step and disable it in the interim.
The patch released by Claris does not fix files that have been affected by the bug.
You can send the file(s) to Claris for fixing; Claris is also working on a utility that they will make available to restore affected files.
How to Fix Your Files Yourself
In the meantime, however, you can fix the files yourself. Here is how.
- Download the free HxD hex editor and open the copy of the FileMaker file with HxD. Use the Search menu to pick Go to…
- And select offset 00002020.
- This will put your cursor at the start of that section of hex code.
- Type 0514, which is Hex for 1300 – you are setting the minim required version of FileMaker to 13.00.
- Save the file and close HxD. You can now open the file again in any version of FileMaker Pro, starting with 13.
- Download the free Hex Fiend editor, and open the copy of your FileMaker file.
- Change the view to 1-byte grouping with hex line numbers and set the editor to overwrite mode. Then rearrange the width of the window to show 16 columns.
- Scroll down to line number 02020 and put your cursor in front of the first zero:
- Type in 0514 (Hex for 1300 – you are setting the minim required version of FileMaker to 13.00):
- Save the file and exit out of the hex editor. You can now open the file with any version of FileMaker Pro 13 and up.
Using a Full Access account, open the File Options dialog and reset the minimum required version to what you need it to be for your solution:
We hope that these instructions can prevent you from being blocked when this bug hits. If you get stuck on any of these steps, please drop a comment below. If you have other FileMaker questions, our development team can help. Contact us to talk with a consultant today.