When was the uninstalling another plugin bug introduced?

[FrDH]

How can we help you?

The changelog for Version 5.16.6 states:

Fixed a bug where uninstalling another Craft plugin could remove Freeform's foreign keys, leaving related submission data behind after deletion.

I'd like to know when this bug was introduced, so we can actively ckeck and try to restore the foreign keys in affected projects.
Also, is there documentation on what the "Added console utilities" exactly are?

Is it ./craft freeform/database/repair-foreign-keys --apply=1 ?

Freeform Edition

Pro

Freeform Version

5.16.6

Craft Version

5

[kjmartens]

This bug was introduced in Freeform 5.3.4, released June 7, 2024, and fixed in 5.16.6. The uninstall handler could remove Freeform’s foreign keys when another Craft plugin was uninstalled. Projects that ran 5.3.4–5.16.5 are worth checking, especially if another plugin was uninstalled during that time.

Updating prevents it from happening again, but doesn’t automatically restore missing keys.

Yes, that’s the correct repair command. Start with a read-only inspection:

php craft freeform/database/repair-foreign-keys --dry-run=1

After reviewing the results and backing up the database, pause site writes, queue workers, and scheduled purges, then run:

php craft freeform/database/repair-foreign-keys --apply=1

Repair restores missing keys where possible without deleting submission data. Any orphaned records blocking restoration require review first.

The utilities are documented under Console Commands, including the broader read-only freeform/database/check-integrity command. 🙂