Modifying a schema mapping results in an error

[grantfitzsimmons]

To Reproduce
Steps to reproduce the behavior:

1. Go to a schema export mapping for DwCA
2. Modify the query
3. Save

After repeating this, I was able to press Save without an error, but no changes were saved.

Desktop (please complete the following information):

• macOS, Edge

[maxpatiiuk]

Specify 7 doesn't yet support editing schema mappings
Would be fixed in the future release

[grantfitzsimmons]

I can edit them in 7-edge!

[maxpatiiuk]

Do you get this error on edge if you delete a field from this query and try to save it?

[grantfitzsimmons]

I can only add fields- not remove them in a DwCA query. I see!

What is the difference between a query and a schema mapping fundamentally? Is it that 6 automatically gives the fields a mapping?

[maxpatiiuk]

Yes, Sp6 links each query field to a record in the schema mapping table.
The back-end does not allow deleting the field until schema mapping is deleted
But front-end does not yet know anything about schema mapping, thus this error happens

[grantfitzsimmons]

@maxpatiiuk Can you make the front-end handle the schema mapping?

[grantfitzsimmons]

https://fwri2023-issue-1694.test.specifysystems.org/specify/query/48/

#2806 does not seem to help this

[grantfitzsimmons]

("Cannot delete some instances of model 'Spqueryfield' because they are referenced through a protected foreign key: 'Spexportschemaitemmapping.queryfield'", <QuerySet [<Spexportschemaitemmapping: Spexportschemaitemmapping object (48)>, <Spexportschemaitemmapping: Spexportschemaitemmapping object (49)>, <Spexportschemaitemmapping: Spexportschemaitemmapping object (51)>, <Spexportschemaitemmapping: Spexportschemaitemmapping object (52)>, <Spexportschemaitemmapping: Spexportschemaitemmapping object (53)>, <Spexportschemaitemmapping: Spexportschemaitemmapping object (54)>, <Spexportschemaitemmapping: Spexportschemaitemmapping object (55)>, <Spexportschemaitemmapping: Spexportschemaitemmapping object (56)>, <Spexportschemaitemmapping: Spexportschemaitemmapping object (57)>, <Spexportschemaitemmapping: Spexportschemaitemmapping object (58)>, <Spexportschemaitemmapping: Spexportschemaitemmapping object (59)>, <Spexportschemaitemmapping: Spexportschemaitemmapping object (60)>, <Spexportschemaitemmapping: Spexportschemaitemmapping object (62)>, <Spexportschemaitemmapping: Spexportschemaitemmapping object (85)>, <Spexportschemaitemmapping: Spexportschemaitemmapping object (86)>, <Spexportschemaitemmapping: Spexportschemaitemmapping object (88)>, <Spexportschemaitemmapping: Spexportschemaitemmapping object (89)>, <Spexportschemaitemmapping: Spexportschemaitemmapping object (90)>, <Spexportschemaitemmapping: Spexportschemaitemmapping object (91)>]>)

Same error today reported by AAFC

https://aafcaacdao-edge.test.specifysystems.org/specify/query/61/

Specify 7 Crash Report - 2023-01-23T19 50 29.181Z.txt

[grantfitzsimmons]

Marginally(?) improved by #2929– mostly in presentation

[grantfitzsimmons]

Reported by AAFC-AAC

[grantfitzsimmons]

Still encountering today, reported by NMSU