Tuesday, October 4, 2022
No menu items!
spot_img
HomeUncategorizedFixing the "Convert this Database" Bug
spot_img

Fixing the “Convert this Database” Bug

“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.

Conversion dialog that appears when opening file with FileMaker Pro 19.5.2
Conversion dialog bug

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:

Error entry in the 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.

Dialog when using 19.5.2 and opening a file with a non-Full Access account
File Options dialog

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.

This fix does NOT work if your file is Encrypted-at-Rest! We are experimenting with different approaches to see what can be done here and will test Claris’ utility once it is released to test with that as well.

First, make a copy of the broken file because you will be changing the actual binary content of the file, and if something goes wrong, the file will be damaged.

Windows

  1. Download the free HxD hex editor and open the copy of the FileMaker file with HxD. Use the Search menu to pick Go to…
HxD hex editor for Windows
  1. And select offset 00002020.
Select 00002020 in the HxD hex editor
  1. This will put your cursor at the start of that section of hex code.
Arrow highlighting the start of the section of hex code in the HxD hex editor
  1. Type 0514, which is Hex for 1300 – you are setting the minim required version of FileMaker to 13.00.
Red arrow highlighting 0514 entered in the HxD hex editor
  1. Save the file and close HxD. You can now open the file again in any version of FileMaker Pro, starting with 13.

macOS

  1. Download the free Hex Fiend editor, and open the copy of your FileMaker file.
  2. 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.
Views menu in the Hex Fiend editor and selecting Byte Grouping, then 1
Views menu in the Hex Fiend editor with Line Number Format select, and then Hexadecimal
Edit menu in the Hex Fiend editor, selecting Mode and then Overwrite
  1. Scroll down to line number 02020 and put your cursor in front of the first zero:
Red arrow highlighting line 02020 in the Hex Fiend editor with cursor in from of the first zero
  1. Type in 0514 (Hex for 1300 – you are setting the minim required version of FileMaker to 13.00):
Red arrow highlighting line 02020 in the Hex Fiend editor with 0514 typed in
  1. 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.

Finally

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:

Screenshot of the FIle Options opened using a Full Access account and reseting the minimum version of FileMaker required for opening the file.

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.

spot_img
RELATED ARTICLES
Continue to the category
spot_img

Most Popular

- Advertisment -spot_img
spot_img