Upgrading from 4.11.3 to the latest 4.12.2 throws up an SQL error:
insert or update on table "chackitem" violates foreign key constraint "checkitem_checkitem_curr_id_fkey"
Key (checkitem_curr_id)=(1) is not present in table "curr_symbol"
My curr_symbol table has 3 entries, with ID's of 2-4 (I assume very early in our setup process years ago that an entry must have been deleted). If I manually edit the table to add an extra currency with an ID of '1' then the update works. This is a poor fix though, as it leaves me with an extra currency in the system which is not needed.
Is this a bug in the update script, or is there something else I have to do first?