Hierarchy Exception for Picklist on field address in Address table

[philippeverley]

Related #3564 #4989
Fixed by #5044 ?

Reporting it for the record.

Describe the bug

Specify-7 backend throws Hierarchy exception when showing Address objects with address field format as a Field PickList.

Cannot type new Address data, because field address hangs with loading message

Queries on address field never show results:

Picklist definition freezes:

To Reproduce
Steps to reproduce the behavior:

1. Go to 'Schema Config'
2. Go to 'Address' table
3. Select field 'address'
4. Create pick-list based on 'address' field
5. Go to new Address data entry https://url/specify/view/address/new

Expected behavior

I do not expect error and I should be able to use new Address form.

Crash Report

Specify 7 Crash Report - 2024-11-21T12_02_24.151Z.txt

Please fill out the following information manually:

• OS: Ubuntu 24.04 LTS
• Browser: Firefox 132
• Specify 7 Version: 7.9.? (not showing)
• Database Name: VIROT3 (NOU)
• Collection name: Herbier de Nouvelle-Calédonie
• User Name: pverley (institution admin)
• URL: https://virot3.ird.nc (not public)

Reported By
IRD - Institut de Recherche pour le Développement