Upgrade script 1026 transposes metabib_field.id
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Evergreen |
Fix Released
|
Undecided
|
Unassigned |
Bug Description
Release 2.12.0 upgrade script 1026.data.
SET browse_field = FALSE
WHERE field_class = 'subject' AND name = 'geographic'
AND id = 13; (this should be 11)
UPDATE config.
SET browse_field = FALSE
WHERE field_class = 'subject' AND name = 'temporal'
AND id = 11; (this should be 13)
And again when updating authority.
UPDATE authority.
SET metabib_field = 35
WHERE metabib_field = 13; (this should be 11)
UPDATE authority.
SET metabib_field = 36
WHERE metabib_field = 11; (this should be 13)
The version upgrade script 2.11.3-
The scripts run without error. I happened to notice this because we have some custom indexes using ID's 34, 35, 36 and I had to go into the script to update with our ID numbers and noticed the mismatch.
Changed in evergreen: | |
status: | New → Confirmed |
milestone: | none → 2.12.1 |
Changed in evergreen: | |
status: | Fix Committed → Fix Released |
A patch is available at the tip of the user/gmcharlt/ lp1680554_ fix_browse_ def_ids branch:
http:// git.evergreen- ils.org/ ?p=working/ Evergreen. git;a=shortlog; h=refs/ heads/user/ gmcharlt/ lp1680554_ fix_browse_ def_ids